---
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
---

# Diesel Compile-Time Safe Object-Relational Mapping for Rust

Configures Diesel ORM: schema generation (diesel print-schema), compile-time query checking, Queryable and Insertable structs, handling migrations with diesel_migrations, and connection pooling with r2d2.

## When to Invoke
Invoke this skill whenever you need to:
- query database diesel rust
- diesel compile time checked queries
- diesel migration run

## Execution SOP & Rules
1. Generate schema: diesel setup && diesel migration generate create_users.
2. Define models: #[derive(Queryable, Selectable, Insertable)] #[diesel(table_name = crate::schema::users)].
3. Query database: users::table.filter(users::active.eq(true)).limit(10).load::<User>(&mut conn)?.
4. Catch SQL column name typos and type mismatches instantly during cargo check.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.