SQL

Skeema – declarative schema management for MySQL and MariaDB

Skeema is a declarative schema management tool for MySQL and MariaDB. Instead of maintaining a series of database migration scripts, it represents the desired database structure using SQL CREATE statements stored in ordinary files.

The software compares these definitions with a live database and determines which schema changes are required. Developers can maintain the SQL files alongside their application code, review modifications through pull requests and apply approved changes to different environments.

This approach makes database structures easier to inspect, compare and track in version control. It also reduces the need to write individual ALTER statements by hand, particularly in projects where databases evolve alongside application development.

Skeema provides a Community edition covering tables, stored procedures and functions. Additional functionality for managing other database objects is available in its separate commercial edition.

This is free and open source software.

Key Features

  • Declarative schema management using standard SQL CREATE statements as the source of truth.
  • Export database objects into an organised repository, storing individual definitions in separate SQL files.
  • Compare live database structures with repository contents and automatically generate the necessary DDL statements.
  • Manage multiple environments, including development, staging and production, through environment-specific configuration.
  • Preview differences before applying schema changes to database servers.
  • Integrate schema definitions with Git workflows, allowing database changes to be reviewed alongside application code.
  • Configurable linting rules to identify schema design problems and enforce database development policies.
  • Lint complete schemas or restrict checks to objects changed in a particular revision.
  • Automation-friendly commands and exit statuses for use in continuous integration pipelines.
  • Integration with online schema change utilities, including pt-online-schema-change and gh-ost, to reduce disruption during supported table alterations.
  • Conditional configuration of online schema changes according to factors such as table size, database environment and schema.
  • Safety mechanisms intended to prevent potentially dangerous or unintended schema alterations.
  • Support for obtaining connection details through external commands, including integrations with credential management tools.
  • Community edition support for managing tables, stored procedures and functions.
  • Cross-platform support – runs on 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
DBeaverUniversal database tool
phpMyAdminMySQL web administration tool
MySQL WorkbenchComplete visual database design tool
mycliCommand line interface for MySQL, MariaDB, and Percona
gh-ostGitHub's Online Schema Migrations for MySQL
Beekeeper Studio Cross-platform SQL editor and database manager
usqlCommand-line database client
sqlitlazygit of SQL databases
MySQLTunerAnalyse MySQL performance and suggest configuration changes
HarlequinEasy, fast, and beautiful database client for the terminal
DbGateDatabase manager for MySQL, PostgreSQL, MongoDB
Percona ToolkitEssential command-line utilities for MySQL
SQuirreL SQL ClientGraphical SQL client written in Java
AdminerFull-featured tool for managing content in MySQL database
dblabInteractive client for PostgreSQL, MySQL, SQLite3, and more
MyDumperParallel utilities for fast MySQL database backups and restores
AntaresSQL client based on Electron.js and Vue.js
XtraBackupBackup utility for MySQL
innotopReal-time, advanced investigation tool
SkeemaManage MySQL and MariaDB schema changes
vi-sqlTerminal SQL client for browsing, querying and editing databases
MySQL ShellAdvanced MySQL console for scripting and database administration
SequelerNative Linux SQL client built in Vala and Gtk

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted