Inspired By

shki stands on the shoulders of projects that explored these ideas first. Thanks to their authors — most of what’s good here started as something one of them proved out.

• pgschema — declarative, Terraform-style schema management for PostgreSQL. The plan-then-apply shape of diff and generate owes it a great deal.
• Drizzle ORM — the SQL-first philosophy and the Snapshot + Journal migration history that shki records alongside each migration.
• jayy-lmao/sql-gen — generating typed Rust code from a database schema, the idea behind codegen.
• squirrel — type-safe SQL code generation from introspected queries, an ancestor of queries.
• sqlc — the -- name: … :one annotation style that typed queries borrow wholesale.
• goose — a database migration tool supporting SQL migrations and Go functions; the migration-runner behavior behind migrate and status.

Also thanks to Astro Starlight, which this documentation site is built with.