Menu
Dump clean Postgres schema to a file and copy path to clipboard.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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.
Create SQLx migration files with `sqlx migrate add <name>`. Use when asked to add, create, or generate a sqlx/sqlx-cli database migration.
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).
| name | dump-schema |
| description | Dump clean Postgres schema to a file and copy path to clipboard. |
| allowed-tools | Bash |
Dump a clean PostgreSQL schema (no comments, no ownership, no privileges) from the local dev database.
Ask the user (if not provided):
.sql file (default: prompt user)Use this database URL unless the user specifies otherwise:
postgres://user:password@localhost:5432/macrodb
pg_dump with schema-only flags, pipe through cleanup, write to file:pg_dump --schema-only --no-owner --no-privileges --no-comments --no-publications --no-subscriptions --no-security-labels --no-tablespaces "$DB_URL" | sed '/^--/d' | sed '/^SET /d' | sed '/^SELECT pg_catalog/d' | sed '/^$/N;/^\n$/d' > "$OUTPUT_FILE"
echo -n "$OUTPUT_FILE" | pbcopy
Schema dumped to <path> (path copied to clipboard)