pg-migration
pg-migration is a Databases & SQL skill for AI agents, published by johnqtcg in the awesome-skills repository on GitHub. Skillspace rates pg-migration C (72/100) and it passed the safety scan; the rating is based on static analysis only.
PostgreSQL schema migration safety reviewer and DDL generator. ALWAYS use when writing, reviewing, or planning PostgreSQL schema changes — ALTER TABLE, CREATE/DROP INDEX, column type changes, constraint additions, RLS policy changes, or any DDL touching production tables. Covers lock-level analysis, CREATE INDEX CONCURRENTLY, NOT VALID constraint patterns, transactional DDL rollback, pg_repack for table rewrites, phased rollout design, and backward compatibility. Use even for "simple" ADD COLUMN — PostgreSQL DDL lock behavior varies by operation and version, and AccessExclusiveLock on a hot table causes immediate outage.
- Grade
- C
- Quality
- 72 / 100
- Safety
- Passed
- GitHub stars
- 26
Unproven: rated by static analysis only, not yet compared head-to-head.
Not launch-quality. It is graded C with a clean safety verdict, but our quality filters exclude it: it is a near-duplicate variant of another skill. So it is not in our launch-quality set, the skills our MCP server searches and recommends. How launch-quality is decided
This rating describes the version of the repository we crawled; it may have changed since, so go by its current files.
Our review
- Architecture
- 84 / 100
- Maturity
- Structured: ships references or scripts
- Security scan
- No issues found
- License
- MIT
- Adoption
- Adopted by 0 other repositories, in 0 collections
Not checked yet
- Category is a classifier prediction; no model has read this skill yet
- Not judged on the rubric yet (not a contender in its category)
- No blind task eval yet
- Scope (portable / vendor / repo-internal) not assessed; only the top of each category is read for scope
- Sibling files (scripts, references) not fetched; security scan covers SKILL.md only
Skillspace indexes and rates this skill; it does not host or endorse it. Run third-party skills at your own risk.