Home - Schema-Smith/SchemaSmithEnterpriseDemos GitHub Wiki
Welcome to the SchemaSmithy Enterprise Demos
Shape. Strengthen. Succeed.
SchemaSmithy is a suite of opinionated, metadata-driven tools that treat SQL Server schema like source code—so your database can be versioned, automated, and deployed just like the rest of your tech stack. For those who want to jump right in, see our tutorial page or visit our YouTube channel to help you learn more.
Why SchemaSmithy?
Instead of fragile migration scripts and guesswork, SchemaSmithy gives you:
- Schema-as-code clarity with editable metadata.
- Git-friendly workflows and full version control.
- DevOps-ready deployments for CI/CD.
- Domain modeling that maps cleanly to product ownership.
Core Components
Tool | Role |
---|---|
SchemaTongs | Extracts schema metadata from SQL Server. |
SchemaHammer | Edit and refactor metadata in a structured UI. |
SchemaQuench | Applies metadata to target servers with precision. |
Why Not Migrations?
Migration scripts tell the story of how your schema evolved, but they don’t tell you what it looks like right now. SchemaSmithy is state-based—your metadata repository defines the exact end state of your server at each release.
This means your SQL Server schema is always in sync with your source control. You gain full traceability, the ability to diff per-object changes between builds, and a clear history of what changed, when, and why.
Contrast that with traditional migrations, which require manually piecing together changes across multiple files to understand the final structure. With SchemaSmithy, the current state is always explicit.
Define Product Boundaries
Use SchemaSmithy to:
- Easily model multiple applications or teams in a single server.
- Keep each domain isolated in its own metadata repository.
- Deploy different products at their own cadence depending on their rate of change.
Additional Resources
- Defining Tables
- Metadata
- Product Structure
- Product
- Template
- Script Tokens
- Migration Scripts
- Tutorials
Limitations in the Demo version
SchemaHammer is read only. You will not be able to save changes, nor add, rename, or delete any nodes. SchemaQuench is limited to 100 tables per template, 100 scripts per quench slot, and 25 scripts per top level script folder.
Download the latest binaries
Product | Platform |
---|---|
SchemaTongs Demo | .Net Core 9.0 MSI |
Framework 4.8.1 MSI | |
.Net Core 9.0 zip | |
Framework 4.8.1 zip | |
SchemaQuench Demo | .Net Core 9.0 MSI |
Framework 4.8.1 MSI | |
.Net Core 9.0 zip | |
Framework 4.8.1 zip | |
SchemaHammer Demo | .Net Core Windows 9.0 MSI |