Agent-Skills.md

Agent Skills: Database Schema Validator Skill

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

UncategorizedID: rominirani/antigravity-skills/database-schema-validator

Repository

rominirani/antigravity-skills
rominirani
23853

Install this agent skill to your local

pnpm dlx add-skill https://github.com/rominirani/antigravity-skills/tree/HEAD/skills_tutorial/database-schema-validator

Skill Files

Browse the full folder contents for database-schema-validator.

Download Skill

Loading file tree…

skills_tutorial/database-schema-validator/SKILL.md

Skill Metadata

Name
database-schema-validator
Description
Validates SQL schema files for compliance with internal safety and naming policies.

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.