What's New

Track SchemaSmith updates across SQL Server, PostgreSQL, and MySQL — from SchemaTongs extraction to SchemaQuench deployments to DataTongs data sync.

Latest Release Release History View Docs
SchemaSmith release notes and version history

One free product, three platforms, one source tree.

One Product, Three Tools
  • New One free product, three platforms — SchemaSmith covers SQL Server, PostgreSQL, and MySQL from a shared codebase under SSCL v2.0. Free for any purpose including commercial use, with no restrictions on organization size, revenue, or environment count. The code is on GitHub for anyone to read
  • New Three tools, one workflow — SchemaTongs, SchemaQuench, and DataTongs work across all three platforms with platform-specific adapters and native DDL output. Learn once, deploy on whichever engine you run
Schema Modeling
  • New Indexed and materialized view support — SQL Server indexed views and PostgreSQL materialized views with full index management. Index-only changes skip the view rebuild
  • New Custom properties via Extensions — Attach your own metadata to any table, column, index, foreign key, or view. Custom fields are queryable from your scripts via auto-tokens, so you can drive replication, environment behavior, validation, and audit metadata from the same JSON your schema lives in
  • New Platform-specific types — Native modeling for PostgreSQL (exclude constraints, range types, materialized views) and MySQL (multi-column full-text indexes, generated columns, tablespaces). No more lowest-common-denominator schemas
Deploy Smarter
  • New Checkpoint and resume — --ResumeQuench picks up after a failed run and skips everything that already completed. No more re-running the first 50 migrations because the 51st failed
  • New FK-aware data delivery — Declare a DataDelivery block on a table and SchemaSmith handles foreign-key dependency ordering and nullable FK columns automatically. Hand-authored merge scripts go away
  • New Conditional deployment (ShouldApplyExpression) — Templates carry SQL expressions evaluated at runtime. Deploy different schemas to dev, test, and prod from the same package
  • New Multi-server deployment + custom script folders — Push the same product to multiple server instances in one run, and define your own script execution slots beyond the built-in folder structure
  • New Universal token resolution — {{TokenName}} resolves in every script (Before/After, objects, migrations, data delivery), with environment-variable overrides. Advanced tags pull values from inline queries, files, binary contents, or full schema JSON. One package parameterizes cleanly across every environment
  • New Datafix-only deployments — KindleTheForge, UpdateTables, and DropTablesRemovedFromProduct toggles let you run partial-package deployments — data fixes without schema churn, or schema-only without touching reference data
Install Anywhere
  • New Self-contained, signed executables — Single-file builds for Windows, macOS, and Linux on x64 and arm64. Zero .NET runtime required. Windows binaries are Authenticode-signed, so SmartScreen warnings are gone. Runs on minimal Linux containers without libicu
  • New Native package managers — choco install schemasmith on Windows. .deb and .rpm packages for Debian, Ubuntu, RHEL, Fedora, and Amazon Linux. One install puts all three CLI commands on your PATH

Community License v2.0: No Restrictions on Organization Size or Revenue

SQL Server Community
  • License The Community Edition is now licensed under SSCL v2.0: free for any purpose (personal, commercial, internal, production) with no restrictions on organization size, revenue, database scope, or number of environments. You cannot distribute SchemaSmith to others or operate it as an ongoing managed service for others. Setup and configuration services are permitted. Whether you're at a startup or an enterprise, the Community Edition now works at any scale, no organization size or revenue restrictions. Read the full license

License file integration, checkpoint-based deployment recovery, and five new SchemaHammer UI features strengthen reliability and streamline workflow management across all editions.

SQL Server Community v1.1.8
  • Fix SQL batch parsing now handles single quotes inside bracketed identifiers
  • Fix Foreign key comparison correctly identifies ON DELETE and ON UPDATE actions
  • Fix Fulltext index detection now captures TYPE COLUMN in existing index comparison
SQL Server Enterprise v1.2.2

Includes all Community fixes above, plus:

  • New License file integration — Encrypted license file support with automatic search path
  • New Checkpointing and Resume — Save quench progress to checkpoint files; resume interrupted deployments
  • New DeliverData appsetting — Make the automatic Data Delivery step optional
  • New VerboseLogging appsetting — Include PRINT messages in logged output
  • New SchemaHammer: Template creation — Create new templates with default folder structure from context menu
  • New SchemaHammer: Script folder sync — Adding or removing template folders auto-creates directories and tree nodes
  • New SchemaHammer: Token preview — Preview resolved query token values against the quench server
  • New SchemaHammer: Search expansion — Expand token values when searching code
  • New SchemaHammer: File picker — Browse for file-based script tokens instead of manual path entry
  • Enhanced WhatIf mode — Scripts and data delivery steps now logged for better dry-run output
  • Enhanced Tool-specific help — Each tool displays its own relevant command line switches
PostgreSQL Enterprise v1.0.2
  • New License file integration — Encrypted license file support with automatic search path
  • New Checkpointing and Resume — Save quench progress and resume interrupted deployments
  • New DeliverData appsetting — Make Data Delivery optional
  • New SchemaHammer enhancements — Template creation, folder sync, token preview, search expansion, file picker
  • Enhanced WhatIf mode improvements and tool-specific help
  • Enhanced Platform validation — Graceful error when using the wrong platform's toolset
MySQL Enterprise v1.0.0 Initial Release
  • New SchemaSmith for MySQL — Full MySQL 8.0+ support for metadata-driven schema management
  • New SchemaHammer — Visual editor for MySQL schema templates
  • New SchemaQuench — Automated deployment engine for MySQL databases
  • New SchemaTongs — Extract existing MySQL database schemas into templates
  • New DataTongs — Data extraction and delivery for MySQL
  • New License file integration, checkpointing, and resume support
  • New Events, generated columns, and AUTO_INCREMENT management
  • New InnoDB storage engine optimization and table options
  • New REPLACE INTO, INSERT ON DUPLICATE KEY UPDATE, and INSERT IGNORE data delivery
Ask Forge v1.0.1 Initial Release
  • New AI-powered CLI agent — Conversational schema management with agentic LLM workflows across SQL Server, PostgreSQL, and MySQL
  • New MCP server — Expose 46 schema tools to Claude Desktop, VS Code, Cursor, and other MCP clients
  • New 46 tools across 4 tiers — Read-only exploration, generation, modification, and external tool execution
  • New 10 LLM providers — Ollama, OpenAI, Anthropic, Azure OpenAI, Google Gemini, Groq, Mistral, DeepSeek, xAI, and custom endpoints
  • New Trust levels — Observer, Assistant, and Operator tiers control tool access with confirmation gates
  • New Interactive REPL and single commands — Persistent console sessions or one-off CLI commands for scripting and automation
  • New Schema generation from natural language — Describe what you need and Ask Forge generates platform-specific schema JSON
  • New Migration script generation — Automated migration planning with step-by-step SQL scripts
  • New Data validation tools — Detect nulls, orphaned foreign keys, duplicates, and data type mismatches
  • New 30-article knowledge base — Embedded articles covering architecture, best practices, and troubleshooting

Refined DataTongs configuration and improved PostgreSQL type handling deliver cleaner error messages and more precise data extraction for enterprise workflows.

SQL Server Community v1.1.7
  • Enhanced Simplified DataTongs configuration to reduce confusing errors and edge cases
  • Enhanced Streamlined binary distribution for easier downloads
SQL Server Enterprise v1.2.1

Includes all Community changes above, plus:

  • Enhanced Improved error messages when table or schema names contain typos
PostgreSQL Enterprise v1.0.1

Includes shared changes above, plus:

  • Fix Virtual column flag correctly handled during schema extraction
  • Fix BPCHAR type correctly mapped when extracting table definitions
  • Fix Unconstrained numeric types handled properly
  • Fix User-defined type length modifiers no longer added erroneously during extraction

PostgreSQL Enterprise edition launches alongside table import capabilities and limited patch mode, expanding SchemaSmith's reach across database platforms.

SQL Server Community v1.1.6
  • Enhanced Platform identification added to product metadata and version output
  • Enhanced Error when using the wrong platform's toolset for a product
SQL Server Enterprise v1.2.0

Includes all Community changes above, plus:

  • New SchemaHammer: Table import — Import existing database tables into a product template
  • New Limited patch mode — Run only patches and data fixes by disabling table updates and kindling
  • New Run scripts twice option — Execute scripts a second time for two-pass deployment scenarios
  • Enhanced Preserve custom properties and ShouldApplyExpression when re-extracting tables
  • Enhanced Preserve data delivery options when re-extracting tables
  • Fix Index-only mode now correctly sets product ownership
  • Fix Minor SchemaHammer UI fixes for adding table components
PostgreSQL Enterprise v1.0.0 Initial Release
  • New SchemaSmith for PostgreSQL — Full PostgreSQL support for schema management
  • New SchemaHammer — Visual editor for PostgreSQL schema templates
  • New SchemaQuench — Automated deployment engine for PostgreSQL databases
  • New SchemaTongs — Extract existing PostgreSQL database schemas into templates
  • New DataTongs — Data extraction and delivery for PostgreSQL
  • New Expression column support for index definitions
  • New WITHOUT OVERLAPS support for unique and primary key constraints
  • New Statistics management and exclude constraints
  • New Fill factor management for tables and indexes
  • New Cluster index updates
  • New Older PostgreSQL version compatibility

Targeted fixes for data handling and delivery reliability round out the fall release cycle.

SQL Server Community v1.1.5
  • Fix TEXT, NTEXT, and IMAGE column handling fixed in DataTongs
SQL Server Enterprise v1.1.5

Includes all Community fixes above, plus:

  • Fix Data delivery behavior and missing default folder fixes

Table and column rename support, expanded CLI flexibility, and streamlined installers forge a more powerful and accessible schema management experience.

SQL Server Community v1.1.3–v1.1.4
  • New Table and column renames — SchemaQuench can now handle table and column rename operations
  • New --ConfigFile switch — Specify an alternate appsettings configuration file
  • New --Version switch — Display version information from the command line
  • New --LogPath switch — Specify a custom path for log file output
  • New Zipped package support — Quench directly from a zipped schema package
  • New Combined MSI installers — Single installer packages all CLI tools together
  • Enhanced New SCHEMASMITH_ environment variable prefix for configuration
  • Fix Table trigger name comparison corrected
SQL Server Enterprise v1.1.3–v1.1.4

Includes all Community changes above, plus:

  • New DataTongs export column list — Specify which columns to include in data exports
  • Enhanced Template load performance improvements in SchemaHammer
  • Enhanced Preserve custom properties and data delivery options when re-extracting tables

Foundation release introduces DataTongs trigger controls, Docker containerization support, and core stability improvements for production-ready deployments.

SQL Server Community v1.1.0–v1.1.2
  • New DataTongs trigger control — Option to disable triggers during data load operations
  • Enhanced Docker build support improvements
  • Fix DataTongs SQL script corrections
SQL Server Enterprise v1.1.0–v1.1.2

Includes all Community changes above, plus:

  • Enhanced Data delivery integration tests and reliability improvements

Last reviewed May 2026 by the SchemaSmith Team.