Database

These commands help you manage your Zeplo database layer. Push schema changes, generate migration files, seed data, and open a visual database explorer directly from the terminal.

zeplo db push

Push your local schema changes directly to the database. This command compares your current schema definitions against the live database and applies the necessary changes. It skips generating migration files, making it ideal for rapid prototyping.

zeplo db push

Options

Flag	Description
`--force`	Skip the confirmation prompt and apply changes immediately.
`--dry-run`	Show the SQL that would be executed without actually running it.

Examples

# Push schema changes with a confirmation prompt
zeplo db push

# Push and skip the confirmation prompt
zeplo db push --force

# Preview the SQL that would run
zeplo db push --dry-run

zeplo db generate

Generate migration files from your current schema definitions. This command inspects your schema, computes the diff against the last generated migration, and writes new SQL migration files to your migrations directory.

zeplo db generate

Options

Flag	Description
`--name <name>`	Set a custom name for the migration file. Defaults to an auto-generated descriptive name.
`--empty`	Generate an empty migration file. Useful for writing custom SQL migrations by hand.

Examples

# Generate a migration from schema changes
zeplo db generate

# Generate with a custom name
zeplo db generate --name add-user-avatar-column

# Generate an empty migration for custom SQL
zeplo db generate --empty

zeplo db seed

Run your seed scripts to populate the database with initial or sample data. This command executes the seed file defined in your project configuration.

zeplo db seed

Options

Flag	Description
`--file <path>`	Specify a custom seed file instead of the default configured in your project.
`--env <environment>`	Run the seed script against a specific environment (e.g., `development`, `staging`, `production`).

Examples

# Run the default seed script
zeplo db seed

# Run a specific seed file
zeplo db seed --file ./seeds/demo-data.sql

# Seed a staging environment
zeplo db seed --env staging

zeplo db studio

Open Drizzle Studio, a browser-based GUI for exploring and editing your database. This launches a local development server and opens your default browser to the Studio interface.

zeplo db studio

Options

Flag	Description
`--port <port>`	Specify the port for the local Studio server. Defaults to `4983`.
`--no-open`	Start Studio without automatically opening the browser.

Examples

# Open Drizzle Studio with default settings
zeplo db studio

# Start Studio on a custom port
zeplo db studio --port 8080

# Start Studio without opening the browser
zeplo db studio --no-open

Getting Started

Commands

zeplo db push

Options

Examples

zeplo db generate

Options

Examples

zeplo db seed

Options

Examples

zeplo db studio

Options

Examples

​zeplo db push

​Options

​Examples

​zeplo db generate

​Options

​Examples

​zeplo db seed

​Options

​Examples

​zeplo db studio

​Options

​Examples

zeplo db push

Options

Examples

zeplo db generate

Options

Examples

zeplo db seed

Options

Examples

zeplo db studio

Options

Examples