coleam00/supabase-mcp

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
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
1. Clone the repository:
bash
git clone https://github.com/coleam00/supabase-mcp.git
cd supabase-mcp
### Docker Setup
1. Build the Docker image:
bash
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.
1. Include the below configuration in your MCP config (in Claude Desktop, Windsurf, etc.)
Be sure to build the container with the installation steps first!
json
"mcpServers": {
"supabase": {
"command": "docker",
"args": ["run", "--rm", "-i", "-e", "SUPABASEURL", "-e", "SUPABASESERVICEKEY", "mcp/supabase"],
"env": {
"SUPABASEURL": "YOUR-SUPABASE-URL",
"SUPABASESERVICEKEY": "YOUR-SUPABASE-SERVICE-ROLE-KEY"
2. Replace YOUR-SUPABASE-URL and YOUR-SUPABASE-SERVICE-ROLE-KEY with your actual Supabase credentials.
3. The AI assistant can now access the Supabase database through the MCP server using the provided tools.
For more information on the Model Context Protocol, visit modelcontextprotocol.io.
### Available Tools
#### Read Table Rows
python
readtablerows(
tablename: str,
columns: Optional[List[str]] = None,
filters: Optional[Dict[str, Any]] = None,
limit: Optional[int] = None,
offset: Optional[int] = None
Example:
python
# Read active users
readtablerows(
tablename="users",
columns=["id", "name", "email"],
filters={"isactive": True},
limit=10,
offset=0
#### Create Table Records
python
createtablerecords(
tablename: str,
records: Union[Dict[str, Any], List[Dict[str, Any]]]
Example:
python
# Create a new user
createtablerecords(
tablename="users",
records={
"name": "John Doe",
"email": "john@example.com",
"isactive": True
#### Update Table Records
python
updatetablerecords(
tablename: str,
updates: Dict[str, Any],
filters: Dict[str, Any]
Example:
python
# Update user status
updatetablerecords(
tablename="users",
updates={"status": "premium"},
filters={"isactive": True}
#### Delete Table Records
python
deletetablerecords(
tablename: str,
filters: Dict[str, Any]
Example:
python
# Delete inactive users
deletetablerecords(
tablename="users",
filters={"isactive": False}
## Development
### Project Structure
supabase-mcp/
├── supabasemcp/
│ ├── init.py
│ ├── server.py # Main MCP server implementation
│ └── tests/ # Unit tests
├── Dockerfile # Docker configuration for MCP server