MCP.so
登录

Supabase MCP Server

@MCP-Mirror

代码仓库

关于 Supabase MCP Server

Mirror of

#supabase#mcp-server#database-management

基本信息

分类

云与基础设施

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Supabase MCP Server?

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 for developers using these AI‑assisted IDEs.

How to use Supabase MCP Server?

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.

Key features of Supabase MCP Server

  • 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.

Use cases of Supabase MCP Server

  • Explore database schemas and tables from within Cursor or Windsurf without leaving the editor.
  • Run validated SQL queries against a production Supabase database in a read‑only mode.
  • Debug or inspect local Supabase PostgreSQL databases during development.
  • Enable AI assistants to understand and interact with the database structure securely.

FAQ from Supabase MCP Server

What prerequisites are needed to run the server?

Python 3.12+, PostgreSQL 16+, and the uv package manager are required. On macOS, PostgreSQL must be installed before installing dependencies for the psycopg2 package.

Does the server support production Supabase databases?

Yes. Set the environment variables SUPABASE_PROJECT_REF and SUPABASE_DB_PASSWORD to connect to staging or production Supabase projects. The server remains read‑only.

Is database access read‑only?

Yes. The server enforces read‑only access to the PostgreSQL database. SQL queries are validated before execution.

How do I configure the server for Cursor or Windsurf?

For Cursor, add an MCP server entry with command: uv --directory /path/to/repo run main.py and the stdio transport. For Windsurf, edit mcp_config.json to specify the uv command, repository path, and environment variables for connection details.

What are the default connection settings for local development?

The server defaults to host 127.0.0.1:54322 with password postgres. These can be overridden for production by setting the environment variables.

评论

云与基础设施 分类下的更多 MCP 服务器

container-use

aluzzardi

Development environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.

3.9K

Aws Kb Retrieval Server

modelcontextprotocol

Model Context Protocol Servers

88.2K

container-use

dagger

Development environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.

3.9K

K8s MCP Server

alexei-led

K8s-mcp-server is a Model Context Protocol (MCP) server that enables AI assistants like Claude to securely execute Kubernetes commands. It provides a bridge between language models and essential Kubernetes CLI tools including kubectl, helm, istioctl, and argocd, allowing AI syste

212

Cloudflare MCP Server

cloudflare

3.9K