Extras

node-postgres is by design pretty light on abstractions. These are some handy modules we've been using over the years to complete the picture:

Components

Standalone PostgreSQL packages.

• brianc/node-pg-native - Simple interface abstraction on top of libpq
• brianc/node-pg-types - Type parsing for node-postgres
• LinusU/pg-error-constants - error constants for more robust query error handling.

Extensions

• brianc/node-pg-cursor - Query cursor extension for node-postgres
• brianc/node-pg-copy-streams - COPY FROM / COPY TO for node-postgres. Stream from one database to another, and stuff.
• brianc/node-pg-query-stream - Query results from node-postgres as a readable (object) stream
• emilbayes/pg-ipc - IPC over PostgreSQL LISTEN/NOTIFY/UNLISTEN exposed as an EventEmitter
• kibae/pg-logical-replication - PostgreSQL Location Replication client - logical WAL replication streaming
• recursivefunk/pg-gen - Use ES6 Generators to paginate through large Postgres result sets

API wrappers

• haoliangyu/pg-reactive - a lightweight RxJS 5 wrapper for node-postgres
• holdfenytolvaj/pogi - convenient DbHandler over pg, just what you need :) (typescript,async,jsonb,you name it) .
• iceddev/pg-transact - A nicer API on node-postgres transactions
• jadbox/pg-rxjs - An RxJS based on coderhaoxin/pg-then
• langpavel/node-pg-async
• sehrope/node-pg-db - Simpler interface, named parameter support, transaction management and event hooks.
• Suor/pg-bricks - A higher level wrapper around node-postgres to handle connection settings, sql generation, transactions and ease data access.
• vitaly-t/pg-promise

Database interfaces

• grncdr/node-any-db - Thin and less-opinionated database abstraction layer for node.
• MassiveJS - A simple relational data access tool that has full JSONB document support for Postgres.

SQL template tags

• 131/sql-template - pg compliant query builder (using ES6 template string)
• sequencework/sql - SQL template tag with convenient querying functions
• XeCycle/pg-template-tag - Write queries with ES6 tagged template literals, a "poor man's query builder".

Query builders

• brianc/node-sql - SQL generation for node.js
• CSNW/sql-bricks - Transparent, Schemaless SQL Generation
• datalanche/node-pg-format - Safely and easily create dynamic SQL queries with this Node implementation of PostgreSQL format().
• hiddentao/squel - SQL query string builder for Javascript

Other

• acarl/pg-restify - Creates a generic REST API for a postgres database using restify.
• archfirst/joinjs - A simple library to map the results of complex joins to nested JavaScript objects (alternative to full-blown ORMs).
• nuodata/nuodata-db-api - REST API for a PostgreSQL database.
• vitaly-t/pg-minify - Minifies PostgreSQL scripts.
• pg-generator - Template Based Scaffolding for PostgreSQL. Command line utility which generates files for each table and schema of a PostgreSQL database.
• pg-structure - Node.js library to get structure of a PostgreSQL database automatically as a detailed object.