Supabase MCP 服务器 | PlugMCP
跳到正文 Supabase MCP Server
A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.
NOTE: This Supabase MCP server was created as a demonstration of my AI IDE coding workflow. It is still a work in progress which I will expand on in future videos on my channel .
Features
Supabase MCP server created in Python.
把任意工具接入任意智能体。面向非开发者的 MCP 服务器目录;网关承载流量,n8n 承载应用。
产品
目录
开发者
公司
Read Table Rows : Query data from Supabase tables with optional filtering, pagination, and column selection
Create Table Records : Insert new records into Supabase tables
Update Table Records : Modify existing records in Supabase tables based on filters
Delete Table Records : Remove records from Supabase tables based on filters
Prerequisites
Docker or Docker Desktop
Supabase account and project
Installation
Clone the repository:
git clone https://github.com/coleam00/supabase-mcp.git
cd supabase-mcp
Docker Setup
Build the Docker image:
docker build -t mcp/supabase .
Usage
Running as an MCP Server with Docker The Supabase MCP server can be integrated with AI assistants using the Model Context Protocol.
Include the below configuration in your MCP config (in Claude Desktop, Windsurf, etc.)
Be sure to build the container with the installation steps first!
{
"mcpServers": {
"supabase": {
"command": "docker",
"args": ["run", "--rm", "-i", "-e", "SUPABASE_URL", "-e", "SUPABASE_SERVICE_KEY", "mcp/supabase"],
"env": {
"SUPABASE_URL": "YOUR-SUPABASE-URL",
"SUPABASE_SERVICE_KEY": "YOUR-SUPABASE-SERVICE-ROLE-KEY"
}
}
}
}
Replace YOUR-SUPABASE-URL and YOUR-SUPABASE-SERVICE-ROLE-KEY with your actual Supabase credentials.
The AI assistant can now access the Supabase database through the MCP server using the provided tools.
Available Tools
Read Table Rows read_table_rows(
table_name: str,
columns: Optional[List[str]] = None,
filters: Optional[Dict[str, Any]] = None,
limit: Optional[int] = None,
offset: Optional[int] = None
)
# Read active users
read_table_rows(
table_name="users",
columns=["id", "name", "email"],
filters={"is_active": True},
limit=10,
offset=0
)
Create Table Records create_table_records(
table_name: str,
records: Union[Dict[str, Any], List[Dict[str, Any]]]
)
# Create a new user
create_table_records(
table_name="users",
records={
"name": "John Doe",
"email": "[email protected] ",
"is_active": True
}
)
Update Table Records update_table_records(
table_name: str,
updates: Dict[str, Any],
filters: Dict[str, Any]
)
# Update user status
update_table_records(
table_name="users",
updates={"status": "premium"},
filters={"is_active": True}
)
Delete Table Records delete_table_records(
table_name: str,
filters: Dict[str, Any]
)
# Delete inactive users
delete_table_records(
table_name="users",
filters={"is_active": False}
)
Development
Project Structure supabase-mcp/
├── supabase_mcp/
│ ├── __init__.py
│ ├── server.py # Main MCP server implementation
│ └── tests/ # Unit tests
├── Dockerfile # Docker configuration for MCP server
├── example_mcp_config.json # Example MCP configuration
├── requirements.txt # Python dependencies
├── .env.example # Example environment variables
├── README.md # Project documentation
├── PLANNING.md # Project planning
└── TASKS.md # Task tracking
Running Tests pytest supabase_mcp/tests/
Model Context Protocol Integration The Supabase MCP server implements the Model Context Protocol , which allows AI assistants to interact with Supabase databases in a standardized way.
How It Works
The MCP server exposes tools for database operations (read, create, update, delete)
AI assistants connect to the MCP server using the stdio transport
The AI assistant can invoke the tools to perform database operations
The MCP server handles the communication with Supabase and returns the results
MCP Configuration The example_mcp_config.json file shows how to configure an AI assistant to use the Supabase MCP server:
{
"mcpServers": {
"supabase": {
"command": "docker",
"args": ["run", "--rm", "-i", "-e", "SUPABASE_URL", "-e", "SUPABASE_SERVICE_KEY", "mcp/supabase"],
"env": {
"SUPABASE_URL": "YOUR-SUPABASE-URL",
"SUPABASE_SERVICE_KEY": "YOUR-SUPABASE-SERVICE-ROLE-KEY"
}
}
}
}
This configuration tells the AI assistant:
To use Docker to run the MCP server
To pass the Supabase credentials as environment variables
To use the mcp/supabase Docker image
Using with AI Assistants AI assistants that support the Model Context Protocol can use this server to:
Query data from Supabase tables
Insert new records into tables
Update existing records
Delete records
The assistant will have access to the tools documented in the "Available Tools" section above.
Environment Variables
License This project is licensed under the MIT License - see the LICENSE file for details.
Graphify Turn any codebase, with its docs, SQL schemas, configs, and PDFs, into a queryable knowledge graph. A /graphify skill for Claude Code, Cursor, Codex, and Gemini CLI: local deterministic AST parsing, e Private Gpt Complete API layer for private AI applications on local models: RAG, skills, tools, MCP, text-to-sql, and more. Works with any OpenAI-compatible inference server. Scientific Agent Skills Turn any AI agent into an AI Scientist. The #1 Agent Skills library for science, used by 250,000+ scientists worldwide. 177 ready-to-use validated skills plus 100+ scientific databases covering biolog Open Code Review Secure, fast, efficient, battle-tested at Alibaba's scale. Hybrid architecture code review tool: deterministic pipelines + LLM Agent, precise line-level comments, built-in multi-language ruleset (NPE, Codebase Memory Local code intelligence for developers and AI agents. Connect code, docs and infrastructure in a persistent graph, with CBM Lens, MCP tools, agent integrations and change-aware test selection. Orm The Prisma ORM: write your application in TypeScript with human-readable queries instead of SQL. Host your database on Prisma Postgres and your app on Prisma Compute. OpenViking Self-evolving Context Database for AI Agents. Unify Agent Memory, Knowledge RAG and Skills. Context Mode Free, local plugin that keeps tool output out of your coding agent's context window. Sandbox and SQLite FTS5 search, 99% fewer bytes in context. Works with Claude Code, Codex, Pi, OMP, OpenCode, Gemin Dbx 25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Dock Xerj AI search engine and MCP server for bots and agents. One Rust binary indexes code, docs, logs, JSONL/CSV and PDFs for BM25 full-text, vector and hybrid search, code search without grep, agent memory a Wasp The batteries-included full-stack framework for the AI era. Develop JS/TS web apps (React, Node.js, and Prisma) using declarative code that abstracts away complex full-stack features like auth, backgr WrenAI GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data s Databases MCP 服务器 最佳 Databases MCP 服务器
暂无工具列表。远程服务器在首次健康检查后会获得工具列表。
如何安装 Supabase? 在本页复制适用于 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 配置。它使用发布者的安装方式,而不是 PlugMCP 代理。
Supabase 需要 API 密钥吗? 此记录未列出必需的环境变量。
Supabase 使用哪种传输方式? Supabase 通过 stdio 在本地运行。
Supabase 上次检查是什么时候? 上次检查时间:2026-10-26。 Supabase MCP server created in Python.
工具
0 / 10