Docs: Commands: add-environment

Usage: skeema add-environment [<options>] <environment>

Modifies the .skeema file in an existing host directory to add a new named environment. For example, if skeema init was previously used to create a dir for a host with the default “production” environment, skeema add-environment could be used to define a “staging” or “development” environment pointing at a different host and port, or perhaps a “local” environment pointing at localhost and a socket path.

This command currently only handles very simple cases. For many situations, editing .skeema files directly is a better approach.

Add-Environment Options

OptionDescription
dirBase dir for this host’s schemas
hostDatabase hostname or IP address
portPort to use for database host
socketAbsolute path to Unix socket file used if host is localhost

Global Options

OptionDescription
connect-optionsComma-separated session options to set upon connecting to each database instance
debugEnable debug logging
helpDisplay usage information for the specified command
host-wrapperExternal bin to shell out to for host lookup; see manual for template vars
ignore-funcIgnore functions that match regex
ignore-procIgnore stored procedures that match regex
ignore-schemaIgnore schemas that match regex
ignore-tableIgnore tables or views that match regex
ignore-triggerIgnore triggers that match regex
ignore-viewIgnore views that match regex
my-cnfParse ~/.my.cnf for configuration (enabled by default; disable with skip-my-cnf)
passwordPassword for database user; omit value to prompt from TTY (default no password)
server-public-key-pathFile path to server public key in PEM format; omit to obtain from server
sshTunnel MySQL connections thru SSH to this hostname or user@hostname:port
ssh-to-dbSSH to database host in order to establish database connections locally
ssl-caFile path to certificate authority in PEM format
ssl-certFile path to client-side public key in PEM format
ssl-keyFile path to client-side private key in PEM format
ssl-modeSpecify desired connection security SSL/TLS usage
ssl-verify-server-certVerify server-side cert matches server hostname
userUsername to connect to database host
versionDisplay program version