Servidor MCP Do Supabase

🚀 Supabase Server MCP

This is an MCP (Model-Controller-Persistence) server that provides RESTful APIs for interacting with Supabase.

✨ Features

• Query table data
• Query specific records
• Insert data
• Update data

📦 Installation

Local Configuration

1. Clone the repository.
2. Install dependencies:

   npm install
   

3. Copy the .env.example file and rename it to .env, then fill in your Supabase credentials:

   cp .env.example .env
   

Deployment on Smithery

1. Install the Smithery CLI:

   npm install -g @smithery/cli
   

2. Log in to your Smithery account:

   smithery login
   

3. Initialize the deployment in the project directory:

   smithery deploy
   

4. Configure environment variables in the Smithery control panel:
   • SUPABASE_URL: The URL of your Supabase project.
   • SUPABASE_KEY: The API key of your Supabase project.
5. After deployment, your server will be available under the domain provided by Smithery.

💻 Usage Examples

Local Usage

To start the server locally:

npm start

API Endpoints

• GET /api/:table - List all records in the table.
  • Query parameters:
    • select: Fields to return (optional).
• GET /api/:table/:id - Get a specific record by ID.
• POST /api/:table - Insert a new record.
  • Request body: An object containing the data to be inserted.
• PATCH /api/:table/:id - Update an existing record.
  • Request body: An object containing the fields to be updated.

Basic Usage

List all records in the table

curl http://localhost:3000/api/users

List records with specific fields

curl http://localhost:3000/api/users?select=id,name,email

Advanced Usage

Get a specific record

curl http://localhost:3000/api/users/123

Insert a new record

curl -X POST http://localhost:3000/api/users \
  -H "Content-Type: application/json" \
  -d '{"name": "João", "email": "joao@exemplo.com"}'

Update a record

curl -X PATCH http://localhost:3000/api/users/123 \
  -H "Content-Type: application/json" \
  -d '{"name": "João Silva"}'

📚 Documentation

Monitoring on Smithery

After deployment, you can monitor your server through the Smithery control panel:

1. Access the Smithery control panel.
2. Navigate to your project.
3. View:
   • Real-time logs
   • Usage metrics
   • Server status
   • Environment variables