Open-Source Trusted by
Everything You Need to Build and Scale
From secure databases to modular Postgres packages, Constructive gives you enterprise-grade infrastructure out of the box.
Security First
Tools for row-level security, access policies, and comprehensive token management
Modular Postgres Packages
Install reusable schemas, roles, functions, and policies as drop-in modules.
Automatic Dependency Resolution
PGPM analyzes module dependencies and installs them in the correct order every time.
Deterministic Migrations
Reproducible installs and updates with guaranteed ordering and conflict-safe upgrades.
Semantic Versioning
Upgrade modules with versioned changesets and safe rollback paths.
Testing Suite
Automated migration tests, fixtures, and comprehensive API contracts
database devops
Database Package Manager
Enterprise database lifecycle management and deployment tools
testing
Testing
Isolated testing environments and authentication mocking
pgsql-test
Isolated testing environments with per-test transaction rollbacks—ideal for integration tests, complex migrations, and RLS simulation.
supabase-test
Supabase-optimized testing with Auth simulation, RLS policy testing, and per-test transaction rollbacks—ideal for Supabase projects.
drizzle-orm-test
Drizzle ORM-optimized testing with schema migrations, type-safe queries, and per-test transaction rollbacks—ideal for Drizzle projects.
graphile-test
Authentication mocking for Graphile-focused test helpers and emulating row-level security contexts.
parsing ast
Parsing & AST
SQL parsing, AST manipulation, and Postgres syntax tools