Supabase MCP Server

by MCP-Mirror

306 downloads Not rated yet

GitHub

Cloud Service

About

Supabase MCP Server is an MCP (Model Context Protocol) implementation that enables Cursor and Windsurf IDEs to interact directly with a Supabase PostgreSQL database. It provides a set of database management tools, including schema exploration and SQL query validation, designed…

Explore

- 💻 Works with both Windsurf and Cursor IDEs
- ✅ Supports local Supabase projects and production Supabase projects
- 🔨 Built-in database exploration tools with schema insights
- 🔐 Secure read-only database access
- 🔍 SQL query validation

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Supabase MCP Server

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

From the repository

- Python 3.12+
- PostgreSQL 16+
- uv package manager

1. PostgreSQL Installation (Required for psycopg2)

   brew install postgresql@16

> ⚠️ Important: PostgreSQL must be installed BEFORE installing project dependencies. The psycopg2 package requires PostgreSQL development libraries during compilation.

2. uv Package Manager

   pip install uv

1. PostgreSQL Installation
- Download and install PostgreSQL 16+ from https://www.postgresql.org/download/windows/
- Ensure "PostgreSQL Server" and "Command Line Tools" are selected during installation

2. uv Package Manager

   pip install uv

uv venv

For staging or production Supabase projects, set these environment variables (setup differs for Cursor and Windsurf):

SUPABASE_PROJECT_REF="your-project-ref"  # e.g., "abcdefghijklm"

SUPABASE_DB_PASSWORD="your-db-password"

Add an MCP server with this configuration:

name: supabase

protocol: stdio

command: uv --directory /path/to/cloned/supabase-mcp-server run main.py

Example with actual path:

command: uv --directory /Users/az/cursor/supabase-mcp-server run main.py

After adding this configuration, Agent mode will have access to all database tools.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "supabase mcp server": {
            "alexander-zuev_supabase-mcp-server": {
                "command": "uv",
                "args": [
                    "venv"
                ]
            }
        }
    }
}

McpServers

{
    "alexander-zuev_supabase-mcp-server": {
        "command": "uv",
        "args": [
            "venv"
        ]
    }
}

<picture>
<source media="(prefers-color-scheme: dark)" srcset="https://github.com/user-attachments/assets/4a363bcd-7c15-47fa-a72a-d159916517f7" />
<source media="(prefers-color-scheme: light)" srcset="https://github.com/user-attachments/assets/d255388e-cb1b-42ea-a7b2-0928f031e0df" />
Supabase
</picture>
  
<picture>
<source media="(prefers-color-scheme: dark)" srcset="https://github.com/user-attachments/assets/38db1bcd-50df-4a49-a106-1b5afd924cb2" />
<source media="(prefers-color-scheme: light)" srcset="https://github.com/user-attachments/assets/82603097-07c9-42bb-9cbc-fb8f03560926" />
MCP
</picture>

Let Cursor & Windsurf interact with Supabase

Implementaton of Supabase MCP server that enables Cursor and Windsurf to interact directly with Supabase PostgreSQL database. It provides a set of database management tools that work seamlessly with these IDEs through the MCP protocol.

Key features

- 💻 Works with both Windsurf and Cursor IDEs - ✅ Supports local Supabase projects and production Supabase projects - 🔨 Built-in database exploration tools with schema insights - 🔐 Secure read-only database access - 🔍 SQL query validation

Prerequisites

- Python 3.12+ - PostgreSQL 16+ - uv package manager

Mac-specific Setup

1. PostgreSQL Installation (Required for psycopg2)

   brew install postgresql@16

> ⚠️ Important: PostgreSQL must be installed BEFORE installing project dependencies. The psycopg2 package requires PostgreSQL development libraries during compilation.

2. uv Package Manager

   pip install uv

Windows Setup

1. PostgreSQL Installation - Download and install PostgreSQL 16+ from https://www.postgresql.org/download/windows/ - Ensure "PostgreSQL Server" and "Command Line Tools" are selected during installation

2. uv Package Manager

   pip install uv

Installation

1. Clone and setup environment
```bash
git clone https://github.com/alexander-zuev/supabase-mcp-server.git
cd supabase-mcp-server

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Explore

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Key features

Prerequisites

Mac-specific Setup

Windows Setup

Installation

More like this

Aws Kb Retrieval Server

AWS MCP Servers

container-use

container-use