SchemaSmith is unclaimed —

SchemaSmith

Shape. Strengthen. Succeed.·schemasmith.com

SchemaSmith is a schema-as-code toolset for SQL Server, PostgreSQL, and MySQL. Users declare the desired schema state in JSON, and the toolset computes and deploys the required migration automatically. It includes SchemaTongs for extracting live database schemas into version-controlled files, SchemaQuench for deploying declared schema changes, and DataTongs for exporting seed/reference data as deployable synchronization scripts.

What it's for

Extract an existing database schema into source controlDeploy schema changes without hand-writing ALTER scriptsVersion and review reference/seed data alongside schemaDetect and correct database schema driftIntegrate schema deployment into CI/CD pipelinesResume failed or interrupted schema deploymentsHandle foreign-key-dependent reference data load order

Features 12

Automatic computation of schema deployment deltas
CI/CD pipeline integration
Command-line driven operation
Cross-platform support for SQL Server, PostgreSQL, and MySQL
DataTongs: exports reference/seed data as versioned deployable scripts
FK-aware data delivery via --ConfigureDataDelivery
Resume failed deployments via --ResumeQuench checkpointing
SchemaQuench: deploys declared schema and applies only necessary changes
SchemaTongs: extracts live database schema into JSON and SQL files
Self-contained executables with XCOPY deployment
Source-control-friendly schema packages for pull request review
State-based schema declaration in JSON

At a glance

free tieropen source

TypeCLI tool

DeploymentInstalled (local)

PlatformsWindows, macOS, Linux

Fordevelopers, DBAs

CompanySchemaSmith

Integrations

GitHub ActionsJenkinsAzure DevOpsGitLab CI

Resources

Docs

Pricing

Fully free software licensed under the SchemaSmith Community License (SSCL v2.0); no paid tiers are listed.

SchemaSmith Community License (SSCL v2.0)Free

Cannot redistribute SchemaSmith as a standalone product or operate it as a managed service on behalf of third parties.

No usage caps, no organization-size restrictions, no environment limits