MySQL MCP Server (Optimized)
by fabiovige
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | The hostname or IP address of the MySQL server. | localhost |
| MYSQL_PORT | Yes | The port number on which the MySQL server is listening. | 3306 |
| MYSQL_USER | Yes | The username to connect to the MySQL database. | |
| MYSQL_DATABASE | Yes | The name of the MySQL database to connect to. | |
| MYSQL_PASSWORD | Yes | The password to connect to the MySQL database. |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryC | Executa uma query SQL no banco MySQL |
| describe_tableC | Descreve a estrutura de uma tabela |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| analyze_table | Analisa uma tabela específica |
| find_large_tables | Encontra tabelas com mais registros |
| database_overview | Visão geral do banco de dados |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Lista de Bancos de Dados | Lista todos os bancos de dados disponíveis |
| Lista de Tabelas | Lista todas as tabelas do banco atual |
| Schema do Banco | Schema completo do banco de dados atual |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/fabiovige/mcp-mysql-simple'
If you have feedback or need assistance with the MCP directory API, please join our Discord server