mcp-supabase

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.