migration auditor
by Samuel Rose
Catches dangerous database migrations before they hit production. Reviews schema changes for locking hazards, data loss, missing rollbacks, and index issues across PostgreSQL, MySQL, and SQLite.
New: Skill bounties are live. Post a request, fund the bounty, and creators compete for 7 days to build it -> See open bounties
THE AGENSI STORE
10 skills found
by Samuel Rose
Catches dangerous database migrations before they hit production. Reviews schema changes for locking hazards, data loss, missing rollbacks, and index issues across PostgreSQL, MySQL, and SQLite.
by Kevin Cline
Turn plain English app descriptions into fully normalized SQL schemas and entity relationship documentation.
by Roy Yuen
A safe, expert-level database troubleshooter for fixing migrations, performance issues, and schema drift.
Plan, review, and execute safe database migrations with automatic rollback plans, backfill strategies, and zero-downtime sequencing.
Catch the dangerous migration before it locks or wrecks your production database. Scans SQL migration files for destructive and risky operations: DROP and TRUNCATE, drops without IF EXISTS, lossy column-type changes, NOT NULL added without a default, DELETE or UPDATE with no WHERE, non-concurrent index builds, dropped constraints, renames, and data backfills mixed into schema changes. Each finding is ranked by severity with a safer rewrite. Postgres, MySQL, and SQLite.
Schema mistakes are the most expensive kind — code refactors in days, but a wrong table design holds your data hostage for years
Review a database schema, queries, or migration for the mistakes that get expensive in production — bad table design, missing or wrong indexes, slow and N+1 queries, SQL injection, and migrations that lock or break prod. Engine-aware (PostgreSQL, MySQL, SQLite, SQL Server), it runs an ordered review and returns a PASS/REVIEW/BLOCK verdict with prioritized fixes. Schema mistakes are the most expensive kind — this catches them before they ship.
A retrieval architect that diagnoses why RAG returns confident-but-wrong answers, picks the right context architecture (RAG vs knowledge graph vs structured/temporal retrieval) instead of defaulting to vector search, and designs the institutional-memory schema embeddings throw away.
by Timoranjes
Teaches AI coding agents to design safe Prisma schemas that prevent data loss, race conditions, N+1 queries, and the dangerous Prisma migration reset. Covers 12 critical anti-patterns (missing indexes
by YK
Eliminate technical debt by enforcing a single source of truth for schemas, types, and constants across the stack.