DuckDB
An analytical SQL database that runs in process, DuckDB is available as an open-source software repository.
About DuckDB
DuckDB is an analytical in-process SQL database management system available as an open-source repository. It is provided as a standalone CLI application and with clients for Python, R, Java, Wasm, including integrations with pandas and dplyr. It supports nested correlated subqueries, window functions, collations, and complex types including arrays, structs, and maps. CSV and Parquet files can be queried by referencing the file path in the FROM clause.
Key features
- In-process analytical SQL database system
- Standalone CLI application
- Clients for Python, R, Java, and Wasm
- Integrations with pandas and dplyr packages
- Queries CSV files directly in FROM clause
- Queries Parquet files directly in FROM clause
Best for: Developers and analysts working with embedded analytical SQL in Python, R, Java, or Wasm workflows.
Good for
- Open-source repository under MIT license
- Provides clients for Python, R, Java, and Wasm
- Queries CSV and Parquet files without separate import step
Watch out for
- Building from source requires CMake, Python 3, and a C++17 compiler
DuckDB at a glance
- Website
- github.com/duckdb/duckdb
- Category
- Development › APIs & Databases
- Type
- Open-source project
- Pricing
- Not confirmed. Check the site
- Open source
- Yes · Source code
- Language
- English
- Last checked
- Oct 5, 2026 · Online when checked
- Listed
- Oct 5, 2026
Guides for APIs & Databases
DuckDB alternatives
Tools and sites you could use instead, ranked by how closely they match.
A SQL database with Git-style version control, Dolt supports branching, merging, pushing, and pulling data.
Open source
24 alternatives
PostgreSQL vector search can use pgvecto.rs, an extension described as scalable and low latency.
Open source
24 alternatives
Query and manage SQL databases with Beekeeper Studio, a desktop client for MySQL, Postgres, SQLite, SQL Server, and more.
Create, search, and edit SQLite or SQLCipher database files with DB Browser, an open-source visual database tool.
Multiple databases can be managed with Beekeeper Studio, a SQL editor and database application.
drawDB designs database schemas and entity-relationship diagrams, then generates SQL for several database systems.
Popular in APIs & Databases
Well-known listings from the same topic.
API3api3.orgTwiliotwilio.comPocketBasepocketbase.ioBrunousebruno.comMeilisearchmeilisearch.comPostmanpostman.com
DuckDB FAQ
How can I query a CSV or Parquet file?
Reference the file in the FROM clause, for example SELECT * FROM 'myfile.csv'; or SELECT * FROM 'myfile.parquet';
What interfaces are available for DuckDB?
A standalone CLI application and clients for Python, R, Java, Wasm, among others.
What is needed to build DuckDB from source?
CMake, Python 3, and a C++17 compliant compiler, then run make in the root directory.
Is something wrong or out of date?
Tell us and an editor will check it.
Own this website?
Claim this listing
Claim the listing and suggest updates yourself. An editor checks every claim first.