What's New

Discover the latest enhancements, improvements, and innovations forged into every SchemaSmith release.

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

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

Additional Resources

Documentation - Browse the full SchemaSmith documentation library. Docs Getting Started (Community) - Set up SchemaSmith for SQL Server in minutes. Guide Getting Started (Enterprise SQL) - Set up SchemaSmith Enterprise for SQL Server. Guide Getting Started (PostgreSQL) - Set up SchemaSmith Enterprise for PostgreSQL. Guide Getting Started (MySQL) - Set up SchemaSmith Enterprise for MySQL. Guide FAQ - Frequently asked questions about SchemaSmith. Help