supabase-mcp-http-stream-n8n

BIFROTEK-com/supabase-mcp-http-stream-n8n

3.3

If you are the rightful owner of supabase-mcp-http-stream-n8n and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Supabase MCP HTTP Stream Server for n8n is a robust solution designed for seamless integration with modern automation workflows, AI agents, and n8n, leveraging the Model Context Protocol (MCP) with HTTP Stream Transport.

The Supabase MCP HTTP Stream Server for n8n offers a streamlined and efficient way to manage and automate workflows by integrating Supabase's powerful database capabilities with n8n's automation platform. This server is designed to facilitate seamless communication and data exchange between different systems using the Model Context Protocol (MCP) with HTTP Stream Transport. It supports a wide range of features, including database management, documentation search, and edge function deployment, making it an ideal choice for developers and businesses looking to enhance their automation capabilities. With its one-click Docker deployment, users can quickly set up and configure the server, ensuring a smooth and hassle-free experience. The server also includes robust security features such as API key authentication, rate limiting, and CORS protection, ensuring that your data and operations remain secure.

Features

  • One-Click Docker Deployment: Quickly deploy the server with minimal setup.
  • HTTP Stream Transport: Supports efficient data streaming for real-time applications.
  • Comprehensive Security: Includes API key authentication, rate limiting, and CORS protection.
  • Integration with n8n: Seamlessly integrates with n8n for enhanced automation workflows.
  • Extensive MCP Tools: Offers a variety of tools for database management, documentation search, and more.

Usages

coolify deployment

yaml
version: '3'
services:
  supabase-mcp:
    image: silverstar3o7/supabase-mcp-http-stream-n8n
    environment:
      - SUPABASE_ACCESS_TOKEN=sbp_your_access_token_here
      - SUPABASE_PROJECT_REF=your_project_ref_here
      - MCP_API_KEYS=your-secure-api-key-here
      - DOMAIN=your.domain.com
      - MCP_FEATURES=database,docs,development,functions
      - MCP_READ_ONLY=false
      - MCP_PORT=3333
      - NODE_ENV=production
      - MCP_RATE_LIMIT_REQUESTS=100
      - MCP_RATE_LIMIT_GENERAL=60
      - MCP_ALLOWED_ORIGINS=*
      - NODE_LOG_LEVEL=warn
    ports:
      - "3333:3333"

local development

bash
git clone https://github.com/BIFROTEK-com/supabase-mcp-http-stream-n8n.git
cd supabase-mcp-http-stream-n8n
cp env.example .env
# Edit .env with your Supabase credentials
cd docker && docker-compose up -d

n8n integration http stream

{
  "tool": "list_tables",
  "parameters": {}
}

n8n integration sse

bash
# 1. Establish SSE connection
curl -N -H "Accept: text/event-stream" https://your-domain.com:3333/sse

# Server responds:
# event: endpoint
# data: /messages?sessionId=abc123...
# data: {"type":"ready","status":"connected","session":"abc123..."}

# 2. Send messages via returned sessionId
curl -X POST https://your-domain.com:3333/messages?sessionId=abc123... \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc": "2.0", "id": 1, "method": "tools/list"}'

Tools

  1. list_tables

    Lists all database tables

  2. list_extensions

    Lists database extensions

  3. execute_sql

    Execute raw SQL queries

  4. apply_migration

    Apply database migrations

  5. search_docs

    Search Supabase documentation