sqlx-migration
Create SQLx migration files with `sqlx migrate add <name>`. Use when asked to add, create, or generate a sqlx/sqlx-cli database migration.
Source facts
- Repository
- macro-inc/macro
- Last source activity
- July 11, 2026 at 21:56
- Detected SKILL.md language
- English
- Stars
- 4,553
- Forks
- 442
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- 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
# SQLx Migration
Use the SQLx CLI to create migration files instead of manually creating timestamped files.
## Instructions
1. Identify the project or crate root where SQLx migrations should live.
- Prefer the directory that contains an existing `migrations/` directory.
- If there are multiple crates/projects, ask the user which one unless the target is obvious.
2. Convert the requested migration description to a short snake_case name, for example `create_users_table`.
3. Run `just setup_test_envs` from the project root
4. Run the SQLx CLI from `crates/macro_db_client` folder:
```bash
cargo sqlx migrate add name_of_migration
```
Replace `name_of_migration` with the actual snake_case migration name.
5. Do not manually add timestamps or hand-create migration filenames; `sqlx migrate add` generates the correct timestamped file.
6. After the command succeeds, read the generated migration file and add the requested SQL changes there.
7. 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.
View on GitHub