Supabase MCP — Postgres + Auth Server for AI Agents

Available Tools

Database Operations

"Show all tables in the public schema"
"Query the users table for accounts created this week"
"Create a new products table with name, price, and category columns"
"Add an index on the email column of the users table"

Authentication

"List all registered users"
"Create a new user with email test@example.com"
"Check the auth configuration for email verification"

Storage

"List all buckets and their sizes"
"Upload this file to the avatars bucket"
"Generate a signed URL for the report.pdf file"

Edge Functions

"List deployed edge functions"
"Show the logs for the send-email function"

SQL Execution

"Run this SQL: SELECT count(*) FROM orders WHERE status = 'pending'"
"Explain the query plan for the products listing query"

Use Cases

AI-Powered Data Exploration

"Analyze the orders table — show revenue by month for the last quarter"
→ Agent writes and runs SQL, presents formatted results

Schema Design

"Design a schema for a blog platform with posts, comments, and tags"
→ Agent generates CREATE TABLE statements and relationships

Migration Generation

"Add a soft-delete column to all tables that don't have one"
→ Agent generates ALTER TABLE migrations

Key Stats

• 4,000+ GitHub stars
• Full PostgreSQL access
• Auth, Storage, Edge Functions
• SQL execution and schema management
• Row Level Security aware

FAQ

Q: What is Supabase MCP? A: An MCP server that gives AI agents full access to Supabase services — PostgreSQL database, authentication, file storage, and edge functions.

Q: Is Supabase MCP free? A: The MCP server is open-source. Supabase has a generous free tier.

Q: Is it safe to give the agent database access? A: Use the service key for trusted environments. For production, use scoped API keys with Row Level Security.