Skip to content
Agents tracked: 502 Releases (7d): 613 Agent status: 4 with issuesSince last limit reset: Claude 7d · Codex 5d For AI agents: Markdown Updated Nov 18, 2026

asyncpg vs psycopg

In 1,621 Python projects set up for AI coding agents, asyncpg is a dependency in 68 (4.2%) and psycopg in 70 (4.3%), close to even. Among repos created in the last 90 days that use a databases, orms and clients tool, asyncpg is in 28.0% and psycopg in 32.0%, against 15.8% and 16.1% of older ones. 11 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

asyncpg4.2%
psycopg4.3%

Share of 1,621 Python projects set up for AI coding agents that list each one as a dependency.

Side by side

asyncpgpsycopg
Agent projects that use it6870
Rank in databases, orms and clients#11#10
In new repos with a databases, orms and clients tool (last 90 days)28.0%32.0%
In older repos with one15.8%16.1%
Downloads, last 7 days35.1M55.1M
GitHub stars8,1202,533
Last push to its repoOct 8, 2026Nov 12, 2026
LicenseApache-2.0LGPL-3.0-only
Funding——
Projects that list both11

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 forPython reposasyncpgpsycopg
Claude Code7825.4%5.0%
GitHub Copilot8054.1%3.7%
Cursor5486.4%6.4%
Gemini CLI836.0%8.4%
OpenCode530%9.4%
Devin Desktop608.3%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.

asyncpg

Fast asyncio PostgreSQL driver for non-blocking database operations in Python.

Most often used with it:

FastAPI89.7% of its projects
Uvicorn85.3% of its projects
Pydantic82.4% of its projects
SQLAlchemy75.0% of its projects
python-dotenv58.8% of its projects

pip install asyncpg

psycopg

PostgreSQL database adapter for Python with async support.

Most often used with it:

python-dotenv60.0% of its projects
FastAPI51.4% of its projects
Uvicorn50.0% of its projects
Pydantic47.1% of its projects
Requests42.9% of its projects

pip install psycopg

More matchups

psycopg2 vs asyncpgasyncpg 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.