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

schema-db-suite

Validate database schema health across migrations, types, and RLS policies.

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

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 database schema integrity, ensuring consistency between code, migrations, and the live database, and verifying security policies.

Core Features & Use Cases

  • Migration Validation: Checks migration files for correct ordering, naming, and adherence to ADD-ONLY policies.
  • Schema Drift Detection: Identifies discrepancies between TypeScript types and actual database schema.
  • Type Generation Verification: Ensures TypeScript types accurately reflect the database schema and are used correctly.
  • Database Inspection: Performs a full inventory of database objects, including tables, columns, RLS policies, indexes, and triggers.
  • Use Case: Before deploying a new feature that modifies the database, run this suite to catch potential migration errors, ensure type safety, and confirm that Row Level Security policies are correctly applied, preventing costly production issues.

Quick Start

Run the schema-db-suite to validate all database migrations and types.

Frequently Asked Questions about schema-db-suite

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

FAQPage Schema
How do I detect schema drift between my TypeScript types and a Supabase database?▼

To detect schema drift, validate database schema health by identifying discrepancies between TypeScript type definitions and the actual live database schema. This ensures your code accurately reflects the current database structure.

What is the best way to validate database migration files before deploying?▼

The best way to validate database migrations is to check migration files for correct ordering, naming, and adherence to ADD-ONLY policies. This prevents costly production issues by ensuring migration integrity before deployment.

Can I inspect Row Level Security policies and indexes in a Supabase database?▼

Yes, you can perform a full database inspection to inventory database objects, including tables, columns, indexes, triggers, and Row Level Security policies. This confirms that security policies are correctly applied across the database.

Do I need Supabase configuration and migration files to verify type generation?▼

Yes, you need access to migration files, TypeScript type definitions, and Supabase configuration. Type generation verification requires these inputs to ensure TypeScript types accurately reflect the database schema and are used correctly.

Why does my TypeScript type generation not match the live database schema?▼

Type generation may not match the live database schema due to untracked schema drift. Running a full database inspection and type generation verification identifies these discrepancies and ensures consistency between code and the database.

Related Skills

Explore More Software Engineering Skills→
titabashtitabash

supabase-migration

Manage Supabase PostgreSQL schema migrations with Drizzle ORM and TypeScript.

Community
Advanced
ConsiliencyConsiliency
8

schema-alignment

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

Official
Advanced
ManzuetiManzueti

land-and-deploy

Merge pull requests, deploy code to production, and perform health checks.

Community
Advanced
CleanExpoCleanExpo
3

sql-hardener

Audit Supabase SQL schemas and generate CLI migrations for RLS and indexes.

Community
Advanced