MCP Mysql Simple MCP Server

Servidor MCP otimizado para MySQL - Arquitetura limpa com SOLID

Local serverstdio

What is the MCP Mysql Simple MCP server?

If you want an AI assistant working directly with MCP Mysql Simple, the mcp mysql simple mcp server is the bridge. Servidor MCP otimizado para MySQL - Arquitetura limpa com SOLID.

What MCP Mysql Simple does

Servidor MCP (Model Context Protocol) para MySQL com arquitetura limpa e princípios SOLID.

Tools it exposes

Once connected, the assistant can call these 2 tools directly:

  • execute_query — Executa queries SQL com validação
  • describe_table — Descreve estrutura de tabelas

Installing the mcp mysql simple mcp server

Setup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.

Configuration

The server reads 5 environment variables: MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP Mysql Simple sits in that group, and the shape of its toolset — execute_query, describe_table — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • Maintained by fabiovige.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the mcp mysql simple mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
execute_queryExecuta queries SQL com validação
describe_tableDescreve estrutura de tabelas

Configuration

VariableDescriptionRequired
MYSQL_HOSTEndpoint or connection string the server talks to.Optional
MYSQL_PORTConfiguration value read at startup.Optional
MYSQL_USERConfiguration value read at startup.Optional
MYSQL_PASSWORDConfiguration value read at startup.Optional
MYSQL_DATABASEConfiguration value read at startup.Optional

Example prompts to try

  • Use MCP Mysql Simple to execute query.
  • Use MCP Mysql Simple to describe table.

Frequently asked questions

It connects MCP Mysql Simple to MCP-compatible AI assistants such as Claude and Cursor, exposing 2 tools (execute_query, describe_table) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP Mysql Simple directly.