Database schema validation tools - SQL syntax checking, constraint validation, naming convention enforcement, and schema integrity verification. Use when validating database schemas, checking migrations, enforcing naming conventions, verifying constraints, or when user mentions schema validation, migration checks, database best practices, or PostgreSQL validation.
Limited to specific tools
Additional assets for this skill
This skill is limited to using the following tools:
QUICKSTART.mdREADME.mdexamples/ci-integration.mdexamples/common-issues.mdexamples/test-schema.sqlexamples/validation-workflow.mdscripts/full-validation.shscripts/validate-constraints.shscripts/validate-indexes.shscripts/validate-naming.shscripts/validate-rls.shscripts/validate-sql-syntax.shtemplates/naming-conventions.jsontemplates/sql-best-practices.mdtemplates/validation-report-template.mdtemplates/validation-rules.jsonComprehensive database schema validation for Supabase/PostgreSQL projects. Validates SQL syntax, naming conventions, constraints, indexes, and RLS policies before deployment.
cd /path/to/project
bash /home/vanman2025/Projects/ai-dev-marketplace/plugins/supabase/skills/schema-validation/scripts/full-validation.sh <schema-file-or-directory>
SQL Syntax Validation:
bash scripts/validate-sql-syntax.sh <sql-file>
Naming Convention Validation:
bash scripts/validate-naming.sh <sql-file>
Constraint Validation:
bash scripts/validate-constraints.sh <sql-file>
Index Validation:
bash scripts/validate-indexes.sh <sql-file>
RLS Policy Validation:
bash scripts/validate-rls.sh <sql-file>
The full validation script generates a detailed markdown report showing:
Customize validation rules by editing:
templates/validation-rules.json
templates/naming-conventions.json
# Validate a new migration file
bash scripts/full-validation.sh supabase/migrations/20250126_add_users_table.sql
# Review the generated report
cat validation-report.md
# Validate all migration files
bash scripts/full-validation.sh supabase/migrations/
# Check for common issues
grep "ERROR" validation-report.md
# Add to .github/workflows/validate-schema.yml
- name: Validate Database Schema
run: |
bash plugins/supabase/skills/schema-validation/scripts/full-validation.sh supabase/migrations/
if grep -q "ERROR" validation-report.md; then
exit 1
fi
Plugin: supabase Version: 1.0.0 Last Updated: 2025-01-26