Docs: Commands: pull

Usage: skeema pull [<options>] [<environment>]

Updates the existing filesystem representation of the schemas on a DB instance. Use this command when changes have been applied to the database manually or outside of Skeema, in order to make the filesystem representation reflect those changes.

You may optionally pass an environment name as a CLI arg. This will affect which section of .skeema config files is used for processing. For example, running skeema pull staging will apply config directives from the [staging] section of config files, as well as any sectionless directives at the top of the file. If no environment name is supplied, the default is “production”.

Pull Options

OptionDescription
formatReformat SQL statements to match canonical SHOW CREATE (enabled by default; disable with skip-format)
include-auto-incInclude starting auto-inc values in new table files, and update in existing files
new-schemasDetect any new schemas and populate new dirs for them (enabled by default; disable with skip-new-schemas)
update-partitioningUpdate PARTITION BY clauses in existing table files
update-viewsUpdate definitions of existing views, using canonical form

Workspace Options

OptionDescription
docker-cleanupWith workspace=docker, specifies how to clean up containers
temp-schemaName of temporary schema for intermediate operations, created and dropped each run
temp-schema-binlogControls whether temp schema DDL operations are replicated
temp-schema-threadsMax number of concurrent CREATE/DROP with workspace=temp-schema
workspaceSpecifies where to run intermediate operations

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-schemaIgnore schemas that match regex
ignore-tableIgnore tables that match regex
ignore-triggerIgnore triggers 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)
userUsername to connect to database host
versionDisplay program version