skills.rest
trevorc-ai
trevorc-aiCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-validator

Validate SQL migration scripts against banned commands, naming conventions, live schema, idempotency, and RLS completeness.

Updated Aug 27, 2026
Search Tags:#migrations#rls#validation#sql#idempotency
One-click install
npx skills add https://github.com/trevorc-ai/PPN-Antigravity-1.0 --skill database-schema-validator-trevorc-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-validator
Source: https://github.com/trevorc-ai/PPN-Antigravity-1.0/tree/main/.agent/skills/database-schema-validator
Command: npx skills add https://github.com/trevorc-ai/PPN-Antigravity-1.0 --skill database-schema-validator-trevorc-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Validates SQL migration files to prevent dangerous commands, enforce naming conventions, verify alignment with the live schema, ensure idempotency, and confirm Row-Level Security (RLS) completeness before execution.

Core Features & Use Cases

  • Enforces safety rules to block banned statements like DROP, DELETE, TRUNCATE, and risky ALTERs in migration scripts.
  • Verifies live-schema alignment and idempotency to ensure migrations can be safely re-run and deployed.
  • Checks RLS policies and governance requirements for auditable deployment pipelines.
  • Use Case: Before deploying a migration, run this skill to catch unsafe SQL and confirm policy compliance.

Quick Start

Run the mandatory live schema verification step to generate and paste the live table list before writing any migration.

Frequently Asked Questions about database-schema-validator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate SQL migrations to block dangerous commands before deployment?▼

SQL migration validation analyzes scripts to block banned statements like DROP, DELETE, TRUNCATE, and risky ALTERs before execution. This enforces safety rules to ensure only compliant migrations are deployed to the live schema.

What is idempotency in SQL migrations and how is it verified?▼

Idempotency verification checks that SQL migrations can be safely re-run without errors. It analyzes migration scripts alongside live schema alignment to ensure repeated deployments produce consistent results and maintain database integrity.

How do I check Row-Level Security policies in my database migrations?▼

Checking Row-Level Security (RLS) completeness analyzes migration scripts to confirm RLS policies and governance requirements are properly defined. This validates that auditable deployment pipelines meet security compliance before handoff.

Can I verify live schema alignment before writing SQL migration scripts?▼

Live schema alignment is verified by generating and pasting the live table list before writing any migration. This mandatory step references the current database schema to ensure new scripts align safely with existing structures.

What are the limitations of automated SQL migration validation tools?▼

Automated SQL migration validation requires a mandatory live schema verification step to function correctly. Without generating and pasting the live table list beforehand, the validation cannot accurately verify alignment or ensure safe deployment.

Related Skills

Explore More Software Engineering Skills→
semicolon-devteamsemicolon-devteam

supabase

Create and validate Supabase database schemas, RLS policies, and migrations.

Official
Advanced
DanielPodolskyDanielPodolsky
274

database-fundamentals

Analyze database schema design, SQL queries, and ORM usage for correctness.

Community
Basic
limzivectorlimzivector

ship

Automate software releases with code review, tests, CHANGELOG updates, and PR creation.

Community
Advanced
gaebalaigaebalai
2

db-migration-review

Analyze database migration files for high-risk patterns and rollback safety.

Community
Advanced