Skeema

Skeema is a SQL schema-management utility for teams that keep MySQL and MariaDB structure in a repository. It best suits developers who want reviewable, repeatable schema changes and safeguards before deployment. Its strengths are deployment controls and shard awareness; its narrower scope and lack of rollback support matter when choosing a plan or tool.

Overview

Skeema turns repository schema files into database DDL, with commands to diff, lint, push, and pull changes. That makes it a practical fit for teams who want database structure managed alongside application code rather than through a separate, ad hoc workflow. Schema diffs, CI/CD automation, drift detection, and a self-hosted option support that approach.

Configurable lint rules flag unsafe changes, and Skeema verifies generated ALTER TABLE statements in a workspace before proceeding. For online changes, teams can choose native database alterations or external tools such as pt-online-schema-change and gh-ost, with execution tuned by environment and table size. These checks and options are useful deployment controls, but they do not provide rollback support.

Key features

Repository workflow and safeguards

Diff and lint commands help teams review proposed schema changes before pushing them. Workspace verification adds another check on generated ALTER statements, which is valuable when a change could affect production tables. The tool's declarative SQL approach will appeal most to teams comfortable expressing desired structure as CREATE statements.

Online changes and sharding

Online alteration options let teams use database-native behavior or integrate established external tools, with execution configurable by environment and table size. Skeema can also map a schema directory to multiple servers or schemas and detect drift across shards. Plus caps sharding at 10 shards per directory; Max removes that cap, making the higher tier more relevant for larger distributed deployments.

Compatibility and boundaries

Skeema supports MySQL 5.5–9.7, MariaDB 10.1–12.3, and Percona Server; AWS Aurora MySQL 5.7–8.4 is supported on Max. SSL/TLS connections are available in all editions, while Max adds client certificates, CA verification options, and SSH tunnels. Skeema does not manage database users, grants, roles, or global variables, and MariaDB sequences are not supported, so teams needing those objects must handle them elsewhere.

Skeema Cloud Linter adds automatic diff and lint output for Skeema-related commits in GitHub repositories through cloud-based CI and supports pull-request workflows. Public technical support is available to CLI users; private email technical support comes with Max.

Pricing

Community is free open-source software under Apache 2.0. It covers tables, stored procedures, and functions, with 18 linter checks, and runs on Linux and macOS. It is the sensible starting point for open-source use or teams whose schema objects and operating systems fit those limits, but it excludes views, triggers, events, seed data, and Windows.

Plus costs $124 a month, billed at $124/month or $1238/year. It adds views, triggers, events, and seed data alongside tables and routines, supports Linux, macOS, and Windows, and includes public support and sharding up to 10 shards per directory. This is the fit for smaller teams that need the expanded object coverage or Windows support without unlimited sharding or private support.

Max costs $499 a month, billed at $499/month or $4988/year. It includes the same schema-object coverage and platforms as Plus, with unlimited sharding, private email technical support, and the additional connection-security options. Larger organizations with extensive shard fleets or a need for private support have the clearest reason to pay the premium.

Skeema Cloud Linter is an optional SaaS add-on at $649 a year. It covers an entire GitHub organization and automates diff and lint output for Skeema commits; teams seeking this cloud review workflow should account for it separately from the CLI plan.

Platforms

Community runs on Linux and macOS. Plus and Max add Windows support. The listed database scope spans MySQL, MariaDB, and Percona Server, with AWS Aurora MySQL support reserved for Max. That makes the edition choice consequential for Windows users and Aurora deployments, not merely a question of team size.

Who it's for

Skeema is strongest for MySQL- and MariaDB-focused teams that want SQL schemas in version control, pre-deployment checks, and configurable online changes. Its sharding features make it particularly relevant to multi-server environments. It is a weaker fit for teams that need schema rollback, database user and privilege management, or MariaDB sequences within the same tool.

Pros and cons

Pros

• Repository-based diff, lint, push, and pull workflow gives teams a repeatable path for schema changes.
• Unsafe-change checks and workspace verification provide safeguards before generated ALTER statements proceed.
• Native and external online-change options, plus shard drift detection, suit varied deployment setups.
• Community is free, while paid tiers add broader object coverage and Windows support.

Cons

• No rollback support, so teams should not treat Skeema as a recovery mechanism for a bad deployment.
• Community is limited to Linux and macOS and covers fewer schema objects than Plus or Max.
• Users, grants, roles, global variables, and MariaDB sequences fall outside its management scope.
• Aurora MySQL support and private support require Max, a substantial step up from Plus.

Alternatives

Database Migration Tools and Database Schema Comparison Tools are useful starting points for comparing the broader categories.

• Atlas is worth considering if its open-core model, free plan, free trial, or API and self-hosted platform options better match your setup.
• FluentMigrator is a free Apache-2.0 framework distributed through NuGet, a relevant alternative for teams choosing provider packages separately.
• Bytebase Enterprise offers a free Community plan for up to 20 users and 10 database instances, with a paid Pro option; consider it if those stated limits and its API, self-hosted, or web platforms suit your needs.
• SchemaHero is a free alternative with Linux, macOS, self-hosted, web, and Windows platforms.
• sqldef is a free alternative available for Linux, macOS, self-hosted, web, and Windows.
• Alembic is free open-source software under the MIT license, with a self-hosted platform option.
• Liquibase has a free plan and a Starter plan for up to five applications and one database type, with professional services required for onboarding and implementation.
• Redgate SQL Provision is a paid option with a free trial and capacity tiers based on production data volume to provision or mask.

Verdict

Choose Skeema if your team wants repository-managed MySQL or MariaDB schemas, meaningful pre-deployment checks, and configurable online changes, especially across shards. Community is a capable free starting point within its object and platform limits; Plus or Max makes sense when those limits become blockers. Look elsewhere if rollback, database access-control management, or broader schema-object coverage in the free tier is essential.