What problem does it solve?
Supabase MCP operations can run without governance, risking unintended writes, unsafe migrations, and untracked changes. This Skill provides guarded, auditable actions: queries, statistics, exports, writes (with explicit confirmation), migrations, and type generation, with artifact capture for replay and debugging.
Core Features & Use Cases
- Controlled DB actions: Execute SELECTs, LIST tables, export data, and read metadata with safety gates.
- Write governance: INSERT/UPDATE/DELETE require confirmation and WHERE checks; migrations are applied via dedicated commands.
- Audit-ready pipelines: All steps persist artifacts in a file-based workflow to support logging, replay, and review.
- Use case: An AI agent runs a data cleanup job that updates user_status after confirming counts, then generates TS types from schema for client code.
Quick Start
Start by inspecting the database schema with list_tables and list_migrations, plan a read-only query with execute_sql, then outline a migration with apply_migration. Only after explicit confirmation should a write operation be performed, after which logs and generated types can be reviewed.