duckdb

DuckDB in-process database

duckdb Permissive license Active ★ 176 v1.5.5 released 2026-07-22

Install

duckdb on PyPI

pip

pip install duckdb

uv

uv add duckdb

poetry

poetry add duckdb

Package facts

License	not declared (permissive)
Python support	supports the current Python release (>=3.10.0)
Install friction	medium — platform-specific wheel
Runtime dependencies	none
Maintenance	actively maintained — 22 days since the last release
Last repo commit	2026-07-30
First released	2019-05-08
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: duckdb-1.5.5-cp310-cp310-macosx_10_9_universal2.whl; duckdb-1.5.5-cp310-cp310-macosx_10_9_x86_64.whl; duckdb-1.5.5-cp310-cp310-macosx_11_0_arm64.whl; duckdb-1.5.5-cp310-cp310-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl; duckdb-1.5.5-cp310-cp310-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl; duckdb-1.5.5-cp310-cp310-win_amd64.whl; duckdb-1.5.5-cp311-cp311-macosx_10_9_universal2.whl; duckdb-1.5.5-cp311-cp311-macosx_10_9_x86_64.whl; duckdb-1.5.5-cp311-cp311-macosx_11_0_arm64.whl; duckdb-1.5.5-cp311-cp311-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl; duckdb-1.5.5-cp311-cp311-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl; duckdb-1.5.5-cp311-cp311-win_amd64.whl; duckdb-1.5.5-cp311-cp311-win_arm64.whl; duckdb-1.5.5-cp312-cp312-macosx_10_13_universal2.whl; duckdb-1.5.5-cp312-cp312-macosx_10_13_x86_64.whl; duckdb-1.5.5-cp312-cp312-macosx_11_0_arm64.whl; duckdb-1.5.5-cp312-cp312-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl; duckdb-1.5.5-cp312-cp312-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl; duckdb-1.5.5-cp312-cp312-win_amd64.whl; duckdb-1.5.5-cp312-cp312-win_arm64.whl

Keywords: DuckDB, Database, SQL, OLAP

Development Status :: 5 - Production/StableIntended Audience :: DevelopersIntended Audience :: EducationIntended Audience :: Information TechnologyIntended Audience :: Science/ResearchLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: C++Programming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: DatabaseTopic :: Database :: Database Engines/ServersTopic :: Scientific/Engineering

About duckdb

from the package's own PyPI description — quoted content, verbatim

<div align="center"> <picture> <source media="(prefers-color-scheme: light)" srcset="https://raw.githubusercontent.com/duckdb/duckdb/refs/heads/main/logo/DuckDB_Logo-horizontal.svg"> <source media="(prefers-color-scheme: dark)" srcset="https://raw.githubusercontent.com/duckdb/duckdb/refs/heads/main/logo/DuckDB_Logo-horizontal-dark-mode.svg"> <img alt="DuckDB logo" src="https://raw.githubusercontent.com/duckdb/duckdb/refs/heads/main/logo/DuckDB_Logo-horizontal.svg" height="100"> </picture> </div> <br /> <p align="center"> <a href="https://discord.gg/tcvwpjfnZx"><img src="https://shields.io/discord/909674491309850675" alt="Discord" /></a> <a href="https://pypi.org/project/duckdb/"><img src="https://img.shields.io/pypi/v/duckdb.svg" alt="PyPI Latest Release"/></a> </p> <br /> <p align="center"> <a href="https://duckdb.org">DuckDB.org</a> | <a href="https://duckdb.org/docs/stable/guides/python/install">User Guide (Python)</a> - <a href="https://duckdb.org/docs/stable/clients/python/overview">API Docs (Python)</a> </p>

DuckDB: A Fast, In-Process, Portable, Open Source, Analytical Database System

Simple: DuckDB is easy to install and deploy. It...

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

DuckDB is an in-process analytical SQL database that runs embedded in your application with zero external dependencies, supporting fast columnar queries on CSV, Parquet, JSON, and other formats from local or remote storage.

Medium install friction due to platform-specific compiled wheels (C++ backend), but comprehensive coverage across Python 3.10–3.14, macOS (Intel/ARM), Linux (x86/ARM), and Windows means a pre-built binary is likely available for your platform.

Licensed under the permissive MIT License with IP held by the DuckDB Foundation, so you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.

Usage

pip install duckdb

import duckdb
result = duckdb.sql('SELECT * FROM "data.parquet" LIMIT 10').fetchall()

Requires Python ≥3.10.0; compiled wheels may not be available for exotic architectures or Python versions outside 3.10–3.14.

Verdict: DuckDB is a mature, actively maintained analytical database (latest release 22 days old, 5+ years in production) with zero runtime dependencies, permissive licensing, and no known vulnerabilities. Install friction is moderate due to compiled wheels, but platform coverage is broad. A solid choice for embedded analytics workloads.

Needs verification

Whether the C++ compilation requirement or platform-specific wheels pose barriers in your specific deployment environment.
Performance characteristics and memory overhead for your specific query patterns and dataset sizes.

embedded sql databasein-process analytics enginecolumnar olap databaseparquet csv json queryfast analytical queriesportable sql enginezero dependency database