What is Supabase MCP Server?
The Supabase MCP Server is a backend application that provides a RESTful API for interacting with a Supabase database. It follows the Model-Controller-Persistence pattern, offering endpoints for common database operations.
How to use Supabase MCP Server?
To use the server, first clone the repository and install the dependencies using npm install. Configure your Supabase credentials in the .env file. You can then run the server locally using npm start. Alternatively, you can deploy the server to Smithery using their CLI, configuring the necessary environment variables.
Key features of Supabase MCP Server
Data querying from tables
Retrieval of specific records
Data insertion
Data updating
Use cases of Supabase MCP Server
Building RESTful APIs on top of Supabase
Creating custom data access layers
Simplifying database interactions for frontend applications
Integrating Supabase with other services
FAQ from Supabase MCP Server
How do I list all records from a table?
How do I list all records from a table?
Use the GET /api/:table endpoint.
How do I get a specific record by ID?
How do I get a specific record by ID?
Use the GET /api/:table/:id endpoint.
How do I insert a new record?
How do I insert a new record?
Use the POST /api/:table endpoint with the data in the request body.
How do I update an existing record?
How do I update an existing record?
Use the PATCH /api/:table/:id endpoint with the data to update in the request body.
What environment variables are required?
What environment variables are required?
SUPABASE_URL and SUPABASE_KEY are required.