N8N2MCP

📦 Installation

Prerequisites

• Python 3.11+
• N8N Instance (cloud.n8n.io or self-hosted)
• Supabase Account (for data storage)
• Playwright (required for N8N authentication)
• Docker (optional, for containerized deployment)

⚠️ Important: Playwright installation is required for N8N workflow execution. The system will use dummy credentials if Playwright is not properly installed, limiting functionality.

Quick Start

Option 1: Docker Compose (Recommended)

1. Clone the repository

   git clone https://github.com/Super-Chain/N8N2MCP.git
   cd N8N2MCP
   

2. Configure environment

   cp env.example .env
   # Edit .env with your actual configuration values
   

3. Start with Docker Compose

   docker-compose up -d
   

   This starts:

   • Flask App (Agent Marketplace) at: http://localhost:5000
   • MCP Router at: http://localhost:6545

4. View logs

   docker-compose logs -f
   

Option 2: Manual Installation

1. Clone the repository

   git clone https://github.com/Super-Chain/N8N2MCP.git
   cd N8N2MCP
   

2. Install dependencies

   pip install -r requirements.txt
   

3. Install Playwright browsers (Required)

   playwright install
   # This downloads the necessary browser binaries for N8N authentication
   

4. Configure environment

   # Copy and edit the .env file (see Environment Configuration section)
   cp .env.example .env
   

   # Supabase Configuration
   SUPABASE_URL=https://your-project-id.supabase.co
   SUPABASE_KEY=your_supabase_anon_key
   SUPABASE_SERVICE_KEY=your_supabase_service_role_key
   
   # N8N Configuration
   X_N8N_API_KEY=your_n8n_api_key
   N8N_BASE_URL=https://your-n8n-instance.com
   N8N_USERNAME=your_n8n_username
   N8N_PASSWORD=your_n8n_password
   
   # MCP Router Configuration
   N8N_BUILDER_URL=http://localhost:6545
   
   # Server Configuration
   FLASK_HOST=0.0.0.0
   FLASK_PORT=5000
   MCP_HOST=0.0.0.0
   MCP_PORT=6545
   
   # Optional: Authentication credentials (auto-populated)
   N8N_AUTH=
   N8N_BROWSER_ID=   
   

5. Start both servers

   python main.py
   

   This starts:

   • Flask App (Agent Marketplace) at: http://localhost:5000
   • MCP Router at: http://localhost:6545

6. Access to UI Front end : http://localhost:5000

Configuration Notes:

• SUPABASE_URL: Your Supabase project URL
• SUPABASE_KEY: Anon key for client-side operations
• SUPABASE_SERVICE_KEY: Service role key for admin operations
• N8N_BASE_URL: Your N8N instance URL (must include https://)
• N8N_BUILDER_URL: Must include http:// protocol

🔧 Usage

Creating MCP Servers from N8N Workflows

Method 1: Import N8N Templates

1. Browse Templates: Visit the N8N template
2. Import Template: Enter an N8N template URL from n8n.io
3. Configure Credentials: Fill in required API keys and service credentials
4. Deploy Workflow: Click deploy to create the workflow in your N8N instance
5. MCP Server Created: Automatically generates an MCP server endpoint

Method 2: Upload Custom Workflows

1. Upload JSON: Upload your N8N workflow JSON file / Copy and paste your JSON workflow
2. Review Analysis: Check detected nodes and required credentials
3. Configure & Deploy: Fill credentials and deploy to N8N
4. Access MCP Server: Use the generated MCP endpoint in AI tools

Using MCP Servers

# Example MCP server URL format:
http://localhost:6545/mcp/{workflow_id}/{api_key}

# Test MCP server:
curl http://localhost:6545/list  # List all registered MCP servers

🎨 Use Cases

🔍 Data Processing & Analysis

• Transform CSV/Excel files using N8N's data manipulation nodes
• Connect to databases and APIs for real-time data analysis
• Generate reports and visualizations from AI conversations

🌐 API Integration Hub

• Connect AI assistants to external services (Slack, Google, etc.)
• Create custom API endpoints for proprietary systems
• Build unified interfaces for multiple SaaS platforms

📧 Communication & Notifications

• Send emails, Slack messages, or Discord notifications
• Create automated reporting systems
• Build alert systems triggered by AI interactions

🔄 Workflow Automation

• Trigger complex business processes from AI conversations
• Create approval workflows and task management systems
• Build custom integrations with enterprise systems

🛠️ Development

Project Structure

N8N2MCP/
├── main.py                        # Unified server startup script
├── requirements.txt               # Consolidated Python dependencies
├── .env                          # Environment configuration (shared)
│
├── agent_marketplace/             # Flask web application
│   ├── app.py                    # Main Flask app with API endpoints
│   ├── database.py               # Supabase integration & data models
│   ├── n8n_workflow_parser.py    # Workflow analysis engine
│   ├── setup_supabase.py         # Database setup utilities
│   ├── templates/                # HTML templates
│   │   ├── workflows.html        # Main marketplace interface
│   │   └── static/               # CSS, JS assets
│   └── __init__.py               # Python package marker
│
├── mcp_router/                   # FastAPI MCP service
│   ├── mcp_router.py             # Main FastAPI application
│   ├── n8n_credential_extractor.py # N8N authentication
│   ├── credential_helper.py       # Credential management utilities
│   └── __init__.py               # Python package marker
│
└── README.md                     # This documentation

Database Setup

The system uses 2 main tables in Supabase:

Setup

1. Create Supabase Project: Set up a new project at supabase.com
2. Run SQL in Supabase SQL Editor:

-- Main workflow storage table
CREATE TABLE IF NOT EXISTS public.user_workflows (
    id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
    user_id TEXT NOT NULL,
    template_id TEXT NOT NULL,
    template_url TEXT NOT NULL,
    workflow_name TEXT NOT NULL,
    workflow_json JSONB NOT NULL,
    workflow_description TEXT,
    n8n_workflow_id TEXT,
    source TEXT DEFAULT 'user_upload',
    credentials_required JSONB DEFAULT '[]'::jsonb,
    mcp_link TEXT,
    status TEXT DEFAULT 'pending',
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- MCP server configurations
CREATE TABLE IF NOT EXISTS public.mcp_configs (
    id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
    workflow_id TEXT NOT NULL,
    user_apikey TEXT NOT NULL,
    code TEXT NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    UNIQUE(workflow_id, user_apikey)
);

-- Enable Row Level Security (recommended)
ALTER TABLE user_workflows ENABLE ROW LEVEL SECURITY;
ALTER TABLE mcp_configs ENABLE ROW LEVEL SECURITY;

🚀 Running the System

Unified Startup (Recommended)

python main.py

This automatically starts both services with:

• ✅ Environment validation
• ✅ Database setup verification
• ✅ Graceful shutdown handling
• ✅ Centraliz