Supabase MCP Server
by haladesigns
The Supabase MCP Server provides AI assistants with standardized tools to interact with Supabase databases. It enables reading, creating, updating, and deleting records within Supabase.
Last updated: N/A
What is Supabase MCP Server?
A Model Context Protocol (MCP) server that allows AI assistants to interact with Supabase databases through a set of standardized tools.
How to use Supabase MCP Server?
- Clone the repository. 2. Set up a virtual environment and install dependencies. 3. Configure environment variables (Supabase URL and Service Key). 4. Run the server using
python -m supabase_mcp.server. Use the available tools (read_rows, create_records, update_records, delete_records) by sending appropriately formatted JSON payloads to the server.
Key features of Supabase MCP Server
Read rows with filtering and column selection
Create single or multiple records
Update records with flexible filtering
Delete records safely with filter conditions
Environment-based configuration
Stdio transport support
Use cases of Supabase MCP Server
Allowing AI assistants to fetch user data from Supabase
Enabling AI to create new user accounts
Updating user profiles based on AI analysis
Deleting inactive user accounts via AI command
Integrating Supabase data into AI-powered workflows
FAQ from Supabase MCP Server
What is the service role key used for?
What is the service role key used for?
The service role key is used for performing database operations with elevated privileges, bypassing Row Level Security (RLS).
How do I configure the Supabase URL?
How do I configure the Supabase URL?
The Supabase URL should be set as the SUPABASE_URL environment variable in a .env file.
What kind of filtering is supported?
What kind of filtering is supported?
The filtering supports equality checks and can be extended to support more complex conditions using Supabase's filtering capabilities.
How are inputs validated?
How are inputs validated?
All inputs are validated using Pydantic models to ensure data integrity and prevent security vulnerabilities.
What is the license of this project?
What is the license of this project?
The project is licensed under the MIT License.