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

0•

数据库管理

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

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.

主要功能

01Automated PostgreSQL syntax and reserved keyword checking

02Naming convention enforcement for tables, columns, and constraints

03Detailed Row Level Security (RLS) policy validation

04Constraint and index integrity verification

05Markdown report generation with actionable fix recommendations

060 GitHub stars

使用场景

01Validating migration files before deployment to prevent production errors

02Integrating schema audits into CI/CD pipelines for automated quality control

03Standardizing database architecture and naming conventions across a team

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vanman2024/ai-dev-marketplace schema-validation

For use in Claude.ai and ChatGPT

Download Skill