Claude Desktop Gateway MCP Server

Developer ToolsTypeScript

A gateway that bridges Claude Desktop to HTTP SSE endpoints

Available Tools

query

Run a read-only SQL query on a DuckDB database

sql

visualise

Visualise SQL query results as an Apache ECharts chart. Provide the SQL clause that produces the data for the visualisation. Provide chart JSON configuration for Apache ECharts.

sqlchart

This MCP provides a bridge from Claude Desktop's stdio interface to HTTP Server-Sent Events (SSE) endpoints. It enables Claude Desktop to connect to remote servers that implement the Model Context Protocol over HTTP SSE transport, expanding Claude's capabilities beyond local tools. The gateway acts as a middleware that translates between the stdio transport used by Claude Desktop and the HTTP SSE transport used by remote MCP servers.

Overview

The MCP Gateway allows Claude Desktop to communicate with remote MCP servers using HTTP Server-Sent Events (SSE). This is particularly useful since Claude Desktop doesn't natively support connecting to remote servers.

Installation

You can install the gateway globally using npm:

npm install -g mcp-server-and-gw

Alternatively, you can run it directly with npx without installing:

npx mcp-server-and-gw http://localhost:8808/

Configuration

To use the gateway with Claude Desktop, you need to update the Claude Desktop configuration file. Add the following to your configuration:

Navigate to your Claude Desktop configuration file:
- On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
- On Windows: %APPDATA%\Claude\claude_desktop_config.json
Add the gateway configuration:

{
  "mcpServers": {
    "Claude Gateway Example": {
      "command": "npx",
      "args": [
        "mcp-server-and-gw", "http://localhost:8808/"
      ]
    }
  }
}

Make sure that npx is in your PATH, or use the full path to npx (e.g., /opt/homebrew/bin/npx).

Usage

Start your MCP server that implements the HTTP SSE transport. For example:
```
PORT=8808 node your-mcp-server.js
```
Start Claude Desktop. It will automatically connect to your server through the gateway.

Environment Variables

You can configure the gateway using environment variables:

MCP_HOST: The host of the MCP server (default: localhost)
MCP_PORT: The port of the MCP server (default: 8808)

Example:

MCP_HOST=example.com MCP_PORT=9000 npx mcp-server-and-gw

Testing

For development and testing purposes, you can use the MCP Inspector:

npx @modelcontextprotocol/inspector node ./build/mcp-server-and-gw.js

This allows you to test the gateway without needing to start Claude Desktop.