About SchemaSmith
Free schema-as-code for SQL Server, PostgreSQL, and MySQL. Why we built it, what schema-as-code means, and how it helps teams ship.
Free schema-as-code for SQL Server, PostgreSQL, and MySQL. Why we built it, what schema-as-code means, and how it helps teams ship.
SchemaSmith comes from a team that spent decades wrangling database deployments across SQL Server, PostgreSQL, and MySQL — on-premises and SaaS, single servers and fleets hosting thousands of databases. Every brittle migration script, every drifted environment, every "is the index there or not?" production incident shaped what SchemaSmith is now. The first public release shipped in July 2025.
Three tools cover the schema lifecycle. SchemaTongs casts a live database into structured JSON. SchemaQuench deploys those definitions to target databases and corrects drift. DataTongs generates synchronization scripts for reference data. Each runs against SQL Server, PostgreSQL, and MySQL through platform-specific adapters — same workflow, platform-native definitions. Cross-platform schema management is a fiction; we don't pretend otherwise.
The full source is on GitHub at Schema-Smith/SchemaSmith, licensed under the SchemaSmith Community License (SSCL v2.0). Free for any purpose, including commercial use; the restrictions are on redistributing SchemaSmith itself or operating it as a managed service for others.
Last reviewed May 2026 by the SchemaSmith Team.
Runnable schema packages for SQL Server, PostgreSQL, and MySQL ship inside the main repo.
The SchemaSmith YouTube channel covers schema-as-code walkthroughs, platform comparisons, and migration patterns.
Three inboxes, depending on what you need.