Skip to content
Data Maestro Download
Commands

Database

Push generated rows straight into a live database, or discover what tables exist first.

push-db

Generates rows straight into one or more live databases — no intermediate file. Tests connectivity before generating (skipped for targets requesting --create-database, since that target doesn't exist yet).

data-maestro-cli push-db --db-type <type> --host <host> --port <port> \
  --database <db> --table <table> [--user <user>] \
  [--password <pw>|--password-env <VAR>] [--create-database] [--create-table] \
  <schema_json_path> <rows> [<locale>]

# or fan the same generated rows out to several targets at once
data-maestro-cli push-db --db-config targets.json <schema_json_path> <rows> [<locale>]
rows capped at 100 on the Free tier — see Free tier & licensing --create-database / --create-table only where the connector supports it — see Reference --db-config <file> a JSON object or array of targets, instead of flags
list-db-tables

Lists the tables/collections in a live database — useful standalone for scripting or a pre-flight check before push-db/anonymize-db. Ungated.

data-maestro-cli list-db-tables --db-type <type> --host <host> \
  [--port <port>] [--database <db>] [--user <user>] \
  [--password <pw>|--password-env <VAR>]

push-db / list-db-tables examples

Generate rows straight into a local SQLite file, creating the DB and table if needed

data-maestro-cli push-db --db-type sqlite --host mydb.sqlite \
  --table users --create-database --create-table \
  schema.json 500

Push into Postgres, password from the environment

data-maestro-cli push-db --db-type postgres --host localhost --port 5432 \
  --database mydb --user admin --password-env DB_PASSWORD \
  --table users schema.json 1000

Fan the same generated rows out to several targets in one invocation

# targets.json: a JSON array of {db_type, host, port, database, table_or_collection, ...}
data-maestro-cli push-db --db-config targets.json schema.json 500

Check what tables exist before pushing or anonymizing

data-maestro-cli list-db-tables --db-type postgres --host localhost \
  --port 5432 --database mydb --user admin --password-env DB_PASSWORD