pg-promise

PostgreSQL framework for native SQL using promises.

EstablishedOpen SourceLow lock-in

Pricing

Free tier

Flat rate

Adoption

Cooling

License

Open Source

Data freshness

Aging · Jun 8, 2026

Overview

What is pg-promise?

Pg-promise is a PostgreSQL client that simplifies database interactions by leveraging JavaScript promises. It's designed to make working with SQL in Node.js more intuitive and efficient, enhancing developer productivity.

Key differentiator

Pg-promise stands out as a lightweight, promise-based PostgreSQL client that simplifies database interactions without the overhead of an ORM.

Capability profile

Capability Radar

Ease of StartEcosystemValueMaturityFlexibilityScale Ready

Honest assessment

Strengths & Weaknesses

↑ Strengths

Promise-based SQL queries for PostgreSQLmedium

Supports transactions, prepared statements, and named parametersmedium

Extensive documentation and community supportmedium

↓ Weaknesses

Limited ecosystem integrationshigh

Pg-promise primarily focuses on PostgreSQL and lacks native support for other databases, limiting its utility in polyglot persistence environments.

Performance overhead due to promise-based architecturemedium

Promise handling can introduce additional latency compared to callback or async/await patterns, especially under high concurrency scenarios.

Small community and limited third-party supporthigh

The tool has a smaller user base compared to other PostgreSQL clients like pg, leading to fewer plugins and integrations available from the community.

Fit analysis

Who is it for?

✓ Best for

Node.js developers who need a lightweight, promise-based PostgreSQL client for efficient database operations.

Projects requiring transactional support and prepared statements in PostgreSQL.

✕ Not a fit for

Developers looking for a full-featured ORM solution

Applications that require real-time data streaming capabilities

Cost structure

Pricing

Free Tier

Available

Open source — free to use

Starts at

$0

Model

Flat rate

Enterprise

None

Performance benchmarks

How Fast Is It?

Ecosystem

Relationships

Next step

Get Started with pg-promise

Step-by-step setup guide with code examples and common gotchas.

View Setup Guide →