Scroll to navigation

SKEEMA(1) User Commands SKEEMA(1)

NAME

skeema - declarative database schema management system

SYNOPSIS

skeema [<options>] <command>

DESCRIPTION

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 a new named environment to an existing host directory
Compare a DB instance's schemas to the filesystem
Normalize format of filesystem representation of database objects
Display usage information
Save a DB instance's schemas to the filesystem
Check for problems in filesystem representation of database objects
Update the filesystem representation of schemas
Alter objects on DBs to reflect the filesystem representation
Display program version

Global Options:

Comma-separated session options to set upon connecting to each database instance
Enable debug logging
-?, --help[=value]
Display usage information for the specified command
External bin to shell out to for host lookup; see manual for template vars
Ignore schemas that match regex
Ignore tables that match regex
--[skip-]my-cnf
Parse ~/.my.cnf for configuration (enabled by default; disable with --skip-my-cnf)
Password for database user; omit value to prompt from TTY (default no password)
Specify desired connection security SSL/TLS usage (valid values: "disabled", "preferred", "required")
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

September 2022 skeema version 1.8.2-community (snapshot build from source)