constructive-ioOfficial·13 Agent Skills Included

constructive

PostgreSQL migrations, package management, and auto-generated GraphQL APIs

Manages PostgreSQL schemas as versioned, installable packages with deterministic deploy, verify, and revert migrations. Generates secure, role-aware GraphQL APIs, typed ORM clients, React Query hooks, and CLI commands directly from the database schema. Eliminates hand-written API layers, manual migration tracking, and brittle test setup with isolated database testing and RLS auditing.

52|7

↗

npx skills add constructive-io/constructive --all -g -y

Available:

Guides the agent through the monorepo layout, routing database tasks to the pgpm migration skills and GraphQL tasks to the server, codegen, and testing skills with the correct commands and conventions.

All Skills in This Repository (13)

Pure Emerald Level Indicators

📦 In Repo

constructive-io

constructive-cli

Develop interactive Node.js command-line interfaces with prompts and argument parsing.

orm-objects

Provides a type-safe ORM client for CRUD and custom queries on PostgreSQL.

orm-public

Perform type-safe CRUD operations on 103 PostgreSQL tables via GraphQL.

cli-public

Manage public GraphQL API data via the csdk command-line interface.

hooks-public

Generate typed React Query hooks for PostgreSQL public schema tables and functions.

orm-auth

Provide type-safe CRUD and custom operations for PostgreSQL authentication tables.

hooks-auth

Generate typed React Query hooks for authentication and user management APIs.

orm-admin

...

hooks-admin

Generates typed React Query hooks for GraphQL admin APIs using PostGraphile schema introspection.

cli-objects

Manage database objects, commits, references, and stores via a GraphQL CLI.

cli-auth

Manage GraphQL authentication API contexts, tokens, and CRUD operations via CLI.

hooks-objects

Generate typed React Query hooks for PostgreSQL objects API operations.

Official

Intermediate

Frequently Asked Questions

FAQPage Schema

How to install Constructive?▼

Run `npx skills add constructive-io/constructive --all -g -y` in your terminal to install all skills in this suite globally.

What does Constructive do with PostgreSQL?▼

It treats your database schema as versioned packages managed by pgpm, with plan-driven migrations, dependency resolution, and one-command deploy, verify, and revert.

How does Constructive generate a GraphQL API?▼

It uses PostGraphile to automatically expose your PostgreSQL schema as a secure GraphQL API with row-level security, JWT auth, search, and PostGIS support.

Can Constructive generate typed clients and CLIs?▼

Yes. The codegen pipeline produces type-safe ORM clients, React Query hooks, and full CRUD command-line tools directly from your GraphQL schema.

How do I test database code with Constructive?▼

The pgsql-test framework creates isolated test databases with per-test transaction rollback, JWT context simulation, and seeding helpers for reliable RLS and migration testing.