Supabase MCP Server

by MCP-Mirror

306 downloads
Not rated
GitHub

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…

Details

Author
MCP-Mirror
Downloads
306
Categories
Cloud Service

- 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.
- Python 3.12+, PostgreSQL 16+, and uv package manager required.

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:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. 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.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Clone the repository, create a virtual environment with uv venv, install dependencies with uv sync, then configure the IDE to run the server via uv --directory <path> run main.py. For local development the server connects to 127.0.0.1:54322 with password postgres. For production projects set environment variables SUPABASE_PROJECT_REF and SUPABASE_DB_PASSWORD.

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"
        ]
    }
}

Supabase MCP Server

<p align="center">
<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>
&nbsp;&nbsp;
<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>
</p>

<p align="center">
<strong>Let Cursor & Windsurf interact with Supabase</strong>
</p>

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

Sign in to leave a review

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

Email sign in

No reviews posted yet.