pg
PostgreSQL client for Node.js with pure JavaScript and libpq API compatibility.
Databases, ORMs and clients npm MIT
Used in agent projects
372
2.9% of 12,697 public repos built with AI coding agents
Rank in databases, orms and clients
#2 of 30
by use in those projects
Downloads
63.4M
npm, last 7 days, pg
GitHub stars
13.2K
last push Oct 1, 2026
How pg is used
pg is a dependency in 372 of the 12,697 public GitHub projects set up for AI coding agents that we scanned (2.9%), #2 of 30 in databases, orms and clients. The most used alternative there is Prisma. Projects that use it most often also use dotenv (61.3%), Zod (57.3%), tsx (47.0%). It is more common in projects set up for Cline (11.1%) than for Claude Code (4.8%).
Often used with pg
| dotenv | 61.3% of pg projects · 3.9× more than average |
|---|---|
| Zod | 57.3% of pg projects · 3.4× more than average |
| tsx | 47.0% of pg projects · 4.7× more than average |
| Class Variance Authority | 47.0% of pg projects · 3.3× more than average |
| Lucide React | 55.1% of pg projects · 2.8× more than average |
| Tailwind Merge | 48.9% of pg projects · 2.9× more than average |
| TypeScript | 87.9% of pg projects · 1.6× more than average |
| clsx | 48.9% of pg projects · 2.8× more than average |
By coding agent
| Claude Code | 4.8% of projects set up for it |
|---|---|
| GitHub Copilot | 5.1% of projects set up for it |
| Cursor | 5.2% of projects set up for it |
| Gemini CLI | 6.4% of projects set up for it |
| OpenAI Codex | 6.2% of projects set up for it |
| Devin Desktop | 7.7% of projects set up for it |
| OpenCode | 5.9% of projects set up for it |
| Cline | 11.1% of projects set up for it |
Share of public repos configured for each agent that list pg as a dependency.
Install
| Package | npm install pg |
|---|---|
| Main stacks | Next.js (187), TypeScript / JavaScript (169), Python (12), Rust (3) |
| Example projects | veithly/BountyBoard, inboundemail/inbound, cin12211/orca-q, Cap-go/capgo.app, Gerstep/cybos |
Alternatives to pg
| 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 |
| 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 |
| Neon Serverless Driver npm PostgreSQL driver optimized for serverless environments from Neon. |
126 (1.0%) | 4.5M | 552 | MIT |