go-mysql-mcp-server

SagenKoder/go-mysql-mcp-server

3.3

If you are the rightful owner of go-mysql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MySQL MCP Server is a Model Context Protocol server that allows AI agents to interact directly with MySQL databases, enabling efficient querying and analysis.

Tools

Functions exposed to the LLM to take actions

list_schemas

List all schemas/databases available in the MySQL server.

list_tables

List all tables in a specific schema with metadata.

get_table_structure

Get detailed column and index information for a table.

get_table_create

Get the CREATE TABLE statement for a specific table.

execute_query

Execute a SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN only).

search_table

Search for a value across all text columns in a table.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources