snippetbashTip

sqlx — Utility for SQLx, the Rust SQL toolkit. More information: <https://github.com/launchbadge/sqlx/blob/

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

thecommandrustclisqlxforutility

Problem

How to use the sqlx command: Utility for SQLx, the Rust SQL toolkit. More information: <https://github.com/launchbadge/sqlx/blob/main/sqlx-cli/README.md>.

Solution

sqlx — Utility for SQLx, the Rust SQL toolkit. More information: <https://github.com/launchbadge/sqlx/blob/main/sqlx-cli/README.md>.

Create the database specified in the $DATABASE_URL environment variable:

sqlx database create

Drop the specified database:

sqlx database drop {{[-D|--database-url]}} {{database_url}}

Create a new pair of up and down migration files with the given description in the "migrations" directory:

sqlx migrate add -r {{migration_description}}

Run all pending migrations for the specified database:

sqlx migrate run {{[-D|--database-url]}} {{database_url}}

Revert the latest migration for the specified database:

sqlx migrate revert {{[-D|--database-url]}} {{database_url}}

Code Snippets

Create the database specified in the `$DATABASE_URL` environment variable

sqlx database create

Drop the specified database

sqlx database drop {{[-D|--database-url]}} {{database_url}}

Create a new pair of up and down migration files with the given description in the "migrations" directory

sqlx migrate add -r {{migration_description}}

Run all pending migrations for the specified database

sqlx migrate run {{[-D|--database-url]}} {{database_url}}

Revert the latest migration for the specified database

sqlx migrate revert {{[-D|--database-url]}} {{database_url}}

Context

tldr-pages: common/sqlx

Revisions (0)

No revisions yet.