supabase-mcp-server

Supabase MCP Server

An MCP (Model Context Protocol) server that enables LLMs to interact with Supabase services including Database, Auth, Storage, and Edge Functions.

Setup

1. Install dependencies:

   npm install

1. Copy .env.example to .env and fill in your Supabase credentials:

   cp .env.example .env

1. Build:

   npm run build

1. Run:

   npm start

Environment Variables

| Variable | Required | Description | |----------|----------|-------------| | SUPABASE_URL | Yes | Your Supabase project URL | | SUPABASE_SERVICE_ROLE_KEY | Yes | Service role key (found in Project Settings > API) | | TRANSPORT | No | Transport mode: stdio (default) or http |

MCP Client Configuration

Add to your MCP client config (e.g., Claude Desktop):

{
  "mcpServers": {
    "supabase": {
      "command": "node",
      "args": ["/path/to/supabase-mcp-server/dist/index.js"],
      "env": {
        "SUPABASE_URL": "https://your-project.supabase.co",
        "SUPABASE_SERVICE_ROLE_KEY": "your-service-role-key"
      }
    }
  }
}

Available Tools

Database (7 tools)

• supabase_query - Select rows with filters, ordering, pagination
• supabase_insert - Insert one or more rows
• supabase_update - Update rows matching filters
• supabase_delete - Delete rows matching filters
• supabase_upsert - Insert or update on conflict
• supabase_rpc - Call a Postgres function
• supabase_list_tables - List tables in the database

Auth (5 tools)

• supabase_auth_list_users - List users with pagination
• supabase_auth_get_user - Get user by ID
• supabase_auth_create_user - Create a new user
• supabase_auth_update_user - Update user details
• supabase_auth_delete_user - Delete a user

Storage (8 tools)

• supabase_storage_list_buckets - List storage buckets
• supabase_storage_create_bucket - Create a bucket
• supabase_storage_list_files - List files in a bucket
• supabase_storage_upload - Upload a file (base64)
• supabase_storage_download - Download a file (base64)
• supabase_storage_delete - Delete files
• supabase_storage_get_public_url - Get public URL
• supabase_storage_move - Move/rename a file

Edge Functions (1 tool)

• supabase_functions_invoke - Invoke an Edge Function

Development

npm run dev    # Run with tsx (hot reload)
npm run build  # Compile TypeScript
npm start      # Run compiled output

Testing with MCP Inspector

npx @modelcontextprotocol/inspector node dist/index.js