psycopg2 vs asyncpg
In 1,621 Python projects set up for AI coding agents, psycopg2 is a dependency in 99 (6.1%) and asyncpg in 68 (4.2%): psycopg2 is 1.5× as common. Among repos created in the last 90 days that use a databases, orms and clients tool, psycopg2 is in 20.0% and asyncpg in 28.0%, against 24.4% and 15.8% of older ones. 25 projects list both, often a sign of a migration or of a monorepo with several apps.
Databases, ORMs and clients PyPI Updated Nov 17, 2026
Side by side
| psycopg2 | asyncpg | |
|---|---|---|
| Agent projects that use it | 99 | 68 |
| Rank in databases, orms and clients | #7 | #11 |
| In new repos with a databases, orms and clients tool (last 90 days) | 20.0% | 28.0% |
| In older repos with one | 24.4% | 15.8% |
| Downloads, last 7 days | 55.7M | 35.1M |
| GitHub stars | 3,667 | 8,120 |
| Last push to its repo | Nov 1, 2026 | Oct 8, 2026 |
| License | LGPL | Apache-2.0 |
| Funding | — | — |
| Projects that list both | 25 | |
Downloads include CI runs and installs as a dependency of other packages. Stars and pushes are from GitHub's API; downloads from PyPI.
By coding agent
| Projects set up for | Python repos | psycopg2 | asyncpg |
|---|---|---|---|
| Claude Code | 782 | 5.4% | 5.4% |
| GitHub Copilot | 805 | 5.6% | 4.1% |
| Cursor | 548 | 7.5% | 6.4% |
| Gemini CLI | 83 | 0% | 6.0% |
| OpenClaw | 104 | 5.8% | 0% |
| Devin Desktop | 60 | 10.0% | 8.3% |
Share of the Python repos configured for each agent (its config file in the repo) that list the tool. A repo set up for two agents counts for both.
psycopg2
Popular PostgreSQL adapter for Python with full database access and query execution.
Most often used with it:
| python-dotenv | 72.7% of its projects |
|---|---|
| Uvicorn | 63.6% of its projects |
| FastAPI | 61.6% of its projects |
| SQLAlchemy | 60.6% of its projects |
| Pydantic | 57.6% of its projects |
pip install psycopg2-binary
asyncpg
Fast asyncio PostgreSQL driver for non-blocking database operations in Python.
Most often used with it:
| FastAPI | 89.7% of its projects |
|---|---|
| Uvicorn | 85.3% of its projects |
| Pydantic | 82.4% of its projects |
| SQLAlchemy | 75.0% of its projects |
| python-dotenv | 58.8% of its projects |
pip install asyncpg
More matchups
asyncpg vs psycopgasyncpg vs aiosqlitePrisma vs Drizzle ORMpg vs Neon Serverless Driver
How we count
Projects are public GitHub repos our weekly scan finds through coding-agent config files (CLAUDE.md, AGENTS.md, .cursor/mcp.json and others); a project uses a tool when its package.json, requirements.txt or pyproject.toml lists it. "Same job" was checked for every pair, so add-ons and companions are never paired. Shares by repo age compare repos created in the last 90 days with older ones in the same scan. More on the method.