pgpm
A Postgres Package Manager. Install, version, and compose reusable modules with dependency resolution.
Explore pgpmOpen-source modular Postgres framework with reusable database packages, dependency management, and deterministic migrations.
A Postgres Package Manager. Install, version, and compose reusable modules with dependency resolution.
Explore pgpmIsolated Postgres testing with automatic rollbacks and RLS simulation.
Explore TestingFrom secure databases to modular Postgres packages, Constructive gives you enterprise-grade infrastructure out of the box.
Tools for row-level security, access policies, and comprehensive token management
Install reusable schemas, roles, functions, and policies as drop-in modules.
PGPM analyzes module dependencies and installs them in the correct order every time.
Reproducible installs and updates with guaranteed ordering and conflict-safe upgrades.
Upgrade modules with versioned changesets and safe rollback paths.
Automated migration tests, fixtures, and comprehensive API contracts
Enterprise database lifecycle management and deployment tools
Security and performance auditing for live Postgres databases
Isolated testing environments and authentication mocking
Isolated testing environments with per-test transaction rollbacks—ideal for integration tests, complex migrations, and RLS simulation.
pgsql-test backed by in-process PGlite — instant, isolated Postgres tests with no server to run, built for CI.
Supabase-optimized testing with Auth simulation, RLS policy testing, and per-test transaction rollbacks—ideal for Supabase projects.
Drizzle ORM-optimized testing with schema migrations, type-safe queries, and per-test transaction rollbacks—ideal for Drizzle projects.
Authentication mocking for Graphile-focused test helpers and emulating row-level security contexts.
SQL parsing, AST manipulation, and Postgres syntax tools
SQL conversion engine that interprets and converts Postgres syntax.
The definitive Postgres deparser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping.
Node.js bindings for libpg_query, converting SQL into parse trees.
Type definitions for Postgres AST nodes in TypeScript.
TypeScript enums for Postgres AST for safe and ergonomic parsing logic.
Babel-style visitors for Postgres SQL and PL/pgSQL ASTs, with statement context.
Convention linter for SQL and PL/pgSQL: qualified references, no search_path, no dynamic SQL.