oguimbal/pg-mem

Health v2 · maintenance only

Adoption not part of the score

2360 stars · 116 forks observed · 2026-08-28

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

pg-mem is an in-memory emulation of a PostgreSQL database written in TypeScript, usable in Node.js or the browser. It lets you run SQL queries against a fake Postgres instance, making it ideal for mocking the database layer in unit tests.

Use cases

• mock a postgres database in unit tests
• run sql queries in memory without a real postgres server
• test typeorm or pg-promise code without a database
• create restore points and roll back database state between tests
• parse and validate postgres sql syntax in javascript

When to choose

• you want fast, dependency-free database mocks for unit tests
• your tests use pg-promise, typeorm, node-postgres, or slonik
• you need to run simple postgres queries in a browser or deno

When to avoid

• you need full postgres feature coverage or complex query fidelity
• you are running integration tests against a real database
• your sql uses advanced postgres syntax that may not be supported

Facets

library · maturity active

database testing mocking parser databases testing developer-tools browser in-memory-database postgresql-emulation sql-parser unit-testing test-doubles nodejs deno typescript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="oguimbal/pg-mem")