Guide Rust database interactions with SQLx, Diesel, and SeaORM.
npx skills add https://github.com/huiali/rust-skills --skill rust-database
Please help me install this Agent Skill. Skill: rust-database Source: https://github.com/huiali/rust-skills/tree/main/.codex/skills/rust-database Command: npx skills add https://github.com/huiali/rust-skills --skill rust-database
This Skill addresses the critical challenge of ensuring data correctness and operational safety when working with databases in Rust, covering design, transactions, migrations, and query performance.
Use the rust-database skill to design a safe database transaction boundary for user registration.
High-intent search queries and answers about installing and using this skill.
To manage safe database transactions in Rust, define short transaction boundaries and implement retry handling. This approach prevents data corruption by ensuring operations either complete entirely or roll back safely during failures.
Best practices for database migrations in Rust involve using additive changes for safe deployments and careful handling of destructive schema changes. This ensures reliable schema evolution without risking existing application data.
To fix N+1 query performance issues with SQLx or Diesel, apply query optimization strategies and proper index usage. Detecting these issues early helps streamline data access and significantly improves application responsiveness.
Yes, SeaORM works well for separating data access layers in Rust web apps. It provides robust abstractions that help define clear transaction boundaries and maintain persistence architecture rules effectively.
Structure Rust database operations by isolating data access layers and implementing rules for short, safe transactions. Handling retries at the transaction boundary ensures operational safety and data correctness during unexpected failures.
stephnangueGenerate temporary IAM-based connection strings for AWS RDS PostgreSQL and MySQL databases.
Andreicr1Validate data migration mappings and rollback safety for PRs.
JStaRFilmsExpose HTTP endpoints for Convex applications using httpRouter.
cathayriskProvide SQLAlchemy patterns for safe database operations in Python.
