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

Release Notes

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

  • [Extensions] Preserve require order in InterpretedBenchmark by @Tishj in #21214
  • CLI: Make help entry uppercase by @szarnyasg in #21224
  • Restore view's bind_state when binding fails by @jeewonhh in #21193
  • [Regression v1.5] Fix INTERNAL Error in UnnestRewriter for deeply nested struct UNNEST by @guizmaii in #21209
  • fix(storage): prevent TrimFreeBlocks from zeroing concurrently alloca… by @llersch in #21146
  • Windows shell: UTF-8 mode when writing to pager by @staticlibs in #21202
  • [Dev] Add internal exception for misuse of MultiFileReader method by @Tishj in #21046
  • Before loading libraries in TryAutoLoadExtension check AutoloadKnownExtensions Setting by @pdet in #21051
  • fix: buffer overread in Arrow dictionary conversion with NULLs - fixes crash. by @rustyconover in #21083
  • Avoid misleading GetRequestInfo constructor that takes endpoint + path by @carlopi in #21151
  • Enable column pruning for MATERIALIZED CTEs by @kryonix in #21169
  • Add framework to test two DuckDB versions by @Y-- in #21184
  • Internal #7691: 2026a Time Zones by @hawkfish in #21204
  • Fix DuckFuzz #4325 by @kryonix in #21215
  • Fix decorrelation delim index bug by @kryonix in #21233
  • Fix two minor shell bugs: Avoid mutating rendered strings and avoid p… by @carlopi in #21234
  • Fix wrong cast in RecursiveDependentJoinPlanner by @kryonix in #21235
  • Use atomic load in bloom filter look-up by @Mytherin in #21238
  • Move BWC tests to nightly for now by @Mytherin in #21266
  • Internal #7740: AsOf Tidy Fix by @hawkfish in #21255
  • Re-add accidentally removed -jsonlines command line parameter by @Mytherin in #21263
  • Switch MAIN_BRANCH_VERSIONING to False for v1.5-variegata branch by @carlopi in #21239
  • Lazy call mmap in BlockAllocator by @lnkuiper in #21276
  • Dynamically determine radix bits for external aggregation by @lnkuiper in #21274
  • Avoid potential division by 0 in PhysicalHashJoin::PrepareFinalize by @lnkuiper in #21271
  • Do not use MSYS shell for MinGW builds by @staticlibs in #21296
  • add structured Path objects, update joinpath: normalize, support url/… by @benfleis in #21277
  • When stress testing FORCE_ASYNC, add the relevant error messages by @carlopi in #21267
  • Fix invalid JSON when casting from certain types by @Maxxen in #21280
  • Fix .open of Parquet files etc. in CLI by @hannes in #21269
  • Bump storage version to v1.5.1 by @taniabogatsch in #21287
  • Implement line number reporting in errors for PEG parser by @Dtenwolde in #21157
  • Support new v1.5 syntax for PEG grammar by @Dtenwolde in #21172
  • [Fix] Memory error when transforming to v1.0.0 ART storage by @taniabogatsch in #21270
  • Add missing expression traversal in merge into binding by @kryonix in #21283
  • Add UUID to settings cache by @Mytherin in #21290
  • Fix Terminal::TryGetBackgroundColor when stdin is reading from a pipe but stdout is still writing to the terminal by @Mytherin in #21288
  • Fix #21248: correctly expand type count in CSV header detection by @Mytherin in #21292
  • Add batch index support to parquet_metadata and friends to allow it to be executed in parallel also with order preservation by @Mytherin in #21314
  • Make overriding HTTPUtil thread safe by @Mytherin in #21210
  • Revert #21067 - and fix WAL corruption issue through calling MarkBlockAsCheckpointed on WAL blocks by @Mytherin in #21285
  • Fix sampling for UB in musl libc by @carlopi in #21318
  • TryGetCurrentSetting: Fixup paramater passing for FileOpenerInfo by @carlopi in #21301
  • Fix Row Group Reorderer Bug by @d-justen in #21282
  • Windows shell: fix UTF-8 to UTF-16 conversion by @staticlibs in #21319
  • Issue #21244: AsOf Unordered LIMIT by @hawkfish in #21250
  • Throw error on incorrect use of ParseExpressionList by @Dtenwolde in #21306
  • Issue #20481: Prepare Window Parameters by @hawkfish in #21323
  • CLI: Explicitly clean up shell state instead of letting static destructor order determine when it gets destroyed by @Mytherin in #21315
  • Fixup 401bcf0: "When stress testing … by @carlopi in #21329
  • CLI: Make bail on error the default in more situations by @Mytherin in #21344
  • Improve estimate when first Parquet file is almost empty, and get exact cardinality count when we are using union by name by @Mytherin in #21345
  • Fix infinite recursion in FileOpener::TryGetCurrentSetting by @Mytherin in #21356
  • fix argument check for .multiline and .singleline by @jaywgraves in #21336
  • Windows shell: remove .utf8 dot command by @staticlibs in #21343
  • When writing unsupported Parquet variant types to Parquet, try to convert them to INT64 by @Mytherin in #21357
  • Use cached Parquet metadata to improve cardinality estimates over Parquet files by @Mytherin in #21358
  • Parquet Reader: Allow merging of prefetch column ranges for columns that do not have table filters by @Mytherin in #21373
  • In the parquet reader, if we are globbing over a directory, use file sizes from the glob to estimate cardinalities instead of relying only on the first parquet file by @Mytherin in #21374
  • MbedTLS: Actually throw exception by @hannes in #21365
  • Well-defined environment for MinGW builds by @staticlibs in #21371
  • Fix #21335: correctly add checkpoint and recovery WAL to allowed paths when launching an initial db with enable_external_access set to false by @Mytherin in #21379
  • automate clangd/compile_commands.json gen via builds by @benfleis in #21361
  • Parquet: Ignore optional filters when deciding whether or not to do a lazy fetch by @Mytherin in #21383
  • parquet: avoid corrupting define buffers during skips by @Mikubill in #21298
  • CLI: Fix .tables rendering for large database names by @Mytherin in #21389
  • Fix column pruning for CTEs by @kryonix in #21275
  • add test for #21271 by @artjomPlaunov in #21398
  • Grab correct row group id in ValidityColumnData::UpdateWithBase by @Mytherin in #21397
  • Add lance extension by @carlopi in #21406
  • add lance for v1.5 by @samansmink in #21111
  • Fix #21289: correctly determine render width of UTF8 string with grapheme clusters by @Mytherin in #21409
  • Avoid calling PushCollation in create_sort_key by @Mytherin in #21412
  • Flush remaining operators in pipeline by @DinosL in #21405
  • Correctly limit auto-detection in read_json for files that don't have string columns by @Mytherin in #21411
  • Fix INSERT OR REPLACE updates on non-unique indexed columns by @feichai0017 in #20962
  • fix(adbc): support concurrent statements on the same connection by @eitsupi in #21415
  • Fix invalid common subplan CTE reuse for issue #21372 by @feichai0017 in #21386
  • Use regular pushdown path for semi/anti/left delim joins by @Mytherin in #21416
  • Predicate factoring by @lnkuiper in #21418
  • Bump SQLite by @staticlibs in #21414
  • Enable Row Group Pruner for NULLS_FIRST by @d-justen in #21399
  • Read geoparquet file with null CRS. Fix #21332 by @philippechataignon in #21333
  • test/sql/join/test_hash_join_many_columns.test needs 64bit by @carlopi in #21432
  • Parquet Reader: initialize scan without holding the global lock in the multi file reader by @Mytherin in #21439
  • bump spatial for v1.5.2 by @Maxxen in #21440
  • [vortex] Bump to d0b5bae4d907694e776c97b57de6edfb662c6c25 by @carlopi in #21430
  • Fix stale update read during index removal by @artjomPlaunov in #21427
  • Fix window elimination optimizer by @kryonix in #21428
  • Avoid scanning struct validity when executing pushdown extract by @Mytherin in #21421
  • Bump avro by @taniabogatsch in #21426
  • Add allowed_configs option for allow-listing configs when setting lock_configurations by @hrl20 in #20938
  • Fix minor typos in documentation and comments by @Monstertov in #21442
  • Fix parquet metadata cache invalidation in local file system by @Mytherin in #21435
  • Bump ducklake by @Mytherin in #21448
  • [httpfs] Bump to 7e86e7a5e5 and remove patches by @carlopi in #21437
  • verify_fetch_row.json + roaring seems to work as intended, restore by @carlopi in #21300
  • Refactor for multiple external extensions, and skip temporary for osx_amd64 by @carlopi in #21450
  • bump iceberg by @Tmonster in #21453
  • Fix #21436: correctly preserve spaces within unquoted struct values in pretty printing code by @Mytherin in #21457
  • Bump Postgres and MySQL by @staticlibs in #21433
  • Shell: use Unicode entry point on Windows by @staticlibs in #21472
  • Fix #21459: detect when read_duckdb is used to read a non-DuckDB file and throw a descriptive error by @Mytherin in #21460
  • Fix #21367: Prevent throwing in WindowSelfJoinOptimizer when a logical plan cannot be copied, instead fallback to not running the optimization by @Mytherin in #21461
  • bump delta && unity in prep for v1.5.1 by @benfleis in #21451
  • Adjust v1.5.0 for z/OS by @DNikolaevAtRocket in #21325
  • [vortex] Bump to 6ea8bd77fe8e6e814bde11b6981f934fa82ab961 by @carlopi in #21462
  • Fix NULL dereference in TryGetValueFromStats (#21477) by @carlopi in #21479
  • Bump spatial again by @Maxxen in #21485
  • Bump vcpkg-duckdb-ports baseline by @yan-alex in #21493 Full Changelog: v1.5.0...v1.5.1

Installer type: zip

Architecture Scope Download SHA256
x64 Download 22CC4B9DCFFE6B01300D2E78B5918A13CF4335305FEC854A9277DB3BBF2E4A83
arm64 Download F60B55F069F8A950CA8C61464AF23F5D3D9DDC2B82152D6F55AD060F7EC6A436

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

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