skills.rest
SS2608-dev
SS2608-devCOMMUNITY
Explore all skills by this author →
GitHub

db-audit

Audit Supabase database schema, RLS policies, indexes, foreign keys, migrations, and data integrity.

Updated Aug 27, 2026
Search Tags:#security#database#data integrity#audit#supabase#health check
One-click install
npx skills add https://github.com/SS2608-dev/Resilience --skill db-audit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-audit
Source: https://github.com/SS2608-dev/Resilience/tree/main/.claude/skills/database/db-audit
Command: npx skills add https://github.com/SS2608-dev/Resilience --skill db-audit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the critical need for maintaining the health, security, and integrity of the Supabase database, preventing data loss and ensuring smooth application operation.

Core Features & Use Cases

  • Comprehensive Schema Audit: Verifies the presence and correctness of all essential tables.
  • RLS Policy Verification: Ensures Row Level Security is correctly configured for data protection.
  • Index and Foreign Key Checks: Optimizes query performance and maintains data relationships.
  • Migration Status Tracking: Confirms all database migrations have been applied.
  • Data Integrity Validation: Detects orphaned records and incomplete data.
  • Use Case: Before a major deployment, run this audit to proactively identify and fix potential database issues that could cause downtime or data corruption.

Quick Start

Run a comprehensive database audit using the db-audit skill.

Frequently Asked Questions about db-audit

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

FAQPage Schema
How do I run a comprehensive Supabase database health check before deployment?▼

A Supabase database health check involves verifying schema correctness, validating Row Level Security policies, assessing index health, and confirming migration status to proactively prevent downtime or data corruption during major deployments.

What does Row Level Security policy verification check in a Supabase database?▼

Row Level Security policy verification ensures RLS is correctly configured for data protection, preventing unauthorized access by validating that access control rules are properly applied to essential tables within the Supabase database.

How do I validate foreign key constraints and detect orphaned records in Supabase?▼

Validating foreign key constraints and detecting orphaned records requires performing data integrity checks to maintain data relationships, ensuring referential integrity and identifying incomplete data across the database tables.

Can I track database migration status and schema verification for Supabase projects?▼

Tracking database migration status and schema verification confirms all essential tables are present and correctly structured, ensuring all pending database migrations have been successfully applied to maintain operational readiness.

What is the best way to assess index health and optimize query performance in Supabase?▼

Assessing index health evaluates database indexes to optimize query performance, identifying missing or inefficient indexes as part of a comprehensive audit to maintain smooth application operation and data integrity.

Related Skills

Explore More Software Engineering Skills→
antonpmeantonpme
1

supabase

Guides Supabase edge functions, schemas, migrations, and RLS policies.

Community
Advanced
3balljugglerYu3balljugglerYu

project-database-context

Document Persta.AI's Supabase schema, RLS policies, RPCs, triggers, and migrations.

Community
Intermediate
SamuelSahaSamuelSaha

CI/CD Pipeline Mastery

Automate CI/CD for web apps with GitHub Actions and Vercel.

Community
Advanced
MORTAKI0MORTAKI0

doittimer-supabase

Inspect and manage DoItTimer Supabase schema migrations, RLS policies, and local seeding.

Community
Advanced