Declarative SQL, not migrations
Declare your schema using only familiar CREATE-based SQL statements.
NSchema will diff the desired schema against the database (or a snapshot), and compute the migration automatically.
NSchema
A declarative database schema migration tool. Describe the schema you want; NSchema computes and applies the migration to get there.
Why NSchema?
Section titled “Why NSchema?”Plan before you apply
Every run previews the exact changes first, Terraform-style. See the schema and the exact SQL that will be executed before you apply.
Not ready to commit? Save the plan-file to disk, and apply it later.
Safe by default
Destructive changes are blocked by default unless overridden, drift checking prevents unintended changes, and offline state snapshots allow you to produce plans without needing direct access to the database.
Adopt any database
Connect to an existing database using a supported NSchema provider. Run nschema import and output your current schema out as DDL, ready to check in and manage from there.
Start here
Section titled “Start here”What is NSchema?The idea, the model, and who it's for.
InstallationInstall the nschema global tool.
QuickstartFrom empty directory to applied schema in five minutes.
CLI referenceEvery command, flag, and exit code.
DDL languageHow to declare schemas, with the full grammar.
Embedding the libraryUse the NSchema.Core engine directly from .NET.