skills.rest
BruceTyndall
BruceTyndallCOMMUNITY
Explore all skills by this author →
GitHub

db-inspector

Audit Supabase schemas, RLS policies, and migration integrity.

Updated Aug 27, 2026
Search Tags:#typescript#database#rls#schema#audit#migration#supabase
One-click install
npx skills add https://github.com/BruceTyndall/socelle-global --skill db-inspector-brucetyndall
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-inspector
Source: https://github.com/BruceTyndall/socelle-global/tree/main/.agents/skills/db-inspector
Command: npx skills add https://github.com/BruceTyndall/socelle-global --skill db-inspector-brucetyndall

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the auditing of your Supabase database schema, ensuring data integrity, security, and consistency by checking RLS policies, migration safety, and detecting schema drift.

Core Features & Use Cases

  • Migration Integrity: Verifies that migrations adhere to an ADD-ONLY policy, preventing accidental data loss through ALTER or DROP statements.
  • Schema Drift Detection: Compares the database schema defined in database.types.ts against actual migration files to identify discrepancies.
  • RLS Policy Audit: Checks that all tables have Row Level Security (RLS) policies enabled.
  • Hook-to-Table Mapping: Maps frontend hooks to the Supabase tables they interact with.
  • Duplicate Hook Detection: Identifies any duplicate hook files within the codebase.

Quick Start

Run a comprehensive audit of the Supabase database schema and RLS policies for the SOCELLE-WEB project.

Frequently Asked Questions about db-inspector

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

FAQPage Schema
How do I detect schema drift between Supabase migration files and database.types.ts?▼

To detect schema drift, you audit the Supabase database by comparing the schema defined in database.types.ts against actual migration files to automatically identify discrepancies and ensure type consistency.

How do I verify that Supabase migrations follow an ADD-ONLY policy?▼

You verify ADD-ONLY migration policies by auditing migration files to detect any ALTER or DROP statements, ensuring that migrations only add new structures and prevent accidental data loss.

How do I check if Row Level Security is enabled on all Supabase tables?▼

You check RLS enablement by running an RLS policy audit that scans all Supabase database tables and verifies whether Row Level Security policies are actively configured and enabled.

How do I map frontend hooks to Supabase tables and find duplicates?▼

You map hooks to tables by analyzing the codebase to identify which frontend hooks interact with specific Supabase tables, while simultaneously scanning for and identifying any duplicate hook files.

Can I audit my Supabase database schema without external dependencies?▼

Yes, you can audit your Supabase database schema without external dependencies, as the Skill operates independently using scripts to verify migration integrity, RLS policies, and schema drift.

Related Skills

Explore More Software Engineering Skills→
ConsiliencyConsiliency
8

schema-alignment

Detect drift between database schemas and ORM models in Python and TypeScript projects.

Official
Advanced
s3nex-coms3nex-com

api-contract-enforcer

Verify service implementations against OpenAPI specs using Pact or Schema Registry.

Community
Advanced
devjaimedevjaime
1

supabase-expert

Guides building secure, scalable Supabase backends with schemas, RLS policies, authentication, Edge Functions, and real-time features.

Community
Advanced
KlimabevaegelsenKlimabevaegelsen
39

supabase-migration

Manage Supabase database migrations, RLS policies, and PostGIS geometry.

Official
Advanced