SQL to Diesel Model Generator

What is SQL to Diesel Model Generator?

Diesel is the most widely adopted ORM for Rust, built around the principle of compile-time query verification. Instead of discovering SQL errors at runtime, Diesel catches them during compilation by leveraging Rust's type system and its own DSL macros. This converter takes your SQL CREATE TABLE statements and produces Rust code including the table! macro schema definitions, model structs with Queryable and Selectable derive macros, optional Insertable implementations, and belongs_to association annotations derived from foreign key constraints. It supports all three Diesel backends: PostgreSQL, MySQL, and SQLite.

How to Use

1. Select your database backend — PostgreSQL, MySQL, or SQLite — since Diesel generates different SQL type annotations per dialect
2. Paste your SQL CREATE TABLE statements into the input panel
3. Toggle "Include table! macro" to generate Diesel schema definitions required for compile-time query checking
4. Toggle "Include Insertable" to add the Insertable derive macro for struct insertion into the database
5. Toggle "Use newtype for primary keys" to wrap primary keys in dedicated types like UserId(i32) to prevent accidental mixing of IDs across tables
6. Click "Generate Diesel Models" and copy the Rust code into your project

Tips & Best Practices

• Always include the table! macro — without it, Diesel cannot verify your queries at compile time and you lose the primary benefit of using Diesel
• Enable the newtype primary key option for any project with multiple tables — the type safety it provides far outweighs the small amount of additional code
• Nullable columns are automatically wrapped in Option<T>, which is idiomatic Rust and integrates seamlessly with Diesel query building
• After generating models, run diesel print-schema in your project to verify the output matches your actual database schema

Frequently Asked Questions

Real-world Examples

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  customer_id INTEGER NOT NULL REFERENCES users(id),
  total NUMERIC(10,2) NOT NULL,
  status VARCHAR(20) DEFAULT 'pending',
  created_at TIMESTAMP DEFAULT NOW()
);

#[derive(Debug, Queryable, Selectable, Insertable)]
#[diesel(table_name = orders)]
#[diesel(check_for_backend(diesel::pg::Pg))]
#[diesel(belongs_to(User, foreign_key = customer_id))]
pub struct Order {
    pub id: i32,
    pub customer_id: i32,
    pub total: bigdecimal::BigDecimal,
    pub status: String,
    pub created_at: chrono::NaiveDateTime,
}

Related Tools