DuckDB
In-process SQL OLAP database with excellent agent integration for local analytics.
- MCP
- CLI
About DuckDB
In-process SQL OLAP database with excellent agent integration for local analytics. Explore how DuckDB integrates with the agentic data stack ecosystem and supports autonomous data operations.
Key Features
- In-process embedded analytical (OLAP) database with zero external dependencies
- Columnar-vectorized execution engine optimized for analytical queries on modern CPUs
- Native support for reading/writing Parquet, CSV, JSON, Excel, and Apache Arrow formats
- Rich SQL dialect with window functions, CTEs, nested types (arrays, structs, maps)
- Extension system for S3/HTTP(S) remote file access, spatial data, full-text search
- Direct querying of pandas/Polars DataFrames in Python without data copying
- Single-file portable binary on Linux, macOS, Windows (x86 and ARM)
- Handles terabyte-scale data on a single machine with streaming and multi-core parallelism
External Links
MotherDuck MCP ServerOfficial MCP server for DuckDB and MotherDuck — supports local files, S3, and cloud connectionsDuckDB MCP Community ExtensionNative DuckDB extension adding MCP client/server capabilities directly inside the database engineCLI DocumentationOfficial command line client reference with dot commands, autocompletion, and output modesPython API ReferenceOfficial Python client API reference for programmatic DuckDB accessAwesome DuckDBCurated list of DuckDB resources including AI integrations
← Back to SQL Engine