Free Schema-as-Code for SQL Server, PostgreSQL, MySQL, and MariaDB
Declare the schema you want. SchemaSmith computes the deployment. No hand-written migrations, no dependency chains, no guessing what your database looks like right now.
Declare the schema you want. SchemaSmith computes the deployment. No hand-written migrations, no dependency chains, no guessing what your database looks like right now.
State-based schema management works the same way on every supported platform — because you're declaring what tables, views, and procedures should look like, not writing procedural change scripts.
The state-based model flips the script. Instead of hand-writing ALTER statements that assume you know what the target database looks like right now, you declare your desired schema in JSON.
SchemaSmith compares that declaration to the live database, computes the delta, and generates the correct DDL automatically. No migration chains. No deployment archaeology.
SchemaTongs reads your live database and casts it into a clean, organized package — tables as JSON, stored procedures as SQL files, everything structured for humans and source control to understand.
Run it once against a production instance or a dev copy and you have a single source of truth to version, review, and deploy forward.
SchemaQuench reads your declared schema and applies only the changes needed to converge the database to match.
Same package works on dev, staging, and production — same engine, correct results everywhere. Boring, predictable, reliable deployments. That's the goal.
Long deployments can fail halfway through — transient network blips, lock timeouts, a migration script tripping on bad data. SchemaQuench checkpoints each completed step as it runs, so you don't have to restart from the beginning.
Use --ResumeQuench to pick up exactly where you left off. Completed work is skipped; incomplete steps execute next. The checkpoint is cleaned up automatically after a successful run, leaving no trace.
Your schema lives in source control the same way your application code does. Pull requests review table structure directly, not migration procedural steps.
Developers think in terms of design. DBAs review design. Version history tracks what each table looked like over time.
DataTongs captures reference data — lookup tables, configuration rows, seed datasets — and extracts them as deployable synchronization scripts.
Capture once, deploy alongside your schema. Reference data and table structure move together, always in sync.
Reference data with foreign-key dependencies makes load order a graph problem — insert rows in the wrong sequence and the inserts fail. DataTongs --ConfigureDataDelivery writes a DataDelivery block into each table's JSON, capturing how that table's data should be delivered.
SchemaQuench reads those blocks at deploy time and handles the dependencies in two passes — so nullable circular relationships and complex dependency graphs deploy without hand-coded sequencing.
Self-contained executables, XCOPY deployment, command-line driven. SchemaSmith integrates with GitHub Actions, Azure DevOps, GitLab CI, Jenkins, and other common CI tools.
Declare your schema in source control, let your pipeline deploy it. Works on Windows, macOS, and Linux.
Three purpose-built components that cover the entire schema lifecycle — extraction, design, deployment, and reference data.
Grips your live database and casts it into clean, organized metadata — tables as JSON, stored procedures and views as SQL files. Extract once from SQL Server, PostgreSQL, MySQL, or MariaDB and get a structured schema package ready for source control.
Deploys your declared schema to any compatible server. Reads your declaration, compares it to the target database, and applies only the changes needed. Same package, correct results everywhere — dev, staging, production.
Extracts reference data and seed datasets as deployable synchronization scripts. Lookup tables, configuration rows, and static data move alongside your schema, always in sync on every supported platform.
SchemaSmith supports a wide range of versions on every engine it targets.
Free for any purpose, any organization, any scale. One license, every supported platform, no surprises.
Managing databases for your own products and services is always permitted — whether you host them yourself or your customers do. Consultants can help with setup and configuration. The restriction is strictly on redistribution or operating SchemaSmith as a managed service on behalf of third parties.
Five free, self-paced courses walk you from first deployment to team operations. Each includes hands-on labs in a throwaway sandbox covering every supported engine.