🐳 Supabase MCP HTTP Stream Server for n8n

One-Click Docker deployment of Supabase MCP Server with native HTTP Stream Transport support for n8n, AI Agents, and modern automation workflows.

🚀 Quick Start

🌊 Coolify Deployment (Production)

For production deployment on Coolify, follow these detailed steps:

Step 1: Create Resource in Coolify

1. Navigate to your Coolify dashboard

2. Go to Projects → Select your project (e.g., "My first project")

3. Click "Add Resource" → "Docker Compose"

4. Choose "From GIT Repository" or "Raw Docker Compose"

Step 2: Configure Docker Compose

Option A: From GIT Repository

• Repository: https://github.com/BIFROTEK-com/supabase-mcp-http-stream-n8n.git

• Branch: main

• Docker Compose Location: docker/docker-compose.coolify.yaml

Option B: Raw Docker Compose Copy the content from docker/docker-compose.coolify.yaml

Step 3: Set Environment Variables

Configure these required environment variables in Coolify:

Step 4: Configure Domain & Traefik

1. Resource Name: supabase-mcp (or your preferred name)

2. Domain Configuration: https://your.domain.com:3333

   • ✅ Format: https://your-domain.com:3333

   • ✅ Port: Must be 3333 (the container port)

   • ✅ Protocol: Use https for SSL termination via Traefik

Step 5: Deploy

1. Save Configuration

2. Click "Deploy"

3. Monitor Logs for successful startup:

   ✅ MCP HTTP Server running on port 3333 🚀 Streamable HTTP: POST /mcp 🌊 SSE: GET/POST /sse ❤️ Health: GET /health 🏠 Landing: GET / 🔗 Ready for connections!

Step 6: Verify Deployment

Test your deployed instance using the API Examples below.

Related MCP server: Supabase MCP Server

🐳 Local Development

1. Clone the repository:

2. Create

3. Start the server:

4. Test the connection: See API Examples below

🔌 API Endpoints

🚀 HTTP Stream Transport (Recommended)

The modern MCP transport using HTTP streaming for real-time communication:

Example Usage:

🌊 SSE Transport (n8n Compatible)

Server-Sent Events transport for legacy n8n MCP Client Tool Node compatibility:

SSE Features:

• ✅ Auto Session Management - Secure crypto-based session IDs

• ✅ Keep-Alive Pings - 15-second intervals for connection stability

• ✅ n8n Compatibility - Works with n8n MCP Client Tool Node

• ✅ Automatic Cleanup - Sessions auto-terminate on disconnect

SSE Connection Flow:

1. Connect: GET /sse establishes SSE stream

2. Receive: Server sends endpoint event with sessionId

3. Send Messages: POST /messages?sessionId=<session>

4. Keep-Alive: Server pings every 15 seconds

5. Disconnect: Automatic cleanup on connection close

Example Usage:

🛡️ Security Features

• ✅ API Key Authentication: Secure access control

• ✅ Rate Limiting: DoS protection (configurable)

• ✅ CORS Protection: Configurable origin restrictions

• ✅ Security Headers: Helmet.js with CSP

• ✅ Input Validation: JSON-RPC 2.0 validation

• ✅ SSL/TLS: HTTPS support via Traefik

📊 MCP Tools Available

🔧 Configuration

Environment Variables

Feature Groups

Enable specific features by setting MCP_FEATURES:

• database - Database operations (tables, SQL, migrations)

• docs - Supabase documentation search

• development - Development tools and utilities

• functions - Edge Functions management

• account - Account management (requires no project scoping)

• branching - Database branching operations

• storage - Storage management

• debug - Debugging tools

🔄 n8n Integration

⚠️ Important: Built-in MCP Node Issues

The built-in n8n MCP Client node has known issues with SSE Stream Transport (Deprecated) and may not work reliably with this server. For the best experience, we strongly recommend using the community-developed MCP Client node instead.

🌟 Recommended: Community MCP Node

Use the community node: @nerding-io/n8n-nodes-mcp

This community node provides:

• ✅ Full HTTP Stream Transport support (recommended)

• ✅ Reliable SSE Transport for legacy compatibility

• ✅ Better error handling and connection stability

• ✅ Active maintenance and community support

• ✅ AI Agent integration as a tool

📦 Installation

1. Install the community node in your n8n instance:

   # Via n8n UI: Settings → Community Nodes → Install # Package name: @nerding-io/n8n-nodes-mcp # Or via Docker environment: N8N_COMMUNITY_PACKAGES_ENABLED=true

2. Enable community nodes as tools (for AI Agents):

   # Required for using MCP Client as AI Agent tool N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=true

🚀 Configuration with HTTP Stream Transport

Recommended Setup:

1. Create HTTP Streamable Credentials:

   • Base URL: https://your.domain.com:3333/mcp

   • API Key: Your configured API key

   • Transport: HTTP Streamable

2. Add MCP Client Node:

   • Connection Type: HTTP Streamable

   • Operation: List Tools / Execute Tool

   • Select your credentials

3. Example Tool Execution:

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

🌊 Legacy SSE Configuration (if needed)

Only if HTTP Stream doesn't work:

1. Create SSE Credentials:

   • SSE URL: https://your.domain.com:3333/sse

   • Connection Type: Server-Sent Events (SSE)

   • Headers: X-API-Key: your-api-key

2. Configure Node:

   • Connection Type: Server-Sent Events (SSE)

   • Select your SSE credentials

Note: SSE is deprecated but maintained for compatibility. Always try HTTP Stream first.

🤖 AI Agent Integration

The community MCP node works perfectly as an AI Agent tool:

Docker Configuration for AI Agents:

🎯 Use Cases

• Database Management: Query and manage Supabase databases

• AI Agents: Provide database access to AI assistants

• Automation: Integrate with n8n workflows

• Documentation: Search Supabase docs programmatically

• Edge Functions: Deploy and manage serverless functions

• Data Analysis: Execute complex SQL queries

• Schema Management: Handle database migrations

🔗 Related Projects

• MCP Framework - Model Context Protocol

• Supabase - Open source Firebase alternative

• n8n - Workflow automation platform

• Coolify - Self-hosted Heroku alternative

📝 License

MIT License - see LICENSE file for details.

🤝 Contributing

1. Fork the repository

2. Create a feature branch

3. Make your changes

4. Add tests if applicable

5. Submit a pull request

🆘 Support

• GitHub Issues: Report bugs or request features

• Documentation: MCP Framework Docs

• Supabase: Official Documentation

Made with ❤️ by