Generate Rust structs from your database schema — with correct types, derives, and sqlx::FromRow annotations.

Supports PostgreSQL, MySQL, and SQLite. Introspects tables, views, enums, composite types, and domains.

• Multi-database: PostgreSQL, MySQL, SQLite
• Multi-schema support (PostgreSQL)
• Generates #[derive(sqlx::FromRow)] structs
• PostgreSQL enums → #[derive(sqlx::Type)] enums
• PostgreSQL composite types and domains
• MySQL inline ENUM detection
• Correct nullable handling (Option<T>)
• Custom derives (--derives Serialize,Deserialize)
• Type overrides (--type-overrides jsonb=MyType)
• SQL views support (--views)
• Table filtering (--tables users,orders) and exclusion (--exclude-tables _migrations)
• Single-file or multi-file output
• Dry-run mode (preview on stdout)

cargo install sqlx-gen

sqlx-gen -u postgres://user:pass@localhost/mydb -s public,auth -o src/models

sqlx-gen -u mysql://user:pass@localhost/mydb -o src/models

sqlx-gen -u sqlite:./local.db -o src/models

sqlx-gen -u postgres://... --derives Serialize,Deserialize -o src/models

sqlx-gen -u postgres://... --exclude-tables _migrations,schema_versions -o src/models

sqlx-gen -u postgres://... --views -o src/models

sqlx-gen -u postgres://... --dry-run

// Auto-generated by sqlx-gen. Do not edit.
// Table: public.users

use chrono::{DateTime, Utc};
use uuid::Uuid;

#[derive(Debug, Clone, sqlx::FromRow)]
pub struct Users {
    pub id: Uuid,
    pub email: String,
    pub name: Option<String>,
    pub created_at: DateTime<Utc>,
}

Enums:

#[derive(Debug, Clone, PartialEq, sqlx::Type)]
#[sqlx(type_name = "status")]
pub enum Status {
    #[sqlx(rename = "active")]
    Active,

    #[sqlx(rename = "inactive")]
    Inactive,
}

MIT