OpenParable
Skip to content
← Back to skills

Schema Diff

Development
schema-diff

Schema Diff is an Agent Skill for development published in the Archive228/loopkit repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Compare two schema states and surface the risky changes. Use before applying migrations or after a model change.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/Archive228/loopkit/blob/HEAD/skills/schema-diff/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/schema-diff, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Schema Diff

Diff old vs new schema. Flag by risk:

  • Destructive (high): dropped column/table, narrowed type, new NOT NULL on existing rows, dropped index a query relies on.
  • Locking (high at scale): index without CONCURRENTLY, type change that rewrites the table.
  • Safe: new nullable column, new table, new index CONCURRENTLY. For each destructive change: is data lost? is it reversible? is there a backfill? Output a risk-ranked list and a go/no-go with the safe rollout order.