Supabase MCP (Enhanced)

Overview

Supabase MCP provides comprehensive integration with Supabase, enabling AI agents to interact with PostgreSQL database, authentication, storage, realtime, and edge functions.

Features

• PostgreSQL query execution
• Authentication management
• Storage operations
• Realtime subscriptions
• Edge function invocation

Installation

npx -y @modelcontextprotocol/server-supabase

Configuration

Set the following environment variables:

export SUPABASE_URL=https://your-project.supabase.co
export SUPABASE_ANON_KEY=your_anon_key
export SUPABASE_SERVICE_ROLE_KEY=your_service_role_key

Get your keys from https://app.supabase.com/project/_/settings/api.

Available Tools

Tool	Description
query	Execute SQL queries
select	Select from a table
insert	Insert records
update	Update records
delete	Delete records
auth_sign_in	Authenticate user
storage_list	List storage buckets

Usage Examples

Query Database

{
  "query": "SELECT * FROM users WHERE active = true"
}

Insert Record

{
  "table": "todos",
  "data": {
    "title": "Complete project",
    "completed": false
  }
}

Pros

• ✅ Full Supabase integration
• ✅ PostgreSQL queries
• ✅ Auth and storage
• ✅ Realtime support

Cons

• ❌ Requires Supabase project
• ❌ Multiple credentials needed
• ❌ Rate limits apply

Resources

• Supabase Docs
• MCP Server GitHub