skills.rest
BinkyTwin
BinkyTwinCOMMUNITY
Explore all skills by this author →
GitHub

supabase-mcp

Configure Supabase MCP tools to inspect schemas and plan migrations.

1|Updated Dec 9, 2025
Search Tags:#security#database#migrations#rls#supabase#mcp
One-click install
npx skills add https://github.com/BinkyTwin/DeepRead --skill supabase-mcp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-mcp
Source: https://github.com/BinkyTwin/DeepRead/tree/main/.claude/skills/supabase-mcp
Command: npx skills add https://github.com/BinkyTwin/DeepRead --skill supabase-mcp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a safe, project-scoped way to inspect and manage a Supabase project via MCP, including listing tables, schemas, and migrations, with optional read-only modes for safety.

Core Features & Use Cases

  • Available MCP tools: list_tables, get_table_schema, execute_sql, list_storage_buckets, create_migration.
  • Safety-first setup: project-scoped access, development-only usage, optional read-only.
  • Use Case: Plan and apply a migration after surveying table schemas, then generate a diff.

Quick Start

Option A — CLI: claude mcp add --scope project --transport http supabase "https://mcp.supabase.com/mcp?project_ref=PROJECT_REF" Then authenticate and use the tools. Option B — .mcp.json at repo root. For CI, configure an Authorization header.

Frequently Asked Questions about supabase-mcp

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

FAQPage Schema
How do I safely inspect and manage a Supabase project schema from Claude Code?▼

Supabase MCP lets you list tables, view column definitions, and review RLS policies directly from Claude Code with project-scoped, development-only access. Set it up via CLI with `claude mcp add --scope project` or configure `.mcp.json` at your repo root, then use tools like list_tables and get_table_schema to survey your database structure before making changes.

Can I plan and apply database migrations safely through Claude Code?▼

Yes. Supabase MCP's create_migration tool lets you plan migrations by inspecting current schemas, then generate SQL diffs and migration artifacts. The Skill enforces safe defaults: project-scoped access, dev-only usage, and optional read-only modes so you review changes before applying them.

What security features does Supabase MCP provide for database access?▼

Supabase MCP enforces three safety layers: project-scoped credentials limit blast radius, development-only restrictions prevent production accidents, and optional read-only modes let you audit schemas without write permissions. Authentication via Authorization headers supports secure CI setups.

How do I create and manage Supabase storage buckets from Claude Code?▼

Supabase MCP includes a list_storage_buckets tool and create_migration support for bucket provisioning. Use execute_sql to query bucket metadata alongside table schemas, managing your full Supabase project infrastructure through a single MCP interface.

What's the difference between CLI and configuration-file setup for Supabase MCP?▼

CLI setup with `claude mcp add` is faster for quick projects; `.mcp.json` at repo root suits version control and team collaboration. Both methods support HTTP transport and project-scoped access; choose based on whether you want CLI convenience or tracked configuration.

Related Skills

Explore More Software Engineering Skills→
ronnycodingronnycoding
20

connect-mcp-server

Connect MCP servers to Claude Code across HTTP, stdio, and SSE transports.

Community
Advanced
hb9397hb9397

commit

Generate Conventional Commits messages from staged git changes and project architecture.

Community
Intermediate
JocDLCJocDLC
4

supabase

Manage Supabase databases with migrations, RLS policies, and SQL queries.

Community
Advanced
manuelbrandner85manuelbrandner85

supabase

Manage Supabase project lifecycle, schema migrations, and security policies.

Community
Advanced