概要
What is Supabase MCP Server?
A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database, enabling AI assistants to perform database operations through a standardized interface. It is a demonstration project, work in progress.
How to use Supabase MCP Server?
Clone the repository, build the Docker image with docker build -t mcp/supabase ., then configure your MCP client (e.g., Claude Desktop, Windsurf) with the provided JSON config, setting SUPABASE_URL and SUPABASE_SERVICE_KEY environment variables. The server runs via Docker and exposes four tools: read_table_rows, create_table_records, update_table_records, delete_table_records.
Key features of Supabase MCP Server
- Read table rows with optional filtering, pagination, and column selection
- Create new records into Supabase tables
- Update existing records based on filters
- Delete records based on filters
- Runs as a Docker container for easy integration
- Uses the Model Context Protocol for AI assistant communication
Use cases of Supabase MCP Server
- AI assistant querying user data with filters and pagination
- Automatically inserting new records from natural language requests
- Updating record status fields (e.g., setting users to “premium”)
- Removing inactive or outdated records from a table
FAQ from Supabase MCP Server
What prerequisites are needed?
Docker or Docker Desktop, a Supabase account, and a Supabase project with a service role key.
How do I install and run the server?
Clone the repo, build the Docker image (docker build -t mcp/supabase .), then add the MCP configuration to your assistant’s config file with your Supabase credentials.
What database operations does it support?
Read, create, update, and delete operations on Supabase tables, each exposed as a separate MCP tool.
Is this server production-ready?
No – the README states it is a demonstration and still a work in progress.
How are credentials provided?
Via the environment variables SUPABASE_URL and SUPABASE_SERVICE_KEY, passed to the Docker container in the MCP configuration.
