Does this skill support other databases besides PostgreSQL?

This skill is specifically optimized for PostgreSQL and Supabase environments, focusing on their specific syntax, data types, and RLS features.

How does this skill help with Supabase security?

It specifically checks if RLS is enabled on public tables and validates that appropriate policies exist for CRUD operations across different roles.

What is the benefit of the index validation check?

It ensures that foreign keys and columns used in RLS policies are properly indexed, preventing performance degradation as your database grows.

Can I use this in my GitHub Actions?

Yes, the skill is designed with CI/CD in mind; the shell scripts return status codes and generate reports that can be easily integrated into automated workflows.

Can I customize the validation rules?

Yes, you can customize naming conventions and specific validation rules by editing the validation-rules.json and naming-conventions.json templates.

Supabase Schema Validator

Name: Supabase Schema Validator
Author: vanman2024

byvanman2024

Database Management

Validates PostgreSQL schemas and migrations for Supabase projects to ensure SQL syntax compliance, naming conventions, and security best practices.

About

The Supabase Schema Validator is a comprehensive toolset designed to maintain the integrity and security of PostgreSQL databases. It automates the tedious process of checking SQL syntax, enforcing naming conventions, and verifying database constraints before deployment. Beyond basic linting, it specifically audits Row Level Security (RLS) policies and index coverage, ensuring your Supabase backend is both secure and performant. By generating detailed markdown reports with clear severity levels (ERROR, WARNING, INFO), it allows developers to catch critical issues in migrations and schema definitions early in the development lifecycle.

Key Features

Automated PostgreSQL syntax and reserved keyword checking
Naming convention enforcement for tables, columns, and constraints
Detailed Row Level Security (RLS) policy validation
Constraint and index integrity verification
Markdown report generation with actionable fix recommendations
0 GitHub stars

Use Cases

Validating migration files before deployment to prevent production errors
Integrating schema audits into CI/CD pipelines for automated quality control
Standardizing database architecture and naming conventions across a team

About

Key Features

Automated PostgreSQL syntax and reserved keyword checking
Naming convention enforcement for tables, columns, and constraints
Detailed Row Level Security (RLS) policy validation
Constraint and index integrity verification
Markdown report generation with actionable fix recommendations
0 GitHub stars

Use Cases

Validating migration files before deployment to prevent production errors
Integrating schema audits into CI/CD pipelines for automated quality control
Standardizing database architecture and naming conventions across a team