SKEEMA

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-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-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 no password)

--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