asyncpg
Fast asyncio PostgreSQL driver for non-blocking database operations in Python.
Used in agent projects
97
0.8% of 12,697 public repos built with AI coding agents
Rank in databases, orms and clients
#11 of 30
by use in those projects
Downloads
29.4M
PyPI, last 7 days, asyncpg
GitHub stars
8,105
last push Oct 8, 2026
How asyncpg is used
asyncpg is a dependency in 97 of the 12,697 public GitHub projects set up for AI coding agents that we scanned (0.8%), #11 of 30 in databases, orms and clients. The most used alternative there is Prisma. Projects that use it most often also use FastAPI (82.5%), Uvicorn (79.4%), Pydantic (77.3%).
Often used with asyncpg
| FastAPI | 82.5% of asyncpg projects · 19.5× more than average |
|---|---|
| Uvicorn | 79.4% of asyncpg projects · 18.5× more than average |
| Pydantic | 77.3% of asyncpg projects · 15.1× more than average |
| SQLAlchemy | 73.2% of asyncpg projects · 37.2× more than average |
| python-dotenv | 70.1% of asyncpg projects · 10.7× more than average |
| Pydantic Settings | 52.6% of asyncpg projects · 26.6× more than average |
| Alembic | 51.5% of asyncpg projects · 56.9× more than average |
| redis (Python) | 47.4% of asyncpg projects · 42.4× more than average |
By coding agent
| Claude Code | 1.4% of projects set up for it |
|---|---|
| Cursor | 1.5% of projects set up for it |
| GitHub Copilot | 1.1% of projects set up for it |
| Devin Desktop | 1.8% of projects set up for it |
| Gemini CLI | 1.1% of projects set up for it |
Share of public repos configured for each agent that list asyncpg as a dependency.
Install
| Package | pip install asyncpg |
|---|---|
| Main stacks | Python (93), Next.js (3), Other (1) |
| Example projects | dramaclaw/dramaclaw, imbue-bit/AlphaGPT, learntocloud/learn-to-cloud-app, MDalamin5/End-to-End-Agentic-Ai-Automation-Lab, XargonWan/Synthetic_Heart |
Alternatives to asyncpg
| 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 |