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 resultsSchema Design
"Design a schema for a blog platform with posts, comments, and tags"
→ Agent generates CREATE TABLE statements and relationshipsMigration Generation
"Add a soft-delete column to all tables that don't have one"
→ Agent generates ALTER TABLE migrationsKey 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.