MySQL MCP Server

Databasestdiov2.0.0
Repositorio

MCP server for MySQL and MariaDB that lets AI agents inspect schemas, list tables, and run parameterized SQL queries. Supports read-only or read-write modes so agents can explore data, debug, and prototype against a MySQL database with controlled access.

mysqlmariadbsqldatabaserelationalquery

Conectar

Añade esta configuración a .claude/mcp.json

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASS": "<YOUR_MYSQL_PASS>",
        "MYSQL_DB": "<YOUR_MYSQL_DB>"
      }
    }
  }
}

Herramientas (3)

run_query

Execute a SQL query against the configured MySQL database.

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL statement to execute"
    }
  }
}

list_tables

List tables in the current database.

{
  "type": "object",
  "properties": {
    "database": {
      "type": "string",
      "description": "Optional database name to scope results"
    }
  }
}

describe_table

Return the column definitions for a table.

{
  "type": "object",
  "required": [
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    }
  }
}

Recursos

Este servidor no expone ningún recurso.

Prompts

Este servidor no expone ningún prompt.

Información del servidor

Autor
Benborla (@benborla)
Repositorio
https://github.com/benborla/mcp-server-mysql
Licencia
MIT
Versión
2.0.0
Estrellas
980
Última actualización
24 de junio de 2026