pg-parade

pg-parade (v0.4.3, last updated in 2017) wraps pg-promise to provide read/write replica support for PostgreSQL connections. It allows explicit routing of SELECT queries to read replicas and INSERT/UPDATE/DELETE to write replicas, with automatic fallback of reads to the write server during transactions. Key differentiators include a simple API with `.read` and `.write` scope objects and support for replica selection via a function returning a promise. However, the package is unmaintained and not compatible with modern pg-promise or async/await patterns.