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:

• brianc/node-pg-native - Simple interface abstraction on top of libpq
• brianc/node-pg-query-stream - Query results from node-postgres as a readable (object) stream
• 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-types - Type parsing for node-postgres
• Suor/pg-bricks - A higher level wrapper around node-postgres to handle connection settings, sql generation, transactions and ease data access.
• grncdr/node-any-db - Thin and less-opinionated database abstraction layer for node.
• brianc/node-sql - SQL generation for node.js
• hiddentao/squel - SQL query string builder for Javascript
• 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().
• 131/sql-template - pg compliant query builder (using ES6 template string)
• sequencework/sql - SQL template tag with convenient querying functions
• iceddev/pg-transact - A nicer API on node-postgres transactions
• sehrope/node-pg-db - Simpler interface, named parameter support, transaction management and event hooks.
• vitaly-t/pg-promise - Use node-postgres via Promises/A+.
• langpavel/node-pg-async - Tiny but powerful Promise based PostgreSQL client designed for easy use with ES7 async/await.
• kriasoft/node-pg-client - Promise-based wrapper for node-postgres designed for easy use with ES7 async/await.
• pg-then A tiny wrapper of pg for promise api.
• pg-rxjs Another tiny wrapper like pg-then but for RxJS
• acarl/pg-restify - Creates a generic REST API for a postgres database using restify.
• nuodata/nuodata-db-api - REST API for a PostgreSQL database.
• XeCycle/pg-template-tag - Write queries with ES6 tagged template literals, a "poor man's query builder".
• recursivefunk/pg-gen - Use ES6 Generators to paginate through large Postgres result sets
• vitaly-t/pg-minify - Minifies PostgreSQL scripts.
• MassiveJS - A simple relational data access tool that has full JSONB document support for Postgres.
• pg-ka-fix - TCP keep-alive extension for node-postgres.
• archfirst/joinjs - A simple library to map the results of complex joins to nested JavaScript objects (alternative to full-blown ORMs).
• typed-typings/typed-pg - pg type definition for TypeScript.
• pogi - convenient DbHandler over pg, just what you need :) (typescript,async,jsonb,you name it) .
• emilbayes/pg-ipc - IPC over PostgreSQL LISTEN/NOTIFY/UNLISTEN exposed as an EventEmitter
• pg-structure - Node.js library to get structure of a PostgreSQL database automatically as a detailed object.
• pg-generator - Template Based Scaffolding for PostgreSQL. Command line utility which generates files for each table and schema of a PostgreSQL database.
• pg-logical-replication - PostgreSQL Location Replication client - logical WAL replication streaming
• haoliangyu/pg-reactive - a lightweight RxJS 5 wrapper for node-postgres
• LinusU/pg-error-constants - error constants for more robust query error handling.