Implement Rust database access patterns with SQLx and Diesel.
npx skills add https://github.com/imehr/vet --skill rust-database-guidelines
Please help me install this Agent Skill. Skill: rust-database-guidelines Source: https://github.com/imehr/vet/tree/main/.claude/skills/rust-database-guidelines Command: npx skills add https://github.com/imehr/vet --skill rust-database-guidelines
The skill provides proven patterns for building reliable database layers in Rust, offering guidance for connecting, querying, and migrating data with SQLx and Diesel.
Use the rust-database-guidelines skill to scaffold a Rust project with SQLx or Diesel, configure a Postgres connection pool, and implement a minimal UserRepository with a find_by_id query.
High-intent search queries and answers about installing and using this skill.
To set up a Rust database connection pool, you configure pool parameters in your Rust service and use SQLx or Diesel to manage connections to PostgreSQL, enabling safe and fast concurrent data access.
The repository pattern in Rust is implemented by creating structs that encapsulate database queries, using SQLx or Diesel to handle model definitions and complex queries while keeping data access logic separate from business logic.
Yes, SQLx supports compile-time checked queries in Rust web services, verifying SQL syntax against your PostgreSQL schema at build time to prevent runtime database errors before deployment.
Database migrations in a Rust project are handled by applying versioned migration scripts through SQLx or Diesel, ensuring your PostgreSQL schema changes are tracked, maintainable, and applied consistently.
Database transactions in Rust are managed by wrapping multiple repository operations in a transaction block using SQLx or Diesel, ensuring atomic execution so that complex queries either fully succeed or roll back.
SQLx provides async data access with compile-time checks, making it ideal for async Rust services, while Diesel offers a mature sync ORM approach; choose based on whether your PostgreSQL service requires async or sync execution.
ahtavarasmusGenerate, apply, and rollback Diesel migrations for SQLite or PostgreSQL schemas.
ThrookieConfigure Kotlin Exposed ORM with HikariCP, Flyway, and coroutine-safe transactions.
Snowflake-LabsA concise summary of your roleplay character: name,</name> personality, and/or behavior, formatted as a single string sentence. Typically不超过50字，此处省略
nikomatsakisBuilds custom Rust compiler frontends consuming crate dependency metadata via rustc_driver callbacks.
