SchemaSmith Documentation

Documentation

Browse documentation by database platform.

Start here

New to SchemaSmith? Get oriented before picking a platform.

Platform-neutral introduction

Understand the three tools — SchemaTongs, SchemaQuench, and DataTongs — and how they fit together before diving into platform-specific reference.

Read Getting Started

Pick your platform

SchemaSmith manages schemas for three databases. Each has its own tables, types, and templates.

SQL Server

Extract, version, and deploy Microsoft SQL Server schemas with SchemaTongs, SchemaQuench, and DataTongs.

PostgreSQL

Extract, version, and deploy PostgreSQL schemas with SchemaTongs, SchemaQuench, and DataTongs.

MySQL

Extract, version, and deploy MySQL schemas with SchemaTongs, SchemaQuench, and DataTongs.

Explore further

Cross-platform reference and long-form guides for going deeper.

Core Concepts

Cross-platform fundamentals — schema packages, migrations, data delivery, rollback, and how the SchemaSmith model works under the hood.

Tool Reference

Reference for the three command-line tools: SchemaTongs (extract), SchemaQuench (deploy), and DataTongs (data load and unload).

Deep-Dive Guides

Long-form guides on zero-downtime deployments, rollback strategies, schema drift, dependency management, and database DevOps.