rc-sqlx

Create one PgPool with PgPoolOptions, clone it into application state, and run queries with sqlx::query or query_as using $1, $2 bind placeholders. Map rows into structs deriving FromRow, and use pool.begin() for multi-step transactions.

Pass every dynamic value through .bind() or macro arguments, never with format! or string concatenation. For dynamic identifiers like sort columns, use a Rust allowlist that maps input to fixed column names.

Yes, the query! and query_as! macros validate SQL against a live database at compile time when DATABASE_URL is set. For CI without a database, run cargo sqlx prepare and build with SQLX_OFFLINE=true using the .sqlx data.

Prefer running sqlx migrate run in the deploy pipeline before switching traffic, or use the embedded sqlx::migrate! macro with a single migrator instance. Keep migrations forward-only and never hand-edit already applied files.

Use the #[sqlx::test] attribute or a Docker Postgres container with migrations applied, testing against a real database rather than mocking the pool. Assert on row content, constraint violations, and transaction rollback behavior.

SQLx is not a full ORM, so if you need automatic relationship loading, schema generation from models, or a query builder DSL, a different tool fits better. This Skill also does not cover Axum routing or general SQL schema design, which belong to rc-axum and rc-sql.