Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Skeema

skeema.io

  • Free plan
  • Windows
  • macOS
  • Linux
7.7 Club score Visit skeema.io

What Skeema is

Skeema is a declarative SQL utility for managing MySQL and MariaDB schemas through changes expressed as CREATE statements in a repository. It generates SQL DDL from schema files and provides diff, lint, push, and pull commands. Configurable linter rules flag unsafe changes, and Skeema checks generated ALTER TABLE statements in a workspace before proceeding. For online changes, it supports native database alterations and tools such as pt-online-schema-change and gh-ost, with execution configured by environment and table size. Schema directories can map to multiple servers or schemas, and the utility can detect drift across shards. The site lists MySQL 5.5–9.7, MariaDB 10.1–12.3, and Percona Server; AWS Aurora MySQL 5.7–8.4 is listed for Premium. Skeema Cloud Linter can produce automatic diff and lint output for relevant GitHub commits. All editions can use SSL/TLS, while Premium adds client certificates, CA verification options, and SSH tunnels. The free Community plan costs nothing; paid plans start at $124 a month. Community lists Linux and macOS; paid Plus and Max list Linux, macOS, and Windows.

Who it suits

Skeema suits database teams that manage MySQL or MariaDB schema changes through SQL files and repository workflows. Community is free open-source software; Premium Plus is positioned for smaller teams and Max for larger organizations.

Good to know, and what to watch

  • Provides diff, lint, push, and pull commands.
  • Checks generated ALTER TABLE statements before proceeding.
  • Supports native online changes and external migration tools.
  • Can detect schema drift across shards.
  • Public technical support is available to CLI users.
  • Does not manage users, grants, roles, or global variables.
  • MariaDB sequences are not yet supported.
  • Community lists Linux and macOS only.
  • Paid plans start at $124 a month.

Community

Free

Plus

$124/mo

Max

$499/mo

Skeema Cloud Linter

$649/yr

Free plan

Getting started

  1. Open the Skeema website
  2. Choose Community, Plus, Max, or the Cloud Linter add-on
  3. Install on Linux, macOS, or Windows according to the selected plan
  4. Place CREATE-based schema files in a repository
  5. Run diff, lint, push, or pull against the supported databases
  6. Connect GitHub repositories to Cloud Linter when using that add-on

Limits to check

Community lists tables, stored procedures and functions, 18 linter checks, and Linux and macOS support. Plus limits sharding to 10 shards per directory, while Max lists unlimited sharding; Cloud Linter is an optional $649 per-year add-on.

The Club's review

Skeema is a SQL schema management utility for teams that keep MySQL or MariaDB definitions in a repository. It suits developers and database teams who want repeatable, reviewable changes across one or many servers. Its strongest case is controlled deployment with shard awareness; its narrower scope and lack of rollback support are real constraints.

Overview

Skeema turns schema files containing CREATE statements into database DDL, with commands to diff, lint, push, and pull changes. Keeping those definitions in a repository gives teams a consistent workflow for reviewing schema updates and connecting them to CI/CD. Drift detection and a self-hosted option also help teams track and manage schemas across their own environments.

Before changes proceed, configurable linter rules detect unsafe operations and Skeema verifies generated ALTER TABLE statements in a workspace. For online changes, it supports database-native alterations as well as pt-online-schema-change and gh-ost, with execution configurable by environment and table size. Those controls can help teams adapt deployments to different tables and environments, but Skeema does not provide rollback support.

Key features

Schema coverage and compatibility

The Community edition covers tables, stored procedures, and functions, with 18 linter checks. Paid Plus and Max add views, triggers, events, and seed data. Skeema supports MySQL 5.5–9.7, MariaDB 10.1–12.3, and Percona Server; AWS Aurora MySQL 5.7–8.4 support is included with Premium. That broad MySQL-family coverage makes it relevant to mixed deployments, although MariaDB sequences are not supported.

Sharding and drift

A schema directory can map to multiple servers or schemas, and Skeema can detect drift across shards. This is especially useful for teams maintaining repeatable structures across partitioned or tenant databases. Plus caps sharding at 10 shards per directory, while Max removes that cap; teams beyond the Plus limit need to budget for Max.

GitHub workflow and security

Skeema Cloud Linter can automatically return diff and lint output for Skeema-related commits in GitHub repositories and supports pull request workflows through cloud-based CI. All editions support SSL/TLS connections. Premium adds client certificates, CA verification options, and SSH tunnels, which give organizations more connection controls.

Scope limits

Skeema manages tables and routines, with broader object coverage on paid plans, but it does not manage database users, privilege grants, roles, or global variables. Teams that need one tool to manage those administrative objects alongside schema changes will need a separate solution.

Pricing

Community is free and open source under Apache 2.0. It includes tables, stored procedures and functions, 18 linter checks, and Linux and macOS support. It is a sensible starting point for individuals and teams that can work within that object set and operating system coverage.

Plus costs $124 a month, billed $124/month or $1238/year. It adds routines, views, triggers, events, seed data, Windows support, sharding up to 10 shards per directory, and public support. It fits smaller teams that need broader schema coverage or Windows, while public technical support through GitHub issues is available to all CLI users.

Max costs $499 a month, billed $499/month or $4988/year. It includes the same listed schema objects and platform support as Plus, unlimited sharding, and private email technical support. Larger organizations with more than 10 shards per directory or a need for private support are its clearest audience.

Skeema Cloud Linter is an optional SaaS add-on at $649 a year, billed $649 a year. It covers an entire GitHub organization and automates diff and lint output for Skeema commits. The add-on is aimed at organizations that want those checks in a GitHub pull request workflow; the standalone CLI plans remain an option for teams without that requirement.

Platforms

Community runs on Linux and macOS. Plus and Max add Windows. Skeema also supports self-hosting, which suits teams that want to run schema management within their own infrastructure.

Who it's for

Skeema is a strong fit for development and database teams using MySQL or MariaDB that want schema definitions reviewed in a repository and deployments guarded by linting and workspace verification. Its shard mapping and drift detection are particularly useful when the same schema must stay aligned across multiple databases. Community is suited to teams with modest object needs; Plus targets startups and smaller teams, while Max is positioned for larger organizations.

It is a weaker fit for teams managing PostgreSQL schemas, relying on MariaDB sequences, needing rollback support, or expecting one product to manage users, grants, roles, and global variables as well as tables and routines.

Pros and cons

  • Pros: Repository-based diff, lint, push, and pull commands make schema changes reviewable and repeatable.
  • Pros: Configurable linting and workspace verification of generated ALTER statements add safeguards before deployment.
  • Pros: Native and external online alteration options, plus shard drift detection, suit deployments with varied table sizes and multiple database targets.
  • Cons: No rollback support leaves teams without a built-in way to reverse a pushed schema change.
  • Cons: Users, grants, roles, global variables, and MariaDB sequences fall outside its supported scope.
  • Cons: The free plan omits Windows and paid object types; unlimited sharding and private email support require the much higher-priced Max plan.

Alternatives

For a broader comparison, browse Database Schema Comparison Tools and Database Migration Tools.

  • dbForge Studio for PostgreSQL is a freemium, cross-platform option with a free Express plan that includes code completion, formatting, query history, a visual data editor, and data import and export.
  • Redgate SQL Provision is a paid alternative with a free trial and capacity tiers based on production data volume, from 1TB to 100TB.
  • SQL Delta is a paid, Windows-only database comparison tool with a free trial.
  • sqldef is a free, open-source CLI tool for Linux, macOS, Windows, and self-hosted use.
  • apgdiff is a free, MIT-licensed PostgreSQL schema diff tool for Linux, macOS, and Windows.
  • pgquarrel is free BSD-3-Clause software for Linux, Windows, and self-hosted use.
  • SQL DXP is a paid Windows option with a free trial.
  • dbdiff is a free option for Linux, macOS, Windows, and self-hosted use.

Verdict

Choose Skeema if your team manages MySQL or MariaDB schemas in a repository and needs controlled changes across multiple environments or shards. Its review workflow, safety checks, and online alteration options make it a focused choice for that job. Look elsewhere if rollback, PostgreSQL support, MariaDB sequences, or administration of users and permissions is central to your workflow.

The verdict

Skeema focuses on repository-based schema changes for MySQL and MariaDB, with linting, safety checks, and configurable online alterations. Teams should account for its stated exclusions, including database users, grants, roles, and global variables.

Questions people ask

Is Skeema open source?

Skeema Community is described as free open-source software and uses the Apache 2.0 license.

What does Skeema cost?

Community is free. Plus is $124 a month, Max is $499 a month, and Skeema Cloud Linter is $649 a year.

Which operating systems are supported?

Plus and Max list Linux, macOS, and Windows. Community lists Linux and macOS.

Which databases does Skeema support?

The site lists MySQL 5.5–9.7, MariaDB 10.1–12.3, and Percona Server. Premium adds AWS Aurora MySQL 5.7–8.4.

Does Skeema integrate with GitHub?

Skeema Cloud Linter can automatically provide diff and lint output for Skeema commits in GitHub repositories and support pull-request workflows.

What does Skeema not manage?

Skeema does not manage database users, privilege grants, roles, or global variables, and MariaDB sequences are not yet supported.

What the maker publishes

Database compatibility
The site lists support for MySQL 5.5–9.7, MariaDB 10.1–12.3, Percona Server, and—on Premium—AWS Aurora MySQL 5.7–8.4. source
Founded
2016 source
GitHub integration
Skeema Cloud Linter provides automatic diff and lint output for Skeema-related commits in GitHub repositories and supports a pull-request workflow through cloud-based CI. source
Headquarters
Northern New Jersey, United States source
Intended users
Skeema Community is described as free open-source software, while Premium Plus is positioned for startups and smaller teams and Max for larger organizations. source
Maker history
The Skeema CLI was initially released in 2016, and its creator Evan Elias independently created the tool to bring declarative schema management to MySQL and MariaDB. source
Notable limits
Skeema does not manage database users, privilege grants, roles, or global variables, and MariaDB sequences are not yet supported. source
Online schema changes
Skeema supports database-native online alterations and external tools such as pt-online-schema-change and gh-ost, with configurable execution based on environment and table size. source
Purpose
Skeema is a declarative SQL-based schema management utility that applies changes expressed as CREATE statements in a repository to MySQL and MariaDB tables and routines. source
Safety
Skeema uses configurable linter rules, detects unsafe changes, and verifies generated ALTER TABLE statements in a workspace before proceeding. source
Schema workflow
Skeema generates SQL DDL from schema files and provides diff, lint, push, and pull commands. source
Security
All editions can use SSL/TLS connections; Premium adds client certificates, CA verification options, and SSH tunnels. source
Sharding
Skeema can map a schema directory to multiple database servers or schemas and can detect schema drift across shards. source
Support
Public technical support is available to all CLI users through GitHub issues, while private technical support is included with Max. source

Checked against the maker's pages on 29 Sept 2026.