SchemaSmith for PostgreSQL

Extract, version, and deploy your PostgreSQL schemas from source control. No migration scripts. Just JSON.

Getting Started

The Tools

Three CLI tools cover the schema lifecycle on PostgreSQL.

Extract a live PostgreSQL schema into versioned JSON table definitions and SQL object scripts.

Documentation Walkthrough

Deploy schema packages to PostgreSQL targets with dependency ordering and idempotent scripts.

Documentation Walkthrough

Generate MERGE scripts for reference and seed data that deploy alongside schema changes.

Documentation Walkthrough

Start with the fundamentals, then go deeper into the SchemaSmith model.

Install the tools and run your first package.

Add tables, write functions, extract drift, bootstrap environments.

Structure of the artifacts SchemaSmith deploys.

Settings, connection strings, and env vars.