Skip to main content
Glama
Zain4391

Supabase Management API MCP Server

by Zain4391

Supabase Management API MCP Server

An MCP (Model Context Protocol) server for the Supabase Management API. This server enables AI assistants like Claude to interact with Supabase projects programmatically.

πŸ”§ Available Tools

  • list_all_projects - Returns a list of all your Supabase projects

  • gets_all_projects_for_the_given_organization - Get projects for a specific organization

  • create_a_project - Create a new Supabase project

  • lists_sql_snippets_for_the_logged_in_user - List SQL snippets for a project

  • beta_authorize_user_through_oauth - OAuth authorization

  • beta_exchange_auth_code_for_users_access_and_refresh_token - Exchange OAuth code for tokens

🚦 Getting Started

βš™οΈ Prerequisites

Before starting, please ensure you have:

Warning: if you run with a lower version of Node, fetch won't be present. Tools use fetch to make HTTP calls. To work around this, you can modify the tools to use node-fetch instead. Make sure that node-fetch is installed as a dependency and then import it as fetch into each tool file.

πŸ“₯ Installation & Setup

1. Install dependencies

npm install

2. Configure Supabase API credentials

Create a .env file in the project root:

SUPABASE_PUBLIC_API_API_KEY=your_personal_access_token_here

To get your Supabase Personal Access Token:

  1. Go to Supabase Dashboard

  2. Click your profile β†’ Account Settings

  3. Navigate to "Access Tokens"

  4. Generate a new Personal Access Token

  5. Copy the token and add it to your .env file

Important: Use a Personal Access Token (JWT format), not a project API key or secret key.

🌐 Test the MCP Server with Postman

The MCP Server (mcpServer.js) exposes your automated API tools to MCP-compatible clients, such as Claude Desktop or the Postman Desktop Application. We recommend that you test the server with Postman first and then move on to using it with an LLM.

The Postman Desktop Application is the easiest way to run and test MCP servers. Testing the downloaded server first is optional but recommended.

Step 1: Download the latest Postman Desktop Application from https://www.postman.com/downloads/.

Step 2: Read out the documentation article here and see how to create an MCP request inside the Postman app.

Step 3: Set the type of the MCP request to STDIO and set the command to node </absolute/path/to/mcpServer.js>. If you have issues with using only node (e.g. an old version is used), supply an absolute path instead to a node version 18+. You can get the full path to node by running:

which node

To check the node version, run:

node --version

To get the absolute path to mcpServer.js, run:

realpath mcpServer.js

Use the node command followed by the full path to mcpServer.js as the command for your new Postman MCP Request. Then click the Connect button. You should see a list of tools that you selected before generating the server. You can test that each tool works here before connecting the MCP server to an LLM.

πŸ‘©β€πŸ’» Connect the MCP Server to Claude

You can connect your MCP server to any MCP client. Here we provide instructions for connecting it to Claude Desktop.

Step 1: Note the full path to node and the mcpServer.js from the previous step.

Step 2. Open Claude Desktop β†’ Settings β†’ Developers β†’ Edit Config and add this server:

{ "mcpServers": { "supabase-management": { "command": "node", "args": ["/absolute/path/to/mcpServer.js"] } } }

Replace /absolute/path/to/ with the actual path to this project.

Restart Claude Desktop to activate this change. Make sure the new MCP is turned on and has a green circle next to it. If so, you're ready to begin a chat session that can use the tools you've connected.

Warning: If you don't supply an absolute path to a node version that is v18+, Claude (and other MCP clients) may fall back to another node version on the system of a previous version. In this case, the fetch API won't be present and tool calls will not work. If that happens, you can a) install a newer version of node and point to it in the command, or b) import node-fetch into each tool as fetch, making sure to also add the node-fetch dependency to your package.json.

Additional Options

🐳 Docker Deployment (Production)

For production deployments, you can use Docker:

1. Build Docker image

docker build -t <your_server_name> .

2. Claude Desktop Integration

Add Docker server configuration to Claude Desktop (Settings β†’ Developers β†’ Edit Config):

{ "mcpServers": { "<your_server_name>": { "command": "docker", "args": ["run", "-i", "--rm", "--env-file=.env", "<your_server_name>"] } } }

Add your environment variables (API keys, etc.) inside the .env file.

The project comes bundled with the following minimal Docker setup:

FROM node:22.12-alpine AS builder WORKDIR /app COPY package.json package-lock.json ./ RUN npm install COPY . . ENTRYPOINT ["node", "mcpServer.js"]

🌐 Streamable HTTP

To run the server with Streamable HTTP support, use the --streamable-http flag. This launches the server with the /mcp endpoint enabled:

node mcpServer.js --streamable-http

🌐 Server-Sent Events (SSE)

To run the server with Server-Sent Events (SSE) support, use the --sse flag. This launches the server with the /sse and /messages endpoints enabled:

node mcpServer.js --sse

πŸ–₯️ Stdio (Standard Input/Output)

To run the server using standard input/output (stdio), simply run the script without any flags. This mode is ideal for CLI tools or programmatic integration via stdin and stdout.

node mcpServer.js

πŸ› οΈ Additional CLI commands

List tools

List descriptions and parameters from all generated tools with:

node index.js tools

Example:

Available Tools: Workspace: acme-workspace Collection: useful-api list_all_customers Description: Retrieve a list of useful things. Parameters: - magic: The required magic power - limit: Number of results returned [...additional parameters...]

πŸ“ License

MIT

πŸ™ Acknowledgments

This project was generated using the Postman MCP Generator.

-
security - not tested
F
license - not found
-
quality - not tested

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Zain4391/Supabase_MCP'

If you have feedback or need assistance with the MCP directory API, please join our Discord server