Supabase MCP Server
A Model Context Protocol (MCP) server that allows Claude and other LLMs to interact with Supabase to perform CRUD operations on Postgres tables.
Features
- Database operations:
- Query data with filters
- Insert data
- Update data
接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
npx -y [email protected]Claude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
claude mcp add cappahccino-sb-mcp -- npx -y supabase-mcp@1.5.0在終端機中執行。
{ "mcpServers": { "cappahccino-sb-mcp": { "command": "npx", "args": [ "-y", "[email protected]" ] } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
來自發布者
A Model Context Protocol (MCP) server that allows Claude and other LLMs to interact with Supabase to perform CRUD operations on Postgres tables.
Supabase Model Context Protocol (MCP) server for CRUD operations and Edge Functions
The package is published on npm! You can install it globally with:
npm install -g supabase-mcp
Or locally in your project:
npm install supabase-mcp
git clone https://github.com/Cappahccino/SB-MCP.git
cd SB-MCP
npm install
npm run build
Create a .env file with your Supabase credentials:
# Supabase credentials
SUPABASE_URL=your_supabase_project_url
SUPABASE_ANON_KEY=your_supabase_anon_key
SUPABASE_SERVICE_ROLE_KEY=your_supabase_service_role_key
# MCP server configuration
MCP_SERVER_PORT=3000
MCP_SERVER_HOST=localhost
MCP_API_KEY=your_secret_api_key
Claude requires a specific transport mode for compatibility. This package provides a dedicated binary for Claude integration:
"supabase": {
"command": "npx",
"args": [
"-y",
"supabase-mcp@latest",
"supabase-mcp-claude"
],
"env": {
"SUPABASE_URL": "your_supabase_project_url",
"SUPABASE_ANON_KEY": "your_supabase_anon_key",
"SUPABASE_SERVICE_ROLE_KEY": "your_service_role_key",
"MCP_API_KEY": "your_secret_api_key"
}
}
Make sure you set the required environment variables in the configuration. Claude will use the stdio transport for communication.
For testing outside of Claude, you can run:
npm run start:claude
Or if installed globally:
supabase-mcp-claude
After installing globally:
supabase-mcp
This will start the MCP server at http://localhost:3000 (or the port specified in your .env file).
You can also use supabase-mcp as a library in your own Node.js projects:
import { createServer, mcpConfig, validateConfig } from 'supabase-mcp';
// Validate configuration
validateConfig();
// Create the server
const app = createServer();
// Start the server
app.listen(mcpConfig.port, mcpConfig.host, () => {
console.log(`Supabase MCP server running at http://${mcpConfig.host}:${mcpConfig.port}`);
});
The HTTP server attempts to find an available port automatically. You can manually specify a different port in your .env file by changing the MCP_SERVER_PORT value.
Make sure you have a proper .env file with all the required values or that you've set the environment variables in your system.
If you see this error, you may be running an older version of the package. Update to the latest version:
npm install -g supabase-mcp@latest
Make sure you're using the Claude-specific binary (supabase-mcp-claude) instead of the regular HTTP server (supabase-mcp).
This usually means Claude initiated the connection but the server was unable to respond in time. Check:
queryDatabase
table (string): Name of the table to queryselect (string, optional): Comma-separated list of columns (default: "*")query (object, optional): Filter conditionsinsertData
table (string): Name of the tabledata (object or array of objects): Data to insertupdateData
table (string): Name of the tabledata (object): Data to update as key-value pairsquery (object): Filter conditions for the updatedeleteData
table (string): Name of the tablequery (object): Filter conditions for deletionlistTables
MIT
Supabase Model Context Protocol (MCP) server for CRUD operations and Edge Functions
{ "mcpServers": { "cappahccino-sb-mcp": { "command": "npx", "args": [ "-y", "[email protected]" ] } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
SB 透過 stdio 在本機執行。
上次檢查時間:2026-10-26。 Supabase Model Context Protocol (MCP) server for CRUD operations and Edge Functions