Software
A hub of innovative open-source products developed by Constructive
Filter by tags
Database Tools
Drizzle ORM Test
A high-performance Postgres testing framework optimized for Drizzle ORM projects, enabling isolated databases, per-test rollback, schema migrations, type-safe queries, and flexible seeding strategies.
Graphile Test
Authentication mocking for Graphile-focused test helpers and emulating row-level security contexts.
@constructive-io/cli
Unified command-line interface for the Constructive ecosystem—orchestrates migrations, packages, and deployments.
@constructive-io/graphql-explorer
Visual API explorer with GraphiQL for browsing across all databases and schemas—useful for debugging, documentation, and API prototyping.
@constructive-io/graphql-query
Fluent GraphQL builder for PostGraphile schemas. Schema-aware via introspection, composable and ergonomic for building deeply nested queries.
@constructive-io/graphql-server
Express-based API server powered by PostGraphile to expose a secure, scalable GraphQL API over your Postgres database.
LibPG Query Node
Node.js bindings for libpg_query, converting SQL into parse trees.
PG Proto Parser
A TypeScript tool that parses Postgres Protocol Buffers definitions to generate TypeScript interfaces, utility functions, and JSON mappings for enums. Designed for maintainable upgrades with pgsql-parser.
PG Query Context
Session context injection to add session-local context into queries.
pglite-test
In-process Postgres testing for TypeScript — runs real migrations and tests inside your test runner using PGlite (Postgres compiled to WASM). Same getConnections() API as pgsql-test, with transaction isolation, RLS testing via setContext(), and services-free CI. No server, no Docker.
pgpm
Open-source PostgreSQL package manager and migration engine built by Constructive: versioned SQL modules, recursive dependency resolution, and plan-driven deploy, verify and revert. Documented at pgpm.io.
pgpm projections
pgpm schema projections: import any Postgres schema source into one identity-keyed model and project it as a pgpm module, linear SQL, a semantic diff migration or a content-addressed bundle.
PgSQL Deparser
The definitive Postgres deparser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.
PgSQL Enums
TypeScript enums for Postgres AST for safe and ergonomic parsing logic.
@pgsql/lint
Source-level SQL and PL/pgSQL convention linter: fully qualified references, no search_path, no dynamic SQL, with inline waivers. Pure AST, no database.
PgSQL Parser
The definitive PostgreSQL parser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.
PgSQL Test
A high-performance Postgres testing framework for TypeScript, enabling isolated databases, per-test rollback, RLS simulation, and flexible seeding strategies.
@pgsql/traverse
Babel-style visitor traversal for PostgreSQL SQL and PL/pgSQL ASTs, with statement context.
PgSQL Utils
AST utilities for constructing and transforming Postgres syntax trees.
S3 Streamer
Direct S3 streaming for large files with support for metadata injection and content validation.
safegres
Postgres security and performance auditor. Reads the system catalog of a live database and parses every RLS policy predicate and function body into an AST to answer who can actually reach each row and what checking that costs, scored on two independent axes. Audits grants, RLS enforcement, policy coverage, risky policies, and missing indexes; outputs summaries, Markdown, JSON, and SARIF for CI with failure thresholds and change-aware baselines. No agent, no traffic, nothing executed or written.
Supabase Test
A high-performance Postgres testing framework optimized for Supabase projects, enabling isolated databases, per-test rollback, Supabase Auth simulation, RLS policy testing, and flexible seeding strategies.
Upload Names
Collision-resistant filenames utility for structured and unique file names for uploads.
UUID Hash
Deterministic UUIDs generated from hashed content, great for deduplication and asset referencing.
UUID Stream
Streaming UUID generation based on piped file content—ideal for upload pipelines.