database-schema-validator

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

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

rominirani 259 56 Updated 4mo ago

Resources

npx skillscat add rominirani/antigravity-skills/database-schema-validator

Install via the SkillsCat registry.

SKILL.md

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

Do not read the file manually to check for errors. The rules are complex and easily missed by eye.
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>
```
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.