SupaMCPBuilder

A runtime-configurable MCP (Model Context Protocol) server for Supabase databases with inline JSON configuration support. Build dynamic tools for your Supabase database without writing code!

Features

• 🚀 Zero Configuration: Works out of the box with any Supabase project
• 🔧 Runtime Configurable: Define tools using JSON configuration
• 🔐 Built-in Authentication: Automatic JWT token refresh and session management
• 📊 Dynamic Tool Generation: Create custom database operations via JSON
• 🎯 Template Support: Use Jinja2-style templates in your configurations
• 🔄 Base64 Support: Handle complex JSON configurations safely

Quick Start

Using with npx (Recommended)

npx supamcpbuilder --url YOUR_SUPABASE_URL --anon-key YOUR_ANON_KEY --email YOUR_EMAIL --password YOUR_PASSWORD --tools-json-base64 BASE64_ENCODED_TOOLS

Installation

npm install -g supamcpbuilder

Configuration Options

Basic Usage

supamcpbuilder \
  --url "https://your-project.supabase.co" \
  --anon-key "your-anon-key" \
  --email "[email protected]" \
  --password "your-password"

With JSON Configuration File

supamcpbuilder \
  --url "https://your-project.supabase.co" \
  --anon-key "your-anon-key" \
  --email "[email protected]" \
  --password "your-password" \
  --config-path "./tools-config.json"

With Base64 Encoded Tools

supamcpbuilder \
  --url "https://your-project.supabase.co" \
  --anon-key "your-anon-key" \
  --email "[email protected]" \
  --password "your-password" \
  --tools-json-base64 "W3sibmFtZSI6Imxpc3QtdXNlcnMiLCJkZXNjcmlwdGlvbiI6Ikxpc3QgYWxsIHVzZXJzIn1d"

Tool Configuration Format

Basic Tool Structure

[
  {
    "name": "list-users",
    "description": "List all users from the users table",
    "parameters": {
      "type": "object",
      "properties": {
        "limit": {
          "type": "number",
          "description": "Number of users to return",
          "default": 10
        }
      }
    },
    "action": {
      "type": "select",
      "table": "users",
      "columns": ["id", "name", "email"],
      "limit": "{{limit}}"
    }
  }
]

Supported Action Types

• select: Query data from tables
• insert: Create new records
• update: Modify existing records
• delete: Remove records

Template Variables

Use Jinja2-style templates in your configurations:

{
  "action": {
    "type": "select",
    "table": "{{table_name}}",
    "filters": {
      "id": "{{user_id}}"
    }
  }
}

MCP Client Configuration

Cursor IDE Configuration

Add to your ~/.cursor/mcp.json:

{
  "mcpServers": {
    "supamcpbuilder": {
      "command": "npx",
      "args": [
        "-y",
        "supamcpbuilder",
        "--url", "https://your-project.supabase.co",
        "--anon-key", "your-anon-key",
        "--email", "[email protected]",