DuckDB CLI

DuckDB·DuckDB.cli

DuckDB is an in-process SQL OLAP Database Management System

DuckDB is a high-performance analytical database system. It is designed to be fast, reliable and easy to use. DuckDB provides a rich SQL dialect, with support far beyond basic SQL.

winget install --id DuckDB.cli --exact --source winget

Latest 1.5.5·July 22, 2026

Release Notes

This is a bug fix release for various issues discovered after we released v1.5.4. What's Changed

  • backport the out-of-bounds security fixes made in #23100 by @Tishj in #23197
  • Remove checked_array_iterator from fmt dep (1.4) by @carlopi in #23261
  • Remove checked_array_iterator from fmt dep (1.4) by @staticlibs in #23239
  • [Dev] Add LLDB scripts to help with debugging by @Tishj in #23297
  • Add support for test config extending by @NiclasHaderer in #23145
  • bump iceberg again by @Tmonster in #23311
  • Correctly get typed value stats for fully shredded variants by @Mytherin in #23325
  • bump unity to include backfill fix by @benfleis in #23326
  • Add request body length to http logs by @DinosL in #23316
  • Show transport errors in HTTP log by @DinosL in #23327
  • Dispatch Rust nightly build by @mlafeldt in #23352
  • parquet: reject DATA_PAGE_V2 pages with inconsistent compressed_page_size by @benfleis in #23279
  • Fix deadlock in TemporaryMemoryManager by @lnkuiper in #23351
  • Register oid of dependencies in the DependencyManager so that we can track if an object was re-created with the same name by @Mytherin in #23348
  • [Dev] Fix recursion issue with scripts/lldb/pointer_print by @Tishj in #23362
  • [MultiFileReader] Prevent NULL MAP keys because of (likely missing) default value by @Tishj in #23354
  • Propagate lambda bindings into try operator by @Mytherin in #23375
  • Bump Julia to v1.5.4 by @carlopi in #23398
  • Add additional guards to DICT_FSST to prevent exception during compression with small block size by @sebastiaan-dev in #23341
  • fix out-of-bounds read in json path ReadKey lookahead by @jmestwa-coder in #23371
  • fix out-of-bounds read in string to struct cast by @jmestwa-coder in #23384
  • Issue #23383: Common Aggregate CTEs by @hawkfish in #23409
  • Use correct start time when verifying dependencies by @Mytherin in #23430
  • Fix false RLE corruption error by @DinosL in #23458
  • [v1.5] No cache if file doesn't contain version information by @dentiny in #23434
  • Improve rle corruption error messages by @DinosL in #23480
  • Issue #23457: Ordered FIRST_VALUE Framing by @hawkfish in #23499
  • Enabled ALP and ALP_RD for storage version v1.5.0 and up when using smaller block sizes by @sebastiaan-dev in #23483
  • [v1.5] Backport PR #23444: fix eviction node memleak when external fi… by @dentiny in #23479
  • [v1.5] Fix min/max aggregate stats when row groups filtered by @dentiny in #23517
  • Backport #23468 and #23510 by @artjomPlaunov in #23529
  • Fix arrow type extension bugs by @evertlammerts in #23534
  • Issue #23500: JSON TIMESTAMP_TZ Formatting by @hawkfish in #23513
  • fix out-of-bounds read in dictionary string decompression by @jmestwa-coder in #23549
  • Merge v1.4 into v1.5 by @carlopi in #23560
  • [ADBC] Add support for duckdb:// URI scheme in URI option by @amoeba in #21293
  • Fix/capi scalar bind subquery crash by @krleonid in #23566
  • [variegata] Bump extensions by @carlopi in #23562
  • Fix filter combiner not pruning unsatisfiable bounds by @DinosL in #23563
  • fix out-of-bounds read on empty byte array decimals by @jmestwa-coder in #23567
  • [v1.5] Quickfix ALTER TABLE ADD COLUMN IF NOT EXISTS ... DEFAULT regression by @yan-alex in #23507
  • Bump version map to include v1.5.5 by @carlopi in #23629
  • backport #23548 to v1.5 by @myrrc in #23587
  • Issue #23641: CUME_DIST Underflow by @hawkfish in #23651
  • Fixed unsafe iteration when parent is NULL in string cast by @sebastiaan-dev in #23593
  • Bump HTTPFS by @lnkuiper in #23648
  • backport #23573 by @artjomPlaunov in #23672
  • fix(adbc): support the ADBC Statistics API by @eitsupi in #23230
  • Issue #23664: RANGE ZERO by @hawkfish in #23710
  • Fix DROP COLUMN corrupting per-column metadata block bookkeeping by @ywelsch in #23714
  • Include extension header in libduckdb archives by @mlafeldt in #23752
  • Correctly promote SUGGEST_NEW to REQUIRE_NEW for variant / geometry columns by @Mytherin in #23763
  • Fix lance build on Rust 1.97: patch its Cargo.lock to ethnum 1.5.3 by @carlopi in #23770
  • Bump Postgres, MySQL and SQLite in 1.5 by @staticlibs in #23780
  • Fix segfault in external hash aggregate when radix bits grow after going external by @carlopi in #23757
  • Add HTTPUtil::ShouldRetry(request, response) retry-classification hook by @carlopi in #23793
  • Bump azure, unity_catalog extensions to v1.5-variegata HEAD by @benfleis in #23800
  • Bump extensions in preparation for v1.5.5 by @carlopi in #23794
  • bump iceberg by @lnkuiper in #23735
  • Fix for malformed JSON when rendering via duckbox by @sebastiaan-dev in #23803
  • [v1.5] Backport a few fix PRs for v1.5.5 release by @dentiny in #23804
  • bound alp/alprd exception positions to vector size by @jmestwa-coder in #23778
  • Fix swapped min/max for multi-row-group 128-bit DECIMAL in RETURN_STATS by @sfc-gh-okalaci in #23693
  • [variegata] Bump quack to 8e715ebb by @carlopi in #23820
  • backport #22198 by @artjomPlaunov in #23810
  • [v1.5] Backport two more fixes by @dentiny in #23841
  • [DependencyManager] Fix ALTER dependency preservation by @Tishj in #23808
  • TryLookupEntry now uses default schema as fallback by @okruitho in #23790
  • Fix concurrent ALTER and INSERT crash by @Tishj in #23861
  • Bump Postgres extension for 1.5 by @staticlibs in #23930
  • [v1.5 backport] Fix: reset empty_range in the TIMESTAMP range() table function by @wmTJc9IK0Q in #23879
  • Bump extensions for v1.5.5: quack, httpfs and aws by @carlopi in #23892
  • Expose destructors, so they are callable module boundaries by @carlopi in #23953
  • Bump DuckLake by @pdet in #23962
  • Fix OSX ci by @Tmonster in #23963
  • Bump lance pin to upstream ethnum fix, drop local patch by @carlopi in #23969
  • Add missing statement types to capi by @hrl20 in #23407
  • Bump httpfs by @lnkuiper in #24003 Full Changelog: v1.5.4...v1.5.5

Installer type: zip

x64E1428B7114A841626B5054723731CBF45C6DF91B42AE1A6C355F88FAD1F6DC4C
arm649D0370D085684E1619ECC5EFB2656CDE930C50F1418380F0AE9D0379DDF06B12

Details

Homepage
https://github.com/duckdb/duckdb
License
MIT
Publisher
DuckDB
Support
https://github.com/duckdb/duckdb/issues
Copyright
Copyright (c) Stichting DuckDB Foundation
Moniker
duckdb-cli

Tags

analyticsdatabaseembedded-databaseolapsql

Older versions (30)

1.5.4
x6409E27C773EAAB396754CBAA8FDBC5055C0006DB4A579439839C7BB671894610F
arm64EF9925EAB44F01D3A885FA5E612D1E27E692C0AA8F25F20599D0FFFB42D8D29C
1.5.3
x642ABA634FAB91B3CB3F88CB7A75A9539B47EF240A76F4D4FF8D1E48821C8CCD7F
arm64CBD135F2999CC75F77B8F4A511E7D2365FA4A77CDC805C439DE303380EF0EAB4
1.5.2
x64D7B4F5774419C2E9EB14CB7361D3488821EF0244F8AF461FD2C6FCB6F43BC3E0
arm647908E22D25E6991F45E895B1613277E2A600EEC6721253F45CE10CDE6A3FFDAF
1.5.1
x6422CC4B9DCFFE6B01300D2E78B5918A13CF4335305FEC854A9277DB3BBF2E4A83
arm64F60B55F069F8A950CA8C61464AF23F5D3D9DDC2B82152D6F55AD060F7EC6A436
1.5.0
x6490D5187208939CFFCE62736C7293D7EFB25AED057C23AFB5A17296C1A2C236DE
arm646F61ECFEAF12F3D72EC3909BED2D436B1BEC3A07CB00FEC58084C1E5EC73BFFD
1.4.4
x64CD24E5736AC69A33DC1411209F161DED5595FFC578E3CF016474346C64A87F5E
arm64ED4B333A0BFD783137F47421F49E35F5998461C47C2A1283E5FF17A5FCF5E511
1.4.3
x646AF7C45F38D764D1C8345F1CB1B1F2D07D779E11125DDF5DCA7F2DFDF50EFC7E
arm64DA59FB52AC8B9C0D71E1B0030A6C3A4BDD71A5F026DD52A76623BDABA72AAC73
1.4.2
x642A31D67CF54AEC3494FB331147EDDDFEE1CD7F3FADCB5B84056F9BC28CF76576
arm6456965CAA343D1C2914BF372E1FA2ED2A5842B081DA2252FF93A9ABC99744AB55
1.4.1
x643FAB5174658BF16189C80EAA047B3E7737847491C9E4433A985ADF014618CBD9
arm64B753187A285F491BF7E2DFBB0B893F551390806F6944D9F1764A7AA7E69D9DBB
1.4.0
x64EFCEAB16ECE9E6BE24DDD1CE82A58CA23D27BC4C5DEFBEA40E3BCB82ADEED41A
arm6453437F18D671A14A09CF742A5CD18F006AFAB0212C9A655F9D922E12C84505EB
1.3.2
x640F20F96CC83540817E9E42F88D1F62E5452A9A2B4FCDEF7F97CFC94A971D313F
arm64C8093EF9BDFA27D06B3F4F3D9A858044B7EAC07E6A799012F5F722DC07242EB8
1.3.1
x64A9F51426860649158C3D89A04FA7C741343C545237CED49C60CF67E065E9C828
arm64D9282EC79ABA34E9E60F3B0976AD71D4E8B7EDF3367E9583787735E2B4A00A20
1.3.0
x64A04F7BDC21F077A4F7CE931D8DE85F3606A46663F6CA413D3142DF22A856D895
arm64BA3EE68D776F5207FC96C8F06C71CCBF0CF430B0048691E01CB8AE16624953D2
1.2.2
x649D35FBA121F011B06D5F256C2AC351AE5C2468DE8156524C75082B2E4A810FFE
arm6465670F613560F49D8652200079254C37F16A21FDDDF5303C401817AED82137D7
1.2.1
x64B0A7B85409F2AECF8535CB7DAA8A29D9325B62850E5A24752A7146C65E3A32EB
arm64C2532524A6AA13C13FB3C3CCB5F8BAC7DD68B0BC7EE31C2DEAB8E41355C81B46
1.2.0
x643F3194799C1F289FF570CEF9191168EA5D6743202D4445DD6D5EE669A8586435
arm64F0AE6C1BF95DB9D8BA5BAA59145F64B64C26B9E20E19F76B8FB30F44CDFD1FFE
1.1.3
x64D98F8163D5FD631EEDBD6C868AEC77A825EA05294DB10BDDE79C08D97790B514
arm646E0F6B58822EC85A743160F9B13E20919100C317D3150047F1B22779EB3250E7
1.1.2
x644526171D1FC43C9BD68BD23483BC60B94FC2C7A2B3BB78F1C3CD7D90ED2091D4
arm640d1fa973a31ff9c7b8075473a9f2546d154e1f17b755defdfbf049b2aacbf961
1.1.1
x64E8347A5EE6954282A09FDF3B8D475CD090094F15A1B6C42991ABEFC88582D64A
1.1.0
x64220C451966F086794744BFC28ED1A3395B85B60B6CBB797D1869ADA564BE2676
1.0.0
x64EBFB73DA9496F476832BD71396F0F8589A0A3198066EC7620FB71D57E1AF7274
0.10.3
x64ECFBAE45236F0BC6FF580CAEEA6E89B2E83C7B587ED0CC34B1F6687649C95546
0.10.2
x64D2CAD4404BBCC0F39DBDED02DE623794D8439EEA034B3153C0DA51F04E59520D
0.10.1
x64A5D84EA867EEAA81AE849E0FC0D9201A1EF167BD382FC68531A202682F8CF0C4
0.10.0
x642F8D446B47ECBFFDEACE97CAA4D3D8501B6572BBB50D00D8F862012437E147BA
0.9.2
x64880FE01FF24A13DDEA8A9609A4BA0CEFFD246A9D497A345EFC406CC1792445E4
0.9.1
x64DE03D0A9EF676C4A04249E15DF1823063D489385C9D639A10B4F3F00B2C11493
0.9.0
x64177C49B1AC45D7E158824DCE5EB65B0506B5FA06B66BC72A75081A525E73C909
0.8.1
x8612B98191CCC58A78B01967EF5ADC3F4259A0A4AFC6ECEA10E97033F27501A55F
x641E882F21115D44D34BB8DC853FD05338A46D5EE089E62FDF2CAB98F8455A9921
0.8.0
x865ECC36FD23C0763EFD077102D310E1C19C151BC3FA34043B709B68646E875B6D
x640B56BC5BB1BA3B87D7D510AE7CDE8FFBD9D62D186BA4BA9F251612EE07F1ECDC