SKEEMA(1)

πŸ“¦
version 1.12.3 Β· 3 versions
, in debian trixie, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

πŸ’– SKEEMA(1) πŸ’–

the Unix manual page for skeema β€” User Commands ✨


✨ NAME ✨

skeema β€” declarative database schema management system 🫢


🌸 SYNOPSIS 🌸

skeema [<options>] <command>

πŸ¦‹ DESCRIPTION πŸ¦‹

okay bestie, so Skeema is a declarative schema management system for MySQL and MariaDB πŸ‘‘ and it is literally the moment.

Here's the vibe: it lets you export a database schema to the filesystem, and then apply online schema changes by modifying CREATE statements in .sql files. yes fr fr, you just edit the files and skeema handles the rest. main character energy πŸ’…


πŸŽ€ Commands:

  • add-environment β€” add a brand new named environment to an existing host directory πŸ“
  • diff β€” compare a DB instance's schemas to the filesystem πŸ‘€
  • format β€” normalize the format of the filesystem representation of database objects ✨
  • help β€” display usage information πŸ™‹
  • init β€” save a DB instance's schemas to the filesystem πŸ’Ύ
  • lint β€” check for problems in the 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, bestie β€” https://www.skeema.io/docs/commands 🌈

and that's a wrap! this page is from skeema version 1.11.1-communi..., dated December 2023, and it lives in section SKEEMA(1) of the manual πŸ’– go forth and schema, queen πŸ‘‘βœ¨