Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

Schema Diff · archive228 | DecimalAI

databy archive228

Schema Diff

archive228/schema-diff

Source archive228/loopkit ↗License MIT

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

SkillScore91Maintained

Automatic

Data Engineer pack

Last verified 8/16/2026

What it changes

Passed 20 of 22 test cases with the skill, and 16 of 22 without it.

Without skill73%

With skill91%

Checks it passed that the model alone missed

Categorizes column removal as Destructive.
Categorizes type narrowing on email as Destructive.
Categorizes setting phone to NOT NULL as Destructive.

and 3 more in the full report

5 fixed15 passed either way1 still failing1 broke

Pass-rate lift: +18 pp
Tokens: -9%
Agent turns: 0%
Response time: -18%

Model gemini-3.6-flashMeasured 8/16/2026v120 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/archive228-schema-diff/SKILL.md https://app.decimal.ai/s/archive228-schema-diff/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add archive228-schema-diff, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/archive228-schema-diff/ and pins it in .decimal/skills.lock

decimalai skills add archive228-schema-diff

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/archive228-schema-diff/SKILL.md https://app.decimal.ai/s/archive228-schema-diff/SKILL.md

Raw file: /s/archive228-schema-diff/SKILL.md ↗ · machine-readable summary at /s/archive228-schema-diff.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 5 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 5

Prompt

Our proposed migration includes `CREATE INDEX CONCURRENTLY idx_orders_created ON orders(created_at);`. What is the risk classification for this operation?

What was checked, without and with the skill
Checked	Without skill	With skill
Categorizes index creation using CONCURRENTLY as Safe.	Missed	Passed

case-13 · gemini-3.6-flash · 8/16/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md6 linessingle file

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.

Track record

Benchmark

20 / 22

test cases passed, vs 16 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

archive228 / loopkit

skills/schema-diff/SKILL.md

View on GitHub ↗

License MITImported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Schema Diff

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills