The Complete Production SOP: How to Deploy and Run Diesel Compile-Time Safe Object-Relational Mapping for Rust in Autonomous AI Agents

---
name: "diesel-safe-extensible-orm-rust"
description: "Write complex SQL database queries with compile-time verification and zero runtime overhead in Rust."
metadata:
  author: "Diesel"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "query database diesel rust"
  - "diesel compile time checked queries"
  - "diesel migration run"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

[dependencies]
diesel = { version = "2.2", features = ["postgres", "r2d2", "chrono", "uuid"] }
diesel_migrations = "2.2"
dotenvy = "0.15"
r2d2 = "0.8"

use diesel::prelude::*;
use chrono::NaiveDateTime;

#[derive(Queryable, Selectable, Debug)]
#[diesel(table_name = crate::schema::users)]
#[diesel(check_for_backend(diesel::pg::Pg))]
pub struct User {
    pub id: i32,
    pub username: String,
    pub email: String,
    pub active: bool,
    pub created_at: NaiveDateTime,
}

#[derive(Insertable)]
#[diesel(table_name = crate::schema::users)]
pub struct NewUser<'a> {
    pub username: &'a str,
    pub email: &'a str,
    pub active: bool,
}

use diesel::prelude::*;
use crate::schema::users::dsl::*;
use crate::models::{User, NewUser};

pub fn find_active_users(conn: &mut PgConnection, page_limit: i64) -> QueryResult<Vec<User>> {
    users
        .filter(active.eq(true))
        .order(created_at.desc())
        .limit(page_limit)
        .select(User::as_select())
        .load::<User>(conn)
}

pub fn create_user<'a>(conn: &mut PgConnection, new_user: NewUser<'a>) -> QueryResult<User> {
    diesel::insert_into(users)
        .values(&new_user)
        .returning(User::as_returning())
        .get_result(conn)
}