Supabase MCP Server

What it does

Supabase's MCP server that connects AI assistants to your Supabase projects so they can manage tables, fetch config and query data.

Who it's for

Vibe coders building apps on Supabase who want the agent to handle the database side.

How to set it up

1. Read Supabase's MCP security best practices first. Connecting an LLM to a database carries real risks.

2. Add the remote server. Your client will prompt you to log in to Supabase; pick the organization that has your project.

   jsonCopy

   {
     "mcpServers": {
       "supabase": {
         "type": "http",
         "url": "https://mcp.supabase.com/mcp"
       }
     }
   }

3. Optionally scope it with URL options. With the local Supabase CLI, the server is at http://localhost:54321/mcp (fewer tools).

   textCopy

   https://mcp.supabase.com/mcp?project_ref=<ref>&read_only=true

Check the official docs for the latest steps.

Example prompts

Create a 'profiles' table linked to auth users with a username column.

List the tables in my project and describe how they relate.

Write and run a query that counts signups per day this week.

Demo