Dump Schema
SkillDatabases & dataLets your agent export a clean Postgres database schema to a file and copy the file path to your clipboard.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the Dump Schema skill
About this capability
Dump clean Postgres schema to a file and copy path to clipboard.
What this skill tells your AI
The instructions your AI receives, as published by macro-inc/macro in .agents/skills/dump-schema/SKILL.md and read by ahel’s review.
Dump a clean PostgreSQL schema (no comments, no ownership, no privileges) from the local dev database.
Parameters
Ask the user (if not provided):
- output_file – absolute path for the
.sqlfile (default: prompt user)
Use this database URL unless the user specifies otherwise:
postgres://user:password@localhost:5432/macrodb
Steps
- Run
pg_dumpwith 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"
- Copy the output path to the clipboard:
echo -n "$OUTPUT_FILE" | pbcopy
- Report:
Schema dumped to <path> (path copied to clipboard)
Signals
- GitHub stars
- 4k
- Forks
- 410
- Last commit
- Sep 2026
Advanced
- Catalog kind
- skill
- Gateway key
dump-schema- Source
- github.com/macro-inc/macro