DuckDB
Embedded SQL OLAP database for analytical queries and data processing in Python.
Used in agent projects
27
0.2% of 12,697 public repos built with AI coding agents
Rank in databases, orms and clients
#24 of 30
by use in those projects
Downloads
15M
PyPI, last 7 days, duckdb
GitHub stars
189
last push Oct 1, 2026
How DuckDB is used
DuckDB is a dependency in 27 of the 12,697 public GitHub projects set up for AI coding agents that we scanned (0.2%), #24 of 30 in databases, orms and clients. The most used alternative there is Prisma. Projects that use it most often also use pandas (70.4%), Requests (63.0%), NumPy (51.9%).
Often used with DuckDB
| pandas | 70.4% of DuckDB projects · 23.3× more than average |
|---|---|
| Requests | 63.0% of DuckDB projects · 11.8× more than average |
| NumPy | 51.9% of DuckDB projects · 13.5× more than average |
| Pydantic | 48.1% of DuckDB projects · 9.4× more than average |
| Uvicorn | 40.7% of DuckDB projects · 9.5× more than average |
| Model Context Protocol SDK (Python) | 40.7% of DuckDB projects · 10.7× more than average |
| PyYAML | 37.0% of DuckDB projects · 12.2× more than average |
| PyArrow | 37.0% of DuckDB projects · 78.4× more than average |
By coding agent
| Claude Code | 0.5% of projects set up for it |
|---|---|
| GitHub Copilot | 0.4% of projects set up for it |
| Cursor | 0.2% of projects set up for it |
Share of public repos configured for each agent that list DuckDB as a dependency.
Install
| Package | pip install duckdb |
|---|---|
| Main stacks | Python (27) |
| Example projects | napjon/krisk, RoboFinSystems/robosystems, eduardocornelsen/full-funnel-ai-analytics, boettiger-lab/mcp-data-server, peweet/dail_tracker |
Alternatives to DuckDB
| Tool | Used in agent projects | Downloads / wk | GitHub stars | License |
|---|---|---|---|---|
| Prisma npm Modern ORM with intuitive schema, migrations, and type-safe database queries. |
381 (3.0%) | 19M | 23 | Apache-2.0 |
| pg npm PostgreSQL client for Node.js with pure JavaScript and libpq API compatibility. |
372 (2.9%) | 63.4M | 13.2K | MIT |
| Drizzle ORM npm TypeScript ORM for SQL databases with type safety and zero-runtime overhead. |
323 (2.5%) | 27.2M | 36K | Apache-2.0 |
| Drizzle Kit npm CLI migration tool for Drizzle ORM that auto-generates SQL migrations intelligently. |
309 (2.4%) | 22.3M | 36K | MIT |
| SQLAlchemy pypi Python SQL toolkit and object-relational mapper for database abstraction. |
250 (2.0%) | 85.7M | 12.2K | — |
| better-sqlite3 npm Fastest and simplest SQLite library for Node.js with synchronous API. |
162 (1.3%) | 11.3M | 7,513 | MIT |
| psycopg2 pypi Popular PostgreSQL adapter for Python with full database access and query execution. |
143 (1.1%) | 50.7M | 3,656 | LGPL with exceptions |
| Mongoose npm MongoDB object modeling library providing schema validation and query building. |
142 (1.1%) | 6.6M | 27.5K | MIT |