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 |
| ignore-trigger | Ignore triggers that match regex |
| my-cnf | Parse ~/.my.cnf for configuration (enabled by default; disable with skip-my-cnf) |
| 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 |