nackjicholson/aiosql

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1409 stars · 65 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

aiosql is a Python library that lets you write SQL queries in plain .sql files and load them into your application as callable methods, a port of Clojure's yesql. It supports both sync and asyncio drivers for SQLite, PostgreSQL, MySQL, DuckDB, and other PEP 249-compatible databases.

Use cases

• load sql queries from files in python
• keep sql out of python string literals
• use asyncpg or aiosqlite with named queries
• version control sql alongside application code
• reuse sql files in psql and python
• yesql for python

When to choose

• you want raw SQL as first-class code files instead of an ORM
• you use asyncio database drivers and want named query methods
• you want to run the same SQL in CLI tools and your Python app

When to avoid

• you prefer an ORM with models and migrations
• you need dynamic query building rather than predefined statements
• your database driver lacks a PEP 249-compatible adapter

Facets

library · maturity active

database database-driver orm databases developer-tools backend python cross-platform sql yesql asyncio sql-files query-loading pep-249

Member repositories

For agents

markdown · JSON · MCP: product_card(name="nackjicholson/aiosql")