OpenSkillIndex← back to search
claude-code

AGENTS-COLLECTION database-schema-validator

Validates SQL schema files for compliance with internal safety and naming policies.

install
source · Clone the upstream repo
git clone https://github.com/mk-knight23/AGENTS-COLLECTION
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/mk-knight23/AGENTS-COLLECTION "$T" && mkdir -p ~/.claude/skills && cp -r "$T/AGENTS/ANTIGRAVITY/SKILLS/DATABASE-SCHEMA-VALIDATOR" ~/.claude/skills/mk-knight23-agents-collection-database-schema-validator && rm -rf "$T"
manifest: AGENTS/ANTIGRAVITY/SKILLS/DATABASE-SCHEMA-VALIDATOR/SKILL.md
source content

Database Schema Validator Skill

This skill ensures that all SQL files provided by the user comply with our strict database standards.

Policies Enforced

  1. Safety: No 
    DROP TABLE
    statements.
  2. Naming: All tables must use 
    snake_case
    .
  3. Structure: Every table must have an 
    id
    column as PRIMARY KEY.

Instructions

  1. Do not read the file manually to check for errors. The rules are complex and easily missed by eye.

  2. Run the Validation Script: Use the 

    run_command
    tool to execute the python script provided in the 
    scripts/
    folder against the user's file.

    python scripts/validate_schema.py <path_to_user_file>

  3. Interpret Output:

    • If the script returns exit code 0: Tell the user the schema looks good.
    • If the script returns exit code 1: Report the specific error messages printed by the script to the user and suggest fixes.