Used in agent projects
80
0.6% of 12,697 public repos built with AI coding agents
Rank in databases, orms and clients
#14 of 30
by use in those projects
Downloads
38.8M
PyPI, last 7 days, psycopg
GitHub stars
2,508
last push Oct 9, 2026
How psycopg is used
psycopg is a dependency in 80 of the 12,697 public GitHub projects set up for AI coding agents that we scanned (0.6%), #14 of 30 in databases, orms and clients. The most used alternative there is Prisma. Projects that use it most often also use python-dotenv (62.5%), FastAPI (51.2%), Uvicorn (51.2%).
Often used with psycopg
| python-dotenv | 62.5% of psycopg projects · 9.6× more than average |
|---|---|
| FastAPI | 51.2% of psycopg projects · 12.1× more than average |
| Uvicorn | 51.2% of psycopg projects · 12.0× more than average |
| Pydantic | 47.5% of psycopg projects · 9.3× more than average |
| Requests | 42.5% of psycopg projects · 8.0× more than average |
| SQLAlchemy | 33.8% of psycopg projects · 17.1× more than average |
| NumPy | 32.5% of psycopg projects · 8.5× more than average |
| PyYAML | 31.2% of psycopg projects · 10.3× more than average |
By coding agent
| Claude Code | 1.2% of projects set up for it |
|---|---|
| Cursor | 1.3% of projects set up for it |
| GitHub Copilot | 1.0% 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 psycopg as a dependency.
Install
| Package | pip install psycopg |
|---|---|
| Main stacks | Python (79), React Native / Expo (1) |
| Example projects | dramaclaw/dramaclaw, pipedude/evi-run, napjon/krisk, Qredence/fleet-rlm, aanno/cocoindex-code-mcp-server |
Alternatives to psycopg
| 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 |