Skeema
Safe schema management for MySQL and MariaDB.
Overview
Skeema is a specialized, SQL-first schema management tool designed explicitly for the MySQL ecosystem, including MariaDB and Percona Server. It offers a declarative, state-based approach where your Git repository acts as the single source of truth for your database schema. Instead of writing migration scripts, you define the desired state of your tables in .sql files, and Skeema generates and executes the ALTER statements needed to reach that state.
✨ Key Features
- Declarative schema management using pure SQL
- Automatic generation of DDL statements
- Support for multiple environments (dev, staging, prod)
- Integration with online schema change tools (pt-online-schema-change, gh-ost)
- Configurable linter rules to enforce policies
🎯 Key Differentiators
- Specialized for the MySQL ecosystem
- Pure SQL, declarative approach
- Strong integration with online schema change tools
Unique Value: Provides a safe, declarative, and pure-SQL way to manage schema changes for MySQL and MariaDB, eliminating the need to write migration scripts.
🎯 Use Cases (3)
✅ Best For
- Declarative schema management for MySQL-based infrastructures.
💡 Check With Vendor
Verify these considerations match your specific requirements:
- Projects using databases other than MySQL or MariaDB.
🏆 Alternatives
Unlike database-agnostic tools, Skeema is purpose-built for MySQL, offering deeper integration with its features and ecosystem tools like pt-online-schema-change.
💻 Platforms
✅ Offline Mode Available
🔌 Integrations
🛟 Support Options
- ✓ Email Support
- ✓ Dedicated Support (Premium tier)
💰 Pricing
Free tier: Skeema Community is free and open-source, supporting tables and routines.
🔄 Similar Tools in Schema Migration
Flyway
An open-source database migration tool that favors simplicity and convention over configuration....
Liquibase
An open-source tool for tracking, managing, and applying database schema changes....
Bytebase
A web-based collaboration workspace for DBAs and Developers to manage database schema changes....
Atlas
An open-source tool that brings infrastructure-as-code principles to database management....
DBmaestro
A DevOps platform for databases that automates CI/CD, provides source control, and ensures complianc...
Prisma Migrate
A database schema migration tool that is part of the Prisma ORM ecosystem....