duckdb-sqlalchemy documentation

Production-ready DuckDB SQLAlchemy dialect for DuckDB and MotherDuck.

Start here

• Overview
• Getting started
• Migration from duckdb_engine
• Connection URLs
• MotherDuck
• Configuration
• OLAP workflows
• Pandas and Jupyter
• Types and caveats
• Alembic integration
• Performance and exact values
• Ecosystem adoption

Examples

See examples/ for runnable scripts.