Implement PostgreSQL data access with sqlx compile-time checks and offline builds.
npx skills add https://github.com/ohaddahan/claude-extras --skill rust-sqlx
Please help me install this Agent Skill. Skill: rust-sqlx Source: https://github.com/ohaddahan/claude-extras/tree/main/skills/rust-sqlx-skill Command: npx skills add https://github.com/ohaddahan/claude-extras --skill rust-sqlx
Rust developers building PostgreSQL-backed applications often struggle with safe, maintainable data access patterns, migrations, and reliable builds in CI. This Skill provides a structured approach for using sqlx to combine compile-time checks, runtime queries, and offline preparation.
Install Rust toolchain, configure DATABASE_URL to a PostgreSQL database, run cargo check, then cargo sqlx prepare to cache queries for offline builds.
High-intent search queries and answers about installing and using this skill.
Sqlx compile-time queries use the query! and query_as! macros to validate SQL against your PostgreSQL schema at build time, catching database errors early. This ensures strong type safety before your Rust application ever runs.
Sqlx migrations are managed using the sqlx-cli tool to apply reversible database schema changes. This provides a clear, repeatable workflow for creating and running migration scripts directly against your PostgreSQL database.
Offline sqlx builds use the cargo sqlx prepare command to precompute and cache query metadata. This allows your Rust CI pipelines to compile database code without needing a live PostgreSQL connection.
Runtime sqlx queries are necessary when dealing with dynamic schemas or SQL strings generated at execution time. They use the FromRow trait to map results directly into Rust structs without compile-time schema validation.
A PostgreSQL database is required during initial development to validate compile-time queries and generate offline metadata. Once prepared with cargo sqlx prepare, subsequent builds and CI runs can operate entirely offline.
forrestthewoodsValidate Rust code types with cargo check instead of cargo build.
adelabdelgawadAutomate SQLx offline cache management and per-crate sqlx.toml configuration for Rust projects.
adelabdelgawadManage SQLx database migrations with compile-time embedding or sqlx-cli workflows.
patrickhaahrVerify SQL queries at compile time in Rust applications using sqlx.
