@multitravel/mcp-server

Corporate Model Context Protocol (MCP) server for secure MySQL data access.

Features

• Dual Transport Support: Works with stdio (for local IDE integration) and SSE (for remote deployment).
• Security Middleware: Prevents destructive SQL operations (DROP, DELETE, TRUNCATE, etc.).
• Memory System: Store and retrieve corporate knowledge.
• Tools:
  • list_schemas: Explore available databases.
  • describe_table: Inspect table schemas.
  • query_analyzer: Execute secure SELECT queries.
  • store_memory: Persist corporate knowledge.
  • retrieve_memory: Retrieve stored information.
  • search_memory: Search corporate memory.

Installation

With Claude Desktop

Add to your claude_desktop_config.json:

{
  "multitravel-mcp": {
    "command": "npx",
    "args": [
      "-y",
      "@multitravel/mcp-server@latest"
    ]
  }
}

The MCP will automatically make the MySQL tools available to Claude.

With Custom SSE Server

If you need to connect to a custom SSE backend:

{
  "multitravel-mcp": {
    "command": "npx",
    "args": [
      "-y",
      "@multitravel/mcp-server@latest"
    ],
    "env": {
      "SSE_URL": "http://your-server:4000/sse"
    }
  }
}

Project Structure

├── src/
│   ├── config/      # DB Connection logic
│   ├── middleware/  # SQL Security validation
│   ├── tools/       # MCP Tool implementations
│   ├── bridge.ts    # SSE Bridge (connects to remote servers)
│   └── index.ts     # Main Server entry point
├── infra/           # Deployment templates
├── Dockerfile       # Container image
└── docker-compose.yml # Local development stack

Local Development

1. Copy .env.example to .env.
2. Ensure your DB tunnel is active at 127.0.0.1:3307.
3. Install dependencies: npm install.
4. Run in dev mode: npm run dev.

Local Testing with Docker

docker-compose up --build

Security

This server implements a strict validation layer that only allows SELECT, DESCRIBE, and SHOW commands. Any attempt to modify or delete data will be blocked.