aiosqlite
Asyncio wrapper for SQLite enabling non-blocking database operations in Python.
Used in agent projects
86
0.7% of 12,697 public repos built with AI coding agents
Rank in databases, orms and clients
#13 of 30
by use in those projects
Downloads
15.6M
PyPI, last 7 days, aiosqlite
GitHub stars
1,581
last push Mar 1, 2026
How aiosqlite is used
aiosqlite is a dependency in 86 of the 12,697 public GitHub projects set up for AI coding agents that we scanned (0.7%), #13 of 30 in databases, orms and clients. The most used alternative there is Prisma. Projects that use it most often also use Pydantic (75.6%), python-dotenv (68.6%), Uvicorn (65.1%).
Often used with aiosqlite
| Pydantic | 75.6% of aiosqlite projects · 14.8× more than average |
|---|---|
| python-dotenv | 68.6% of aiosqlite projects · 10.5× more than average |
| Uvicorn | 65.1% of aiosqlite projects · 15.2× more than average |
| FastAPI | 62.8% of aiosqlite projects · 14.8× more than average |
| SQLAlchemy | 52.3% of aiosqlite projects · 26.6× more than average |
| Pydantic Settings | 45.3% of aiosqlite projects · 22.9× more than average |
| PyYAML | 45.3% of aiosqlite projects · 15.0× more than average |
| aiohttp | 43.0% of aiosqlite projects · 18.5× more than average |
By coding agent
| Claude Code | 1.1% of projects set up for it |
|---|---|
| GitHub Copilot | 0.7% of projects set up for it |
| Cursor | 0.8% of projects set up for it |
Share of public repos configured for each agent that list aiosqlite as a dependency.
Install
| Package | pip install aiosqlite |
|---|---|
| Main stacks | Python (83), Next.js (3) |
| Example projects | dramaclaw/dramaclaw, pavelzbornik/whisperX-FastAPI, sweetcornna/free-search-mcp, XargonWan/Synthetic_Heart, towardsai/agentic-ai-engineering-course |
Alternatives to aiosqlite
| 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 |