skills.rest
adelabdelgawad
adelabdelgawadCOMMUNITY
Explore all skills by this author →
𝕏@Adel_AbdElgawaDGitHub

sqlx-offline

Automate SQLx offline cache management and per-crate sqlx.toml configuration for Rust projects.

Updated May 26, 2026
Search Tags:#migrations#offline#cache#rust#cargo#sqlx#ci
One-click install
npx skills add https://github.com/adelabdelgawad/rust-fullstack-agents --skill sqlx-offline
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlx-offline
Source: https://github.com/adelabdelgawad/rust-fullstack-agents/tree/main/plugins/rusty/skills/sqlx-offline
Command: npx skills add https://github.com/adelabdelgawad/rust-fullstack-agents --skill sqlx-offline

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQLx offline cache management for Rust projects, enabling reproducible builds without a live database.

Core Features & Use Cases

  • Pattern-driven cache generation for sqlx 0.9 across a workspace or single crate.
  • Per-crate configuration via sqlx.toml to customize database URLs and migrations.
  • Docker offline builds using SQLX_OFFLINE to ensure deterministic compilation.
  • CI staleness checks to guard against outdated caches and migrated schemas.

Quick Start

Run cargo sqlx prepare --workspace to generate and refresh the offline cache.

Frequently Asked Questions about sqlx-offline

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I enable SQLx offline cache management for Rust CI pipelines?▼

SQLx offline cache management automates generating per-crate offline caches using cargo sqlx prepare --workspace, ensuring reproducible Rust CI builds without a live database connection.

What is the best way to configure SQLx offline builds in Docker for Rust?▼

Configuring SQLx offline builds in Docker involves setting the SQLX_OFFLINE environment variable to ensure deterministic compilation. This Skill automates Docker offline build support with validation checks for Rust projects.

Does sqlx-offline support per-crate database URL configuration?▼

Yes, sqlx-offline supports per-crate configuration via sqlx.toml files, allowing you to customize database URLs and migrations for individual crates within a Rust workspace.

How do I prevent outdated SQLx caches from breaking CI?▼

To prevent outdated SQLx caches from breaking CI, this Skill implements CI staleness checks that guard against outdated caches and migrated schemas during the build process.

Can I generate SQLx 0.9 offline caches across an entire Rust workspace?▼

Yes, you can generate SQLx 0.9 offline caches across an entire Rust workspace using pattern-driven cache generation with the cargo sqlx prepare --workspace command.

Related Skills

Explore More Software Engineering Skills→
icorbreyicorbrey
4

rust

Optimize Rust Cargo workspace setup to prevent excessive build cache growth and improper feature activation.

Community
Intermediate
d-o-hubd-o-hub
11

build-compile

Build Rust projects with Cargo commands for development and release profiles.

Community
Intermediate
GenuinehGenuineh

project-rust

Manage Rust projects with Cargo, workspaces, and cross-compilation.

Community
Intermediate
ngxtmngxtm

SQLx Database

Execute compile-time checked asynchronous SQL queries in Rust with sqlx.

Community
Intermediate