The SchemaSmith Toolset

SchemaSmith treats schema management as a lifecycle: extract the current schema from a live database into structured declarations, version-control those declarations alongside your application code, deploy the declarations to other environments with confidence, and synchronize reference data across all copies. Each step in that lifecycle has a tool. Together, they form a schema-as-code platform where the on-disk artifact — the schema package — is the single source of truth.

SchemaTongs extracts live schema from your database and writes it as declarative JSON. SchemaQuench reads those declarations and applies them to any target database — computing the delta, executing changes in dependency order, and checkpointing each step so failed runs can resume where they left off. DataTongs extracts reference data alongside schema and generates merge scripts that keep lookup tables, seed data, and configuration records synchronized across environments. All three tools read and write the same package format, share the same platform support, and integrate into the same source-control and CI/CD workflows.

The integration story is simple: one schema package is what all three tools understand. You extract with SchemaTongs, version-control the package, review changes in pull requests, deploy with SchemaQuench, sync data with DataTongs, and repeat. No translation layers, no export-import cycles, no platform-specific rituals — just schema as code, end to end.