Happy slice of mcp pizzaMCP.pizza

supabase-mcp

MCP.Pizza Chef: coleam00

Four tools cover the basics of a table: reading rows, adding records, updating everything that matches a condition, and deleting the same way. Matching is exact-value only, so you cannot ask for orders above a certain amount or names containing a word. The paging mentioned in the README was never built either, though you can cap how many rows come back. Setup runs through Docker and needs your project's service key, which has full administrator power and ignores the access rules you set on your tables.

Unmaintained · no code changes since March 2025
Data

Use This MCP server To

Look up rows in a table without opening the dashboard Add a batch of new records to a table Update every record that matches one exact value Delete records matching a condition I describe Pull the ten newest rows sorted by date Check what a table holds before writing a report

README

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

  • 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: 
    git clone https://github.com/coleam00/supabase-mcp.git
cd supabase-mcp

Docker Setup

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

supabase-mcp FAQ

Can I use this to fix a wrong value across many rows at once?
Yes. The update tool changes every record matching the condition you give, and delete works the same way. Neither asks you to confirm first, so check your condition carefully.
Do I need a key?
Yes, and it is the sensitive one. It needs your Supabase project's service key, which has full administrator power and bypasses the access rules protecting your tables. Do not use it on a shared computer.
Can I filter by greater than, or by text containing a word?
No. Filters match exact values only, so ranges, partial text, and date comparisons are out. Pull a sorted batch of rows and narrow it in conversation instead.
Does it page through a large table?
No, despite what the README lists as a feature. You can limit how many rows come back, but there is no way to fetch the next page after that.
Which apps does it work in?
Claude Desktop and Windsurf have documented setup steps, plus any other app that supports MCP servers.
How hard is setup?
Harder than most. You download the project and build a Docker image yourself, then paste a config block holding your project address and service key.
Is this ready for real business use?
The author describes it as a work in progress built to demonstrate a coding workflow, and there have been no code changes since March 2025. Treat it as a starting point rather than a finished product.