Popular: Data updated October 27, 2026

Categories

Internet1,356
Communication321
Audio & video898
Graphics & design539
Office & productivity1,124
Developer tools3,134
AI tools529
Security & privacy385
System tools3,114
Games523
Education & science239
Network & IT284

DuckDB CLI 1.5.6 download

DuckDB is an in-process SQL OLAP Database Management System

DuckDB Databases #19 Databases
This is the current version. · Released:

Installer files 1.5.6

ArchitectureTypeScopeFile sizeDownloadSHA256
64-bit ZIP → Portable · en-US Current user — github.com VirusTotal
ARM64 ZIP → Portable · en-US Current user — github.com VirusTotal

Link and SHA256 come from the Windows Package Manager community manifest. Compare the hash of the downloaded file before running it.

Release notes

This is a bug fix release for various issues discovered after we released v1.5.5
What's Changed
- Use relative includes in unity build sources for cache reuse by @NiclasHaderer in #23972
- bump vortex by @samansmink in #24089
- [variegata] Remove Julia client in favor of duckdb/DuckDB.jl by @evertlammerts in #24127
- [variegata] Replace the C API spec and code generation by @evertlammerts in #24131
- TopNWindowElimination Fixes by @d-justen in #24080
- Fix active query race by @NiclasHaderer in #24123
- Fix UNNEST Pushdown by @d-justen in #24119
- [Parquet][Variant] Don't produce VARIANT metadata with sorted_strings set by @Tishj in #23591
- Fix LIMIT pushdown through a volatile projection with an OFFSET by @DinosL in #24240
- Don't push filters on volatile groups through aggregates by @DinosL in #24239
- fix(adbc): return a dense union from ConnectionGetInfo by @eitsupi in #24196
- Backport 24038 by @artjomPlaunov in #24326
- Unify C-API symbol versioning for clients/extensions, stabilize all v1 API's by @Maxxen in #24362
- backport 24332 by @DinosL in #24427
- Fix #24363: Preserve NULLs in Top-N window elimination when ORDER BY expression has no column references by @sdk011 in #24399
- backport 24260 by @artjomPlaunov in #24447
- Fix ICU strptime leaking time zone state between rows by @NiclasHaderer in #24438
- Moved thread-local work outside the global lock in PhysicalInsert::Combine by @sebastiaan-dev in #24516
- Bump httpfs by @mlafeldt in #24580
- bump vortex by @samansmink in #24650
- Fix 1.5 release by @smvv in #24687
- Allow duplicates in index in ReplayRowGroupData by @artjomPlaunov in #24744
- Dispatch Go nightly build by @mlafeldt in #24720
- Fix join projection map bug in TopNWindowElimination by @d-justen in #24592
- Fix Go nightly workflow dispatch by @mlafeldt in #24802
- Fix Top-N window elimination for nullable ordering expressions by @matthiasgoergens in #24551
- Backport 23964 & 24336 by @DinosL in #24791
- Fix off-by-one in union type by @Maxxen in #24843
- Fix inner join deduplication in TopNWindowElimination by @d-justen in #24586
- fix geometry row group pruning with nulls/empty (on v1.5) by @Maxxen in #24845
- Backport DuckDB 2.0 API spellings to 1.5 by @JelteF in #24852
- Reserve column_ids.size() in CollectionScanState::Initialize by @jeewonhh in #24888
- Fix pathological scan memory for NULLs trailing an overflow string (#24897) by @mdlavin in #24918
- Use absolute unity build includes on Windows to avoid MSVC MAX_PATH errors by @NiclasHaderer in #24978
- Fix mixed path separators for extension/loader in amalgamation (v1.5 backport) by @mlafeldt in #25026
- Backport #25101: Fix crash in Top-N with LIMIT 0 (#24794) by @RagamuffinCat in #25103
- Track and expose Pipeline's intra-MetaPipeline dependencies by @jeewonhh in #24494
- Bump httpfs by @DinosL in #25202
- Skip top-n window elimination when the limit exceeds the min/max n cap by @AbhinavMir in #24741
- Add v1.5.6 storage by @carlopi in #25208
- TryScanIndex fixes by @artjomPlaunov in #25209
- Backport #22678: avoid per-row DATE->TIMESTAMP casts in comparisons by @peterboncz in #25139
- Harden temp file reads by @carlopi in #25283
- Avoid deduplicating UNION twice by @ywelsch in #25261
- Backport #24878: Always quote identifiers in error messages by @JelteF in #25214
- Fixup TryFlushCachingOperators to avoid doubly emitted chunks by @carlopi in #25331
- Close the main WAL handle before renaming over it during WAL recovery by @carlopi in #25490
- [1.5] Report the real storage version when opening a v2.0+ database file by @DinosL in #25573
- Do not assert on a scan of a row group collection without committed row groups by @bleskes in #25668
- Backport dead node counting fixes to v1.5 by @artjomPlaunov in #25693
- Fix silent truncation of very long integer literals into HUGEINT by @DinosL in #25714
- Auto-rollback failed implicitly-wrapped multi-statements on all paths by @jraymakers in #24065
- Backport #25690: Fix MAX on hive partition column after file pruning by @avakili-voleon in #25766
- Bump scanners for 1.5 by @staticlibs in #25671
- Backport #23958 (Fix TIME_NS read/write with parquet) by @avakili-voleon in #25728
- Fix deprecated CLI highlighting dot commands suggesting .render_color by @DinosL in #25689
- Backport PR #25189: Reject invalid UTF8 from printf formatting by @artjomPlaunov in #25808
- Update vortex extension by @samansmink in #25791
- Backport fix for wrong results from common_subplan with UNION ALL arms sharing a join subtree (#25819) by @Kunal8954 in #25831
- Backport #25660: Use read-only transaction to bind indexes in Checkpoint by @Flogex in #25858
- Backport 22373 by @DinosL in #25844
- Internal #10791: v1.5.6 TimeZone 2026c by @hawkfish in #25745
- Keep the delete blocks of an unchanged table in use without rewriting them by @ywelsch in #25971
- Update MySQL and ODBC scanners in 1.5 by @staticlibs in #25945
- Internal #10927: v1.5.6 TimeZone 2026d by @hawkfish in #26039
- backport 25752 by @DinosL in #26027
- Bump DuckLake for v1.5.6 by @pdet in #26009
- Backport #24557: Resolve partition columns for non-pushdown table functions by @rustyconover in #25998
- Issue #25995: Streaming Window UNIONs by @hawkfish in #26104
- Bump multiple extensions by @maiadegraaf in #26072
- Backport 35ce409 to v1.5-variegata by @carlopi in #26137
- bump iceberg by @Tmonster in #25899
- Bump: ducklake by @maiadegraaf in #26151
- Backport #24194: Add enable_optimistic_write setting by @mbrobbel in #26102
- bump delta + unity_catalog extensions for v1.5.6 by @benfleis in #26204
- Bump lance to 291316938c4ab06dc9fec5b92820f496662ef24a by @carlopi in #26203
- Bump vortex to b86c6ab223b53b445ec4c96e74f26dcb616d9c4f by @carlopi in #26202
- [Parquet] Backport of #25891 by @Tishj in #26162
New Contributors
- @AbhinavMir made their first contribution in #24741
- @mbrobbel made their first contribution in #26102
Full Changelog: v1.5.5...v1.5.6

https://github.com/duckdb/duckdb/releases/tag/v1.5.6

Most popular in Databases

See all
  1. MariaDBThe innovative open source database
  2. HeidiSQLA lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi
  3. SQLiteSelf-contained transactional SQL database engine
  4. DoltDolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a git repository.
  5. MongoDBMongoDB is a general purpose, document-based, distributed database built for modern application developers and for the cloud era.
  6. Redis on WindowsIn-memory data structure store, used as database, cache and message broker
  7. DB Browser for SQLiteA high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
  8. Beekeeper StudioA modern, easy to use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Oh, it's also open source :-).
  9. LiquibaseEasiest, safest, and most powerful community-led database change management solution.
  10. Another Redis Desktop ManagerA faster, better and more stable redis desktop manager.

Tags

Share