skeema1
Declarative database schema management system
Usage
skeema [<options>]
<command>
Overview
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:
- add-environment
-
Add a new named environment to an existing host directory
- diff
-
Compare a DB instance's schemas to the filesystem
- format
-
Normalize format of filesystem representation of database objects
- help
-
Display usage information
- init
-
Save a DB instance's schemas to the filesystem
- lint
-
Check for problems in filesystem representation of database objects
- pull
-
Update the filesystem representation of schemas
- push
-
Alter objects on DBs to reflect the filesystem representation
- version
-
Display program version
Global Options:
-
-o, --connect-options value -
Comma-separated session options to set upon connecting to each database instance
-
--debug -
Enable debug logging
-
-?, --help[=value] -
Display usage information for the specified command
-
-H, --host-wrapper value -
External bin to shell out to for host lookup; see manual for template vars
-
--ignore-func value -
Ignore functions that match regex
-
--ignore-proc value -
Ignore stored procedures that match regex
-
--ignore-schema value -
Ignore schemas that match regex
-
--ignore-table value -
Ignore tables that match regex
--[skip-]my-cnf-
Parse ~/.my.cnf for configuration (enabled by default; disable with
--skip-my-cnf)
-
-p, --password[=value] -
Password for database user; omit value to prompt from TTY (default "$MYSQL_PWD")
-
--ssl-mode value -
Specify desired connection security SSL/TLS usage (valid values: "disabled", "preferred", "required")
-
-u, --user value -
Username to connect to database host (default "root")
-
--version -
Display program version
Complete documentation for this command suite is available online: https://www.skeema.io/docs/commands
History
- Debian 13 (Trixie): the text shown here
- Debian 12 (Bookworm)
--ignore-func since Debian 13 (Trixie);
--ignore-proc since Debian 13 (Trixie).