Go MCP Demo

What is go-mcp-demo?

go-mcp-demo is an MCP Server and Client demo built on mark3labs/mcp-go that integrates with Ollama to enable local large language models to call tools via natural language. It targets developers who want to see how an MCP server communicates with an MCP client and performs tasks like reading SQL files and executing MySQL queries.

How to use go-mcp-demo?

Install Ollama and pull a model (e.g., qwen2:1.5b). Edit pkg/config/config.yml to set the Ollama model, MySQL connection, and a .sql file path. Then run cmd/server/main.go to start the main server (default port 2001), and separately run cmd/mcp-server/main.go to start the MCP server (default port 2002). The MCP server registers two tools: read_file and query_db.

Key features of go-mcp-demo

• Integrates MCP Server and Client communication framework
• Supports reading local .sql files via natural language
• Supports executing arbitrary MySQL queries via natural language
• Uses Ollama local LLM for inference (default port localhost:11434)

Use cases of go-mcp-demo

• Demonstrate MCP communication with a local LLM and database tools
• Allow users to query a MySQL database by simply describing what they want
• Enable reading SQL file contents without manually opening files