Mause/duckdb_engine - thehardwarestore.ai

── AI DEEP ANALYSIS ──

reviewed by: deepseek/deepseek-v4-flash

This repository provides a SQLAlchemy dialect for DuckDB, enabling DuckDB to be used as a database backend within SQLAlchemy's ORM and Core APIs. It maps DuckDB's type system to SQLAlchemy types, handles connection management (including in-memory and file-based databases), supports reflection (schema introspection), and integrates with DuckDB extensions. The dialect is built on top of the PostgreSQL psycopg2 dialect, customizing it for DuckDB's capabilities and limitations. The source code is well-structured, extensively tested, and actively maintained, with support for DuckDB versions 0.5.0 through 1.2.2 and SQLAlchemy 1.3 through 2.0.35.

── METRICS ──

RATING8.5/10

QUALITY8.0/10

MAINTENANCEactive

DRIFTlow

CONTRIBUTORS34

VELOCITY0.49

OPEN ISSUES98

CLOSED ISSUES88

LAST COMMIT3 weeks ago

── TAGS ──

#duckdb #sqlalchemy-dialect #database #python-library #sqlalchemy #python #sql #duckdb-engine

── GITHUB TOPICS ──

duckdb python sql sqlalchemy duckdb-engine

── DEPENDENCY GRAPH ──

duckdb (pip) >=0.5.0

sqlalchemy (pip) >=1.3.22

packaging (pip) >=21

── FILE BREAKDOWN ──

Files by Type (count)

Other (no ext)

21

Python

12

YAML

7

JSON

3

Markdown

3

Other (.gz)

2

TOML

2

Git Ignore

1

Text

1

SQL

1

Lock File

1

Files by Type (size)

Lock File

105KB

Python

70KB

Other (.gz)

40KB

Markdown

34KB

YAML

5KB

TOML

1KB

Text

1KB

JSON

294B

Git Ignore

155B

Other (no ext)

74B

SQL

46B

── KEY FINDINGS: REUSABLE CODE ──

The LLM identified 1 files worth highlighting for reuse:

Defines custom DuckDB-specific SQL types (UInt64, Struct, Map, Union, etc.) and registers compilation handlers for SQLAlchemy. This module demonstrates non-obvious knowledge of both DuckDB's type system and SQLAlchemy's extensibility, and could be extracted and reused in other DuckDB integration projects with minimal modifications.

file: duckdb_engine/datatypes.py ↗ | tags: #type-mapping #sqlalchemy-types

── HISTORY ──

Last analyzed: 2026-09-22 14:25:10.393919

Next check: 2026-09-29 14:25:10.397289

$ show Mause/duckdb_engine