mcp-supabase

Execute governed Supabase database actions via MCP tools.

339|58|Updated Jan 10, 2026
One-click install
npx skills add https://github.com/Heyvhuang/ship-faster --skill mcp-supabase
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mcp-supabase
Source: https://github.com/Heyvhuang/ship-faster/tree/main/skills/mcp-supabase
Command: npx skills add https://github.com/Heyvhuang/ship-faster --skill mcp-supabase

SYSTEM DOCUMENTATION & REQUIREMENTS

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

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.

Frequently Asked Questions about mcp-supabase

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

FAQPage Schema
Can I generate TypeScript types directly from a Supabase database schema?

Supabase database queries enforce read-first checks and default limits to ensure safe data retrieval. You can execute SELECTs, list tables, export data, and read metadata through controlled MCP tools that prevent unrestricted access.

What is the best way to audit and replay Supabase database actions performed by an AI workflow?

Read-only SQL queries run through MCP tools that enforce read-first checks and default query limits. This controlled execution prevents accidental writes while allowing you to inspect schema, gather statistics, and export data safely.

How do I safely apply database migrations to Supabase using MCP?

TypeScript type generation from a Supabase schema produces client code types after database actions are complete. This feature allows AI agents to automatically generate TS types reflecting the current schema following migrations or data updates.

Do I need explicit confirmation for every database write operation in Supabase MCP?

Auditing Supabase database actions relies on a file-based workflow that persists all step artifacts. This approach supports logging, replay, and review of queries, writes, and migrations to maintain governance over automated pipelines.

How do I safely apply database migrations to Supabase using MCP?

Explicit confirmation is required for all Supabase database write operations, including INSERT, UPDATE, and DELETE. The system enforces WHERE checks and prompts for approval before executing any modifications to prevent untracked changes.

Can I execute read-only SQL queries against Supabase without risking accidental writes?

Database migrations to Supabase are applied via dedicated MCP commands rather than direct execution. This method enforces DDL through controlled migrations, ensuring structural changes are deliberate, logged, and auditable.