Docs: Commands

Usage: skeema <command> [<options>]

Skeema is a declarative schema management system for MySQL and MariaDB. It allows you to export a database schema to the filesystem, and apply online schema changes by modifying CREATE statements in .sql files.

Commands

CommandDescription
skeema add-environmentAdd a new named environment to an existing host directory
skeema diffCompare a DB instance’s schemas to the filesystem
skeema formatNormalize format of filesystem representation of database objects
skeema initSave a DB instance’s schemas to the filesystem
skeema lintCheck for problems in filesystem representation of database objects
skeema pullUpdate the filesystem representation of schemas
skeema pushAlter objects on DBs to reflect the filesystem representation

Global Options

OptionDescription
connect-optionsComma-separated session options to set upon connecting to each database instance
debugEnable debug logging
helpDisplay usage information for the specified command
host-wrapperExternal bin to shell out to for host lookup; see manual for template vars
ignore-schemaIgnore schemas that match regex
ignore-tableIgnore tables that match regex
my-cnfParse ~/.my.cnf for configuration (enabled by default)
passwordPassword for database user; omit value to prompt from TTY (default no password)
userUsername to connect to database host
versionDisplay program version