diesel

Setup database (create if not exists)

$ diesel setup

$ diesel migration generate [migration_name]

$ diesel migration run

$ diesel migration revert

$ diesel print-schema

$ diesel print-schema > src/schema.rs

$ diesel migration list

diesel command [options]

Diesel CLI is the command-line tool for the Diesel ORM, a safe, extensible ORM and query builder for Rust. It manages database migrations and generates Rust code representing the database schema.
Migrations are SQL files in a migrations directory, with "up" and "down" files for applying and reverting changes. The CLI tracks applied migrations in a database table.
The print-schema command introspects the database and generates Rust code (schema.rs) that Diesel uses for compile-time query validation. This ensures queries are type-checked against the actual database structure.

setup

Create database and run migrations.

Create new migration files.

Run all pending migrations.

Revert the latest migration.

Revert and re-run latest migration.

List all migrations and their status.

Output database schema as Rust code.

Create the database.

Drop and recreate database.

Database connection URL.

Path to diesel.toml.

Directory containing migrations.

diesel.toml:

$ [print_schema]
file = "src/schema.rs"
with_docs = true

[migrations_directory]
dir = "migrations"

Requires database driver libraries (libpq for PostgreSQL, libmysqlclient for MySQL). The DATABASE_URL environment variable or --database-url must be set. Schema generation requires an accessible database. Migration SQL varies by database backend.

Diesel was created by Sean Griffin (also a Ruby on Rails contributor) and first released in 2015. It was designed to leverage Rust's type system for database safety. The CLI tool provides migration management similar to ActiveRecord or Knex. Diesel has become one of the most popular Rust database libraries.

sqlx(1), sea-orm(1), cargo(1)