sqlx

Create database

$ sqlx database create

$ sqlx migrate run

$ sqlx migrate add [migration_name]

$ sqlx migrate revert

$ sqlx prepare

$ sqlx prepare --check

sqlx command [options]

sqlx is a command-line tool for the SQLx Rust SQL toolkit that provides database migration management and compile-time query verification. It supports PostgreSQL, MySQL, MariaDB, and SQLite.
The migration system creates versioned SQL scripts that track schema changes, with commands to create, run, and revert migrations. The prepare command caches query metadata to a JSON file, enabling compile-time type checking of SQL queries in Rust code without requiring a live database connection during builds.
A DATABASE_URL environment variable or .env file must specify the database connection string for all operations.

database

Database operations.

Migration commands.

Prepare for offline.

Connection string.

Add migration.

Run migrations.

DATABASE_URL

Environment variable specifying the database connection string (e.g., postgres://user:pass@host/db, sqlite:data.db).

Project-level file where DATABASE_URL can be defined; automatically loaded by sqlx commands.

Rust development tool. DATABASE_URL required. Compile-time checks.

sqlx is a Rust SQL toolkit providing compile-time checked queries and database migrations.

diesel(1), psql(1), sqlite3(1)