sql-hardener

What problem does it solve?

The SQL Hardener automates cleanup and security hardening of Supabase database schemas by discovering missing indexes, identifying RLS policy gaps, and generating safe, testable migrations to prepare schemas for production deployment.

Core Features & Use Cases

• Schema Audits: Detect missing indexes, nullable fields that should be NOT NULL, and absent or overly permissive RLS policies.
• Migration Generation: Produce Supabase CLI migration files with index creation, RLS templates, and constraint improvements suitable for review and testing.
• Safety & Validation: Provide dry-run workflows, linting, backups, and explicit confirmation steps before pushing changes to remote.
• Use Case: Consolidate multiple SQL schema files into a hardened migration set, add missing FK and timestamp indexes, and enforce user-owned RLS policies before production rollout.

Quick Start

Run a dry audit of the linked Supabase project to list issues and generate recommended migration SQL without applying changes.