Go MCP Mysql, developed by Zhwt, is an MCP server tool built with Go, designed to connect and interact with MySQL and MariaDB databases. It offers various functionalities for both schema management and data manipulation, serving as a bridge for developers and AI agents alike. The program is free and accessible via pre-built binaries or by building from source, making it a versatile option for integrating database operations into Model Context Protocol environments.

What does Go MCP Mysql connect to?

The Go MCP Mysql tool establishes connections with both MySQL and MariaDB databases. It operates within the Model Context Protocol (MCP) framework, functioning as an MCP server. This categorization means it is structured to enable interaction between AI clients and the specified database systems, facilitating data access and manipulation through a standardized protocol. Its core function is to provide an interface to these popular relational databases.

Core features and tools

Go MCP Mysql exposes a set of callable tools categorized for schema and data operations. Schema Tools include list_database, create_table, and alter_table. Data Tools comprise read_query, write_query, update_query, and delete_query. When operating in read-only mode, only tools starting with list, read_, and desc_ are functional, restricting modification capabilities. This distinction allows for controlled database interactions based on the configured mode.

Who is it for?

This tool is intended for developers and AI agents or LLMs that need to interact with MySQL databases. It enables workflows such as performing standard CRUD operations, exploring database schemas, and executing queries for data analysis. Go MCP Mysql is particularly useful for integrating database capabilities into AI-driven applications. Skip this if your primary need involves confirmed support for SSE or streamable HTTP protocols.

How to get started

The server authenticates using standard MySQL user/password credentials. It supports the stdio transport protocol, which is common for local MCP server deployments. Setup requires configuring MySQL connection details like host, user, password, port, and database, which can be provided via command-line arguments or a DSN string.

Use cases

• Perform Create, Read, Update, Delete (CRUD) operations on MySQL databases.
• Explore database schemas and structures.
• Execute read-only queries for data analysis and reporting.

Go MCP Mysql by Zhwt offers a direct way for AI clients and developers to manage and query MySQL and MariaDB databases. Its specific toolset supports essential database interactions, from schema exploration to data manipulation. The stdio transport and standard MySQL authentication make it a practical choice for local MCP server setups.