skeema/skeema

Health v2 · maintenance only

Adoption not part of the score

1376 stars · 106 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Skeema is a Go-based CLI tool for declarative MySQL and MariaDB schema management using pure SQL CREATE statements tracked in version control. It diffs live databases against a schema repo to auto-generate DDL, with linting rules and online schema change integration.

Use cases

• manage mysql schema changes declaratively in git
• auto-generate alter table ddl from schema diff
• keep dev staging and prod database schemas in sync
• lint database schema design in ci
• run online schema changes with gh-ost or pt-online-schema-change
• review database schema changes via pull requests

When to choose

• you use MySQL or MariaDB and want schema-as-code with pure SQL files
• you need safe, battle-tested automatic DDL generation and diffing
• your team wants PR-based workflows and CI linting for schema changes
• you need non-disruptive ALTERs via online schema change tools

When to avoid

• you primarily use PostgreSQL or other non-MySQL databases
• you prefer imperative migration scripts over declarative state
• you need the Premium features like foreign key management without paying

Facets

cli-tool · maturity active

database linter cli developer-tools configuration-management databases developer-tools cli go mysql mariadb schema-management schema-diff declarative-migrations sql online-schema-change database-migrations devops automation linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="skeema/skeema")