@supernova123/supabase-mcp-server

Supabase MCP Server

Connect AI assistants to Supabase — database queries, auth, storage, and edge functions through the Model Context Protocol.

Works with Claude Desktop, Cursor, Windsurf, Cline, Continue, and any MCP-compatible client.

Features

Tool	Description
list_tables	List all tables in the public schema
query_database	Execute read-only SQL queries
get_table_schema	Get column definitions for a table
insert_rows	Insert one or more rows into a table
update_rows	Update rows matching a filter
delete_rows	Delete rows matching a filter
list_storage_buckets	List all storage buckets
list_storage_objects	List files in a storage bucket
get_storage_public_url	Get public URL for a storage object
invoke_edge_function	Call a Supabase Edge Function
list_auth_users	List users in Supabase Auth
get_auth_user	Get a specific auth user by ID
get_project_info	Get project URL and key info

Quick Start

1. Get your Supabase credentials

Go to Supabase Dashboard → Project Settings → API and copy:

• Project URL (e.g. https://your-project.supabase.co)
• service_role key (under "Project API keys")

2. Configure your MCP client

Claude Desktop — add to claude_desktop_config.json:

{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": ["-y", "@supernova123/supabase-mcp-server"],
      "env": {
        "SUPABASE_URL": "https://your-project.supabase.co",
        "SUPABASE_SERVICE_KEY": "your-service-role-key"
      }
    }
  }
}

Cursor / Windsurf — add to MCP settings:

{
  "supabase": {
    "command": "npx",
    "args": ["-y", "@supernova123/supabase-mcp-server"],
    "env": {
      "SUPABASE_URL": "https://your-project.supabase.co",
      "SUPABASE_SERVICE_KEY": "your-service-role-key"
    }
  }
}

3. Start using

Once configured, your AI assistant can:

• Query your database with SQL
• Browse table schemas
• Insert, update, and delete data
• Manage storage files
• Invoke edge functions
• List and inspect auth users

Environment Variables

Variable	Required	Description
SUPABASE_URL	✅	Your project URL (e.g. https://xxx.supabase.co)
SUPABASE_SERVICE_KEY	✅	Service role key from Project Settings → API
SUPABASE_ANON_KEY	❌	Anonymous key (for auth-related tools)

Security

• The query_database tool only allows SELECT queries by default — mutations must use the dedicated insert/update/delete tools.
• The service_role key bypasses Row Level Security. Use it responsibly.
• Consider using the SUPABASE_ANON_KEY for auth-related operations.

License

MIT