Skeema is a declarative schema management system for MySQL and MariaDB.
It stores database definitions as SQL CREATE statements in a repository and then compares that desired state with live databases to generate the DDL needed to bring them into sync. The tool is designed for teams that want a pull-request-driven workflow for schema changes, along with environment-aware configuration and safer handling of database updates.
This is free and open source software.
Key Features
- Exports database objects into an organized schema repository, with each object stored in its own SQL file.
- Automatically generates DDL by diffing live databases against schema files.
- Supports multiple named environments such as development, staging, and production.
- Can integrate with online schema change tools such as pt-online-schema-change and gh-ost.
- Includes configurable linter rules to catch schema design problems and enforce policies.
- Supports management of tables, stored procedures, and functions in the Community edition.
- Cross-platform support – runs under Linux and macOS.
Website: github.com/skeema/skeema
Support:
Developer: Skeema LLC
License: Apache License 2.0
Skeema is written in Go. Learn Go with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| OmniDB | Collaborative environment For database management |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |