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.3

Release Notes

This is a bugfix release for various issues discovered after we released v1.5.2. Please also refer to the announcement blog post: https://duckdb.org/2026/05/20/announcing-duckdb-153 What's Changed

  • Use DB serialization compatibility for json_serialize_sql by @kryonix in #22004
  • DuckLake Bump by @pdet in #22014
  • fix: resolve current catalog in ADBC Ingest to avoid temp table shadowing by @eitsupi in #22020
  • Fix TIMESTAMPFORMAT being ignored for TIMESTAMPTZ columns in copy to json by @DinosL in #21992
  • Provide BWC support for join filter pushdowns by @ywelsch in #22029
  • Add iceberg copy function autoload by @NiclasHaderer in #22037
  • Fix DISABLE_EXTENSION_LOAD by @mlafeldt in #22019
  • Fix INSERT OR REPLACE BY NAME regression by excluding conflict columns from SET list by @DinosL in #22049
  • Git-ignore generated extension loader by @mlafeldt in #22056
  • Fix constant struct args in lateral table in-out functions by @AlfieJones in #21827
  • Avoid handling Ctrl+C during shutdown (state might be already gone) by @carlopi in #22059
  • Add DISABLE_BUILTIN_HTTPLIB option by @carlopi in #22054
  • Set query field for statements in ALTER TABLE ... ADD COLUMN ... DEFAULT ... workaround by @yan-alex in #22057
  • Coorporative tasks might lead to busy spinning in TaskExecutor::WorkOnTasks by @NiclasHaderer in #22092
  • Row group append by @evertlammerts in #22060
  • Fix empty parquet child schema by @dentiny in #22105
  • Issue #22096: TopN Window Casts by @hawkfish in #22098
  • Add support for reading VARIANT using C API by @Dtenwolde in #22065
  • Bump Julia to v1.5.2 by @taniabogatsch in #22121
  • fix commit iteration offset bug + relax RemoveFromIndexes assertion by @artjomPlaunov in #22094
  • Internal #8812: From TIMESTAMPTZ Casts by @hawkfish in #22000
  • Only build plan_serializer when building the main DuckDB library by @rustyconover in #22100
  • Fix Row Group Pruner Distinct Bug by @d-justen in #22132
  • Correctly skip preprocessing PIVOT MultiStatements by @yan-alex in #22141
  • fix(adbc): report the table name if the table doesn't exist when appending by @eitsupi in #22146
  • [v1.5 patch] Attempt to fix cache read by @dentiny in #22126
  • Also execute auto-rollback on CLI ClientContext::Query() query by @yan-alex in #22159
  • Fix window self join optimizer by @kryonix in #22164
  • Account for ROW_GROUP_SIZE when deciding whether to append to an existing row group by @evertlammerts in #22109
  • Use the latest storage version for temp storage by @Mytherin in #22169
  • Fix: Add pg_catalog.pg_collation compatibility view for SQLAlchemy 2.0.45 reflection by @alonfaraj in #22160
  • Fix CSV escape by @dentiny in #22176
  • Fix union_by_name remap for non-nested parquet columns by @feichai0017 in #22177
  • User-facing enable_caching_operators setting by @lnkuiper in #22191
  • Fix bignum sum Combine to correctly take over memory ownership of state by @Mytherin in #22209
  • CompressedFile::Close -> calls Close on its child_handle by @benfleis in #22149
  • ISSUE-22061: Fix JSON shell output: emit BOOLEAN as true/false, not strings by @herbenderbler in #22073
  • [Bugfix] Reset pg_err_pos in pg_parser_init to prevent stale error position leaking by @p1p1bear in #22239
  • Bump httpfs to 3139e40a by @carlopi in #22248
  • Correctly use new row group when checkpointing, and avoid incorrectly re-using metadata when targeting older storage versions and row ids have changed by @Mytherin in #22253
  • Fix: release ParquetReader when a file is marked SKIPPED in multi-file scan by @J-Meyers in #22261
  • Fix UTC±NN00 cannot be parsed in SQL by @tianjq16 in #22244
  • Defer Bloom Filter Pushdown until it's done by @lnkuiper in #22218
  • [v1.5] Backport ADBC memleak fix on error path by @dentiny in #22216
  • Allow package builds to choose linked extensions by @mlafeldt in #22305
  • Fix UTC+HHMM time zone was parsed incorrectly by @tianjq16 in #22297
  • Bump httpfs by @carlopi in #22312
  • Exception format: accept string literals by @carlopi in #22314
  • Skip schema analysis even if no shredding for rowgroup by @rgernhardt in #21937
  • Use batch limit for table scans with filters by @Mytherin in #22315
  • Also redacting bearer token for HTTP secrets by @hannes in #22323
  • First initialize system, then load extensions (to peek at file to be opened) by @carlopi in #22341
  • Node Handle Scoping fix by @artjomPlaunov in #22344
  • Enable windows_amd64 for lance extension by @carlopi in #22367
  • Internal #9003: TIMETZ Parsing Limit by @hawkfish in #22378
  • Downcasting decimal fix incorrect out of range error by @Dtenwolde in #22386
  • GetLocalFileSystem improvements by @carlopi in #21983
  • Fix double decrement of evicted_data_per_tag in .block read-back by @krleonid in #22394
  • RowGroup Operator metrics: sequentially scanned row groups + total row groups + cumulative counterparts by @artjomPlaunov in #22339
  • PostgreSQL compatability: in pg_catalog.pg_database simulate columns datallowconn, datistemplate by @muayyad-alsadi in #22302
  • Fix eviction size metrics report by @dentiny in #22452
  • Fix enable_logging() silently resetting logging_storage by @guillesd in #22475
  • Avoid 3 instances of idx_t - idx_t > 0, and avoid unnecessary check on zLine by @carlopi in #22518
  • Fix RESET my_global_extension_setting to actually be GLOBAL by @carlopi in #22520
  • Fix BlockAllocator invalid memory access by @dentiny in #22503
  • Patch httplib by making ThreadPool constructor more solid on pthread_create failures by @carlopi in #22516
  • Fix duck fuzz #4430 by @dentiny in #22435
  • Test runner: avoid running clean-up routine if there is no database to run it in by @Mytherin in #22540
  • Fix bare numeric interval parsing at end of string on v1.5 by @M1llerF in #22534
  • Fix parquet metadata cache validation by @dentiny in #22547
  • ExtensionInstall: Remove use of IsHTTP to IsRemoteFile by @carlopi in #21900
  • Fix variant write small decimal by @dentiny in #22544
  • Move http_proxy setting to global setting, and use GetEnvVariable('HTTP_PROXY') as default by @carlopi in #22541
  • Bump httpfs and remove patches by @carlopi in #22556
  • Bump Postgres, MySQL and ODBC by @staticlibs in #22579
  • Bump avro, azure, delta, ducklake, spatial, unity_catalog and vortex by @carlopi in #22554
  • Fix variant selection vector index by @dentiny in #22573
  • Fix for SIGABRT in setting size on zero-capacity vector by @ccfelius in #22571
  • Fix incorrect profiling results when using LIMIT by @sebastiaan-dev in #22561
  • Move Jemalloc into core by @Maxxen in #22558
  • Allow json ts format variation across columns - issue 22103 by @benfleis in #22559
  • Limit parallel linker jobs to avoid out-of-memory errors by @smvv in #22588
  • ARTOperator::Delete return false if rowid not found in nested ART leaf by @artjomPlaunov in #22591
  • Enable/disable jemalloc linking through BUILD/SKIP_EXTENSIONS by @Maxxen in #22594
  • Bump AWS extension by @staticlibs in #22600
  • bump spatial again by @Maxxen in #22602
  • Jemalloc is not an extension anymore by @carlopi in #22603
  • bump iceberg by @Tmonster in #22608
  • CUMULATIVE_VACUUM_TIME metric by @artjomPlaunov in #22425
  • parser_tools is apparently now a dependency for postgres by @carlopi in #22619
  • Bump DuckLake for release by @pdet in #22651
  • Bump lance to 533e0ee6cf419e4be2af3af56182fb04b87978e1 by @carlopi in #22640
  • Add storage informations for v1.5.3 by @carlopi in #22638
  • Add quack autoloading by @carlopi in #22631
  • Add quack extension by @carlopi in #22614
  • bump aws extension by @samansmink in #22623
  • bump avro+iceberg+vcpkg-duckdb-ports by @Tishj in #22621
  • optimizer: don't return truncated VARCHAR MIN/MAX from statistics by @nahomar in #22538
  • Bump excel / remove patch by @carlopi in #22633
  • Bump sqlsmith, remove patch by @carlopi in #22622
  • Fix free block for temporary file manageer by @dentiny in #22616
  • Add dummy cmake target for jemalloc by @evertlammerts in #22632
  • Bump quack by @carlopi in #22659
  • Fix invalid access for file row number by @dentiny in #22662
  • Fix enum type write to parquet by @dentiny in #22677
  • Add write_buffer_row_group_memory_limit setting which controls when to flush row groups based on memory instead of only based on row group count by @Mytherin in #22666
  • Fix max file row number by @dentiny in #22688
  • Fix new jemalloc plumbing by @mlafeldt in #22628
  • Bump DuckLake by @pdet in #22698
  • Fix timer lifetime/timing issues by @taniabogatsch in #22697
  • Enable jemalloc heap profiling with the libgcc unwinder by @mlafeldt in #22630
  • Fix jemalloc thread flush threshold check by @xuke-hat in #22670
  • Make several storage internals public by @samansmink in #22718
  • Fix GCC jemalloc symbol leakage CI failure by @lnkuiper in #22729
  • Fix iterator invalidation in ConnectionManager::GetConnectionList by @bleskes in #22719
  • Bump quack, fixes quack_serve on wasm by @carlopi in #22722
  • bump iceberg again by @Tmonster in #22723
  • fix: list_zip SEGFAULT with empty / NULL argument by @carlopi in #22726
  • Fix .sanitizer-thread-suppressions.txt jemalloc ref by @carlopi in #22736
  • Revert "Enable jemalloc heap profiling with the libgcc unwinder" by @carlopi in #22740
  • RowGroupPruner: treat UNSET LIMIT as unbounded by @ColtenOuO in #22744
  • Return an error if a negative number is passed to the factorial function by @DinosL in #22731 Full Changelog: v1.5.2...v1.5.3

Installer type: zip

Architecture Scope Download SHA256
x64 Download 2ABA634FAB91B3CB3F88CB7A75A9539B47EF240A76F4D4FF8D1E48821C8CCD7F
arm64 Download CBD135F2999CC75F77B8F4A511E7D2365FA4A77CDC805C439DE303380EF0EAB4

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 (28)

1.5.2
Architecture Scope Download SHA256
x64 Download D7B4F5774419C2E9EB14CB7361D3488821EF0244F8AF461FD2C6FCB6F43BC3E0
arm64 Download 7908E22D25E6991F45E895B1613277E2A600EEC6721253F45CE10CDE6A3FFDAF
1.5.1
Architecture Scope Download SHA256
x64 Download 22CC4B9DCFFE6B01300D2E78B5918A13CF4335305FEC854A9277DB3BBF2E4A83
arm64 Download F60B55F069F8A950CA8C61464AF23F5D3D9DDC2B82152D6F55AD060F7EC6A436
1.5.0
Architecture Scope Download SHA256
x64 Download 90D5187208939CFFCE62736C7293D7EFB25AED057C23AFB5A17296C1A2C236DE
arm64 Download 6F61ECFEAF12F3D72EC3909BED2D436B1BEC3A07CB00FEC58084C1E5EC73BFFD
1.4.4
Architecture Scope Download SHA256
x64 Download CD24E5736AC69A33DC1411209F161DED5595FFC578E3CF016474346C64A87F5E
arm64 Download ED4B333A0BFD783137F47421F49E35F5998461C47C2A1283E5FF17A5FCF5E511
1.4.3
Architecture Scope Download SHA256
x64 Download 6AF7C45F38D764D1C8345F1CB1B1F2D07D779E11125DDF5DCA7F2DFDF50EFC7E
arm64 Download DA59FB52AC8B9C0D71E1B0030A6C3A4BDD71A5F026DD52A76623BDABA72AAC73
1.4.2
Architecture Scope Download SHA256
x64 Download 2A31D67CF54AEC3494FB331147EDDDFEE1CD7F3FADCB5B84056F9BC28CF76576
arm64 Download 56965CAA343D1C2914BF372E1FA2ED2A5842B081DA2252FF93A9ABC99744AB55
1.4.1
Architecture Scope Download SHA256
x64 Download 3FAB5174658BF16189C80EAA047B3E7737847491C9E4433A985ADF014618CBD9
arm64 Download B753187A285F491BF7E2DFBB0B893F551390806F6944D9F1764A7AA7E69D9DBB
1.4.0
Architecture Scope Download SHA256
x64 Download EFCEAB16ECE9E6BE24DDD1CE82A58CA23D27BC4C5DEFBEA40E3BCB82ADEED41A
arm64 Download 53437F18D671A14A09CF742A5CD18F006AFAB0212C9A655F9D922E12C84505EB
1.3.2
Architecture Scope Download SHA256
x64 Download 0F20F96CC83540817E9E42F88D1F62E5452A9A2B4FCDEF7F97CFC94A971D313F
arm64 Download C8093EF9BDFA27D06B3F4F3D9A858044B7EAC07E6A799012F5F722DC07242EB8
1.3.1
Architecture Scope Download SHA256
x64 Download A9F51426860649158C3D89A04FA7C741343C545237CED49C60CF67E065E9C828
arm64 Download D9282EC79ABA34E9E60F3B0976AD71D4E8B7EDF3367E9583787735E2B4A00A20
1.3.0
Architecture Scope Download SHA256
x64 Download A04F7BDC21F077A4F7CE931D8DE85F3606A46663F6CA413D3142DF22A856D895
arm64 Download BA3EE68D776F5207FC96C8F06C71CCBF0CF430B0048691E01CB8AE16624953D2
1.2.2
Architecture Scope Download SHA256
x64 Download 9D35FBA121F011B06D5F256C2AC351AE5C2468DE8156524C75082B2E4A810FFE
arm64 Download 65670F613560F49D8652200079254C37F16A21FDDDF5303C401817AED82137D7
1.2.1
Architecture Scope Download SHA256
x64 Download B0A7B85409F2AECF8535CB7DAA8A29D9325B62850E5A24752A7146C65E3A32EB
arm64 Download C2532524A6AA13C13FB3C3CCB5F8BAC7DD68B0BC7EE31C2DEAB8E41355C81B46
1.2.0
Architecture Scope Download SHA256
x64 Download 3F3194799C1F289FF570CEF9191168EA5D6743202D4445DD6D5EE669A8586435
arm64 Download F0AE6C1BF95DB9D8BA5BAA59145F64B64C26B9E20E19F76B8FB30F44CDFD1FFE
1.1.3
Architecture Scope Download SHA256
x64 Download D98F8163D5FD631EEDBD6C868AEC77A825EA05294DB10BDDE79C08D97790B514
arm64 Download 6E0F6B58822EC85A743160F9B13E20919100C317D3150047F1B22779EB3250E7
1.1.2
Architecture Scope Download SHA256
x64 Download 4526171D1FC43C9BD68BD23483BC60B94FC2C7A2B3BB78F1C3CD7D90ED2091D4
arm64 Download 0d1fa973a31ff9c7b8075473a9f2546d154e1f17b755defdfbf049b2aacbf961
1.1.1
Architecture Scope Download SHA256
x64 Download E8347A5EE6954282A09FDF3B8D475CD090094F15A1B6C42991ABEFC88582D64A
1.1.0
Architecture Scope Download SHA256
x64 Download 220C451966F086794744BFC28ED1A3395B85B60B6CBB797D1869ADA564BE2676
1.0.0
Architecture Scope Download SHA256
x64 Download EBFB73DA9496F476832BD71396F0F8589A0A3198066EC7620FB71D57E1AF7274
0.10.3
Architecture Scope Download SHA256
x64 Download ECFBAE45236F0BC6FF580CAEEA6E89B2E83C7B587ED0CC34B1F6687649C95546
0.10.2
Architecture Scope Download SHA256
x64 Download D2CAD4404BBCC0F39DBDED02DE623794D8439EEA034B3153C0DA51F04E59520D
0.10.1
Architecture Scope Download SHA256
x64 Download A5D84EA867EEAA81AE849E0FC0D9201A1EF167BD382FC68531A202682F8CF0C4
0.10.0
Architecture Scope Download SHA256
x64 Download 2F8D446B47ECBFFDEACE97CAA4D3D8501B6572BBB50D00D8F862012437E147BA
0.9.2
Architecture Scope Download SHA256
x64 Download 880FE01FF24A13DDEA8A9609A4BA0CEFFD246A9D497A345EFC406CC1792445E4
0.9.1
Architecture Scope Download SHA256
x64 Download DE03D0A9EF676C4A04249E15DF1823063D489385C9D639A10B4F3F00B2C11493
0.9.0
Architecture Scope Download SHA256
x64 Download 177C49B1AC45D7E158824DCE5EB65B0506B5FA06B66BC72A75081A525E73C909
0.8.1
Architecture Scope Download SHA256
x86 Download 12B98191CCC58A78B01967EF5ADC3F4259A0A4AFC6ECEA10E97033F27501A55F
x64 Download 1E882F21115D44D34BB8DC853FD05338A46D5EE089E62FDF2CAB98F8455A9921
0.8.0
Architecture Scope Download SHA256
x86 Download 5ECC36FD23C0763EFD077102D310E1C19C151BC3FA34043B709B68646E875B6D
x64 Download 0B56BC5BB1BA3B87D7D510AE7CDE8FFBD9D62D186BA4BA9F251612EE07F1ECDC