vitaly-t/pg-promise

Health v2 · maintenance only

Adoption not part of the score

3554 stars · 221 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pg-promise is a PostgreSQL interface library for Node.js built on top of node-postgres. It provides automatic connection and transaction management, a powerful query-formatting engine, and declarative result handling via promise-based methods.

Use cases

• run postgres queries from node.js with promises
• manage database transactions automatically in node
• format sql queries with named parameters safely
• load and execute external sql files
• handle query results declaratively based on expected row count

When to choose

• you want a lightweight postgres layer without a full ORM
• you need fine-grained control over SQL and transactions
• you prefer writing raw SQL with safe parameter formatting

When to avoid

• you want an ORM with schema migrations and model definitions
• you are not using Node.js or PostgreSQL

Facets

library · maturity stable

database-driver orm database databases backend web-development postgresql promises transactions query-formatting sql nodejs javascript typescript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="vitaly-t/pg-promise")