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
Command | Description |
---|---|
skeema add-environment | Add a new named environment to an existing host directory |
skeema diff | Compare a DB instance’s schemas to the filesystem |
skeema format | Normalize format of filesystem representation of database objects |
skeema init | Save a DB instance’s schemas to the filesystem |
skeema lint | Check for problems in filesystem representation of database objects |
skeema pull | Update the filesystem representation of schemas |
skeema push | Alter objects on DBs to reflect the filesystem representation |
Global Options
Option | Description |
---|---|
connect-options | Comma-separated session options to set upon connecting to each database instance |
debug | Enable debug logging |
help | Display usage information for the specified command |
host-wrapper | External bin to shell out to for host lookup; see manual for template vars |
ignore-schema | Ignore schemas that match regex |
ignore-table | Ignore tables that match regex |
my-cnf | Parse ~/.my.cnf for configuration (enabled by default) |
password | Password for database user; omit value to prompt from TTY (default no password) |
user | Username to connect to database host |
version | Display program version |