drio
Open app

MCP Server

Source

Database MCP Server written in Golang

Catalog onlyCatalog onlySTDIO

Overview

MCP Server is a MySQL client proxy server written in Golang that allows clients to connect via Server-Sent Events (SSE) and execute SQL operations. It is designed with clean architecture principles and can be extended to support multiple database systems.

To use MCP Server, clone the repository, configure your environment variables in the .env file, and run the server using either standard SSE mode or stdio mode for Cursor integration.

  • Clean architecture design - Support for multiple database systems (MySQL, PostgreSQL) - Real-time updates via Server-Sent Events (SSE) - JSON-based API for executing SQL operations - Subscription-based change notifications - Integration with Cursor Editor's Model Context Protocol (MCP) - Environment-based configuration with .env file support
  1. Acting as a proxy for SQL operations in real-time applications.
  2. Integrating with Cursor Editor for enhanced database management.
  3. Supporting multiple database systems through a unified API.

Add to your AI client

Use these steps to connect MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "db-mcp-server-go-freepeak": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "db-mcp-server-go-freepeak": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "db-mcp-server-go-freepeak": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "db-mcp-server-go-freepeak": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "db-mcp-server-go-freepeak": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "db-mcp-server-go-freepeak": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-db-mcp-server-go-freepeak"
      ]
    }
  }
}

FAQ

Can MCP Server support other databases besides MySQL?

Yes! MCP Server can be extended to support additional database systems like PostgreSQL.

Is there a specific Go version required?

Yes, Go 1.22 or higher is required to run MCP Server.

How can I troubleshoot transport errors?

Ensure that the server is running and accessible at the configured port, and verify that there are no port conflicts with other services.

Developer tools