// Create SQLx migration files with `sqlx migrate add <name>`. Use when asked to add, create, or generate a sqlx/sqlx-cli database migration.
| name | sqlx-migration |
| description | Create SQLx migration files with `sqlx migrate add <name>`. Use when asked to add, create, or generate a sqlx/sqlx-cli database migration. |
| allowed-tools | Bash, Read, Edit, Glob, Grep |
Use the SQLx CLI to create migration files instead of manually creating timestamped files.
Identify the project or crate root where SQLx migrations should live.
migrations/ directory.Convert the requested migration description to a short snake_case name, for example create_users_table.
Run just rust/cloud-storage/setup_test_envs from the project root
Run the SQLx CLI from rust/cloud-storage/macro_db_client folder:
cargo sqlx migrate add name_of_migration
Replace name_of_migration with the actual snake_case migration name.
Do not manually add timestamps or hand-create migration filenames; sqlx migrate add generates the correct timestamped file.
After the command succeeds, read the generated migration file and add the requested SQL changes there.
If sqlx is not installed or not on PATH, stop and tell the user to install sqlx-cli rather than manually creating the migration file.
Validate Rust work after substantial Rust code changes by running `just check`, `just clippy`, then `just format`. Use before the final response after a significant Rust implementation or cleanup task; batch edits first instead of running after every small change.
Inspect Rust changes for SQLx queries. Use after modifying Rust code that adds or changes SQLx queries to ensure compile-time SQLx macros are used, run `just prepare_db` for offline query cache, and review queries for performance and security issues.
Upgrade an AI chat model (fast or good) across backend and frontend.
Build a new AI tool end-to-end — Rust implementation, toolset wiring, infra, schema generation, and frontend UI.
Find all open Dependabot alerts for this repo and create a plan to resolve them using the appropriate package manager overrides (pnpm, bun, npm, cargo).
Dump clean Postgres schema to a file and copy path to clipboard.