Awesome

Skeema is a tool for managing MySQL and MariaDB schema changes in a declarative fashion using pure SQL. The Skeema CLI tool allows you to:

Export CREATE TABLE statements to the filesystem, for tracking in a Git repo
Diff changes in the schema repo against live DBs to automatically generate DDL
Manage multiple environments (e.g. dev, staging, prod) and keep them in sync with ease
Configure use of online schema change tools, such as pt-online-schema-change, gh-ost, or spirit, for performing ALTER TABLE
Apply configurable linter rules to proactively catch schema design problems and enforce company policies

Skeema supports a pull-request-based workflow for schema change submission, review, and execution. This permits your team to manage schema changes in exactly the same way as you manage code changes.

Products and downloads

This repo is the free open source Community edition of the Skeema command-line tool. The Community edition supports management of tables and routines (procs/funcs). Builds are provided for Linux and MacOS.

The paid Premium edition of the Skeema CLI adds support for managing views, triggers, and events. It also includes a native Windows build, built-in SSH tunnel functionality, seed data management, and many other improvements.

For download links and more information, visit skeema.io.

Documentation

Page	Description
Installation	How to install the Skeema CLI tool
Getting started	Usage examples and screencasts
Requirements	Supported database systems and required database privileges
Features	How Skeema interacts with each type of database object, and various feature-specific topics
Configuration guide	Option handling, config file format, and command-line option usage
Command reference	Usage instructions for each command in the Skeema CLI
Option reference	Detailed information on every Skeema option
Schema change workflow	Recommended flow for pull-request-driven schema changes
Pipelines and automation	Integrating Skeema into automated workflows
Recipes	Using Skeema to achieve common schema management tasks
FAQ	Frequently asked questions about Skeema

Credits

Created and maintained by @evanelias, and developed with assistance from our many contributors and users.

Support for stored procedures and functions generously sponsored by Psyonix.

Support for partitioned tables generously sponsored by Etsy.

License

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.