Skip to content
shki
Search limited to v0.10.11. Switch to the latest version for up-to-date results.

Concepts And Scope

Snapshots and Journal

Section titled “Snapshots and Journal”

Snapshots record database shape. The Journal relates migrations to Snapshots and is the history index for generated artifacts.

Schema-derived generation uses the latest schema Snapshot from the Journal as the baseline. Custom Migrations can appear between schema-derived migrations without breaking that chain.

Checksum validation

Section titled “Checksum validation”

When status or migrate can connect to the database, shki validates stored checksums for applied migrations and reports if a migration file has changed since it was applied.

Supported dialects

Section titled “Supported dialects”
WorkflowPostgreSQLMySQLSQLite
Apply/status/down migration runneryesyesyes
Custom Migration creationyesyesyes
Dump live shape as SQL/JSONyesyesyes
Dump live shape as Directory Schemayesyesyes
Declarative Schema compile/diff/generateyesnoplanned
Rich Catalog introspection coveragestrongestbasicbasic

Declarative Schema generation is PostgreSQL-focused for now. The migration runner remains dialect-aware for PostgreSQL, MySQL, and SQLite.

Project scope

Section titled “Project scope”

Implemented or active:

  • SQL Declarative Schema loading from a single file or Directory Schema.
  • PostgreSQL Shadow Database compilation through embedded or external PostgreSQL.
  • Snapshot and Journal history for generated schema migrations.
  • diff previews based on Migration Plan summaries and rename candidates.
  • generate for schema-derived migrations.
  • Custom Migrations via create or generate --custom.
  • dump for SQL, JSON, and Directory Schema export.
  • drop for removing local migration artifacts and Journal entries.
  • Migration runner, status, checksum validation, and Down Migrations.
  • bootstrap to author a baseline from an existing database, and adopt to validate and adopt an existing environment against it.
  • Code generation from current Declarative Schema or Snapshot JSON for Rust, TypeScript, and Protobuf.

Still in progress:

  • Validation workflows for comparing Declarative Schema, Snapshot history, migration artifacts, and live database shape.
  • Full diff/render semantics for every PostgreSQL Catalog object represented by Dump.
  • Declarative Schema generation for MySQL and SQLite.
Section titled “Related projects”

shki stands on the shoulders of projects that explored these ideas first — see Inspired By.