Skip to main content
Glama
MCP-MySQL Server

MCP-MySQL Server

by enemyrr

@enemyrr/mcp-servidor-mysql

insignia de herrería

Un servidor de Protocolo de Contexto de Modelo que proporciona operaciones con bases de datos MySQL. Este servidor permite que los modelos de IA interactúen con bases de datos MySQL mediante una interfaz estandarizada.

Instalación y configuración de Cursor IDE

Instalación mediante herrería

Para instalar MySQL Database Server para Claude Desktop automáticamente a través de Smithery :

npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude

Instalación manual

  1. Clonar y construir el proyecto:

git clone https://github.com/enemyrr/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build
  1. Agregue el servidor en la configuración de Cursor IDE:

    • Abrir la paleta de comandos (Cmd/Ctrl + Shift + P)

    • Buscar "MCP: Agregar servidor"

    • Rellene los campos:

      • Nombre: mysql

      • Tipo: command

      • Comando: node /absolute/path/to/mcp-mysql-server/build/index.js

Nota : Reemplace /absolute/path/to/ con la ruta real donde clonó y construyó el proyecto.

Related MCP server: MySQL MCP Server

Configuración de la base de datos

Puede configurar la conexión a la base de datos de tres maneras:

  1. URL de la base de datos en .env (recomendado):

DATABASE_URL=mysql://user:password@host:3306/database
  1. Parámetros individuales en .env :

DB_HOST=localhost
DB_USER=your_user
DB_PASSWORD=your_password
DB_DATABASE=your_database
  1. Conexión directa mediante herramienta :

use_mcp_tool({
  server_name: "mysql",
  tool_name: "connect_db",
  arguments: {
    url: "mysql://user:password@host:3306/database"
    // OR
    workspace: "/path/to/your/project" // Will use project's .env
    // OR
    host: "localhost",
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

Herramientas disponibles

1. connect_db

Conéctese a la base de datos MySQL mediante URL, ruta del espacio de trabajo o credenciales directas.

2. consulta

Ejecutar consultas SELECT con parámetros de declaración preparada opcionales.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = ?",
    params: [1]
  }
});

3. ejecutar

Ejecute consultas INSERT, UPDATE o DELETE con parámetros de declaración preparada opcionales.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "execute",
  arguments: {
    sql: "INSERT INTO users (name, email) VALUES (?, ?)",
    params: ["John Doe", "john@example.com"]
  }
});

4. listas_de_tablas

Enumere todas las tablas en la base de datos conectada.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "list_tables"
});

5. describe_tabla

Obtener la estructura de una tabla específica.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "describe_table",
  arguments: {
    table: "users"
  }
});

6. crear_tabla

Crea una nueva tabla con campos e índices específicos.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "create_table",
  arguments: {
    table: "users",
    fields: [
      {
        name: "id",
        type: "int",
        autoIncrement: true,
        primary: true
      },
      {
        name: "email",
        type: "varchar",
        length: 255,
        nullable: false
      }
    ],
    indexes: [
      {
        name: "email_idx",
        columns: ["email"],
        unique: true
      }
    ]
  }
});

7. agregar_columna

Agregar una nueva columna a una tabla existente.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "add_column",
  arguments: {
    table: "users",
    field: {
      name: "phone",
      type: "varchar",
      length: 20,
      nullable: true
    }
  }
});

Características

  • Múltiples métodos de conexión (URL, espacio de trabajo, directo)

  • Manejo seguro de conexiones con limpieza automática

  • Soporte de declaraciones preparadas para parámetros de consulta

  • Herramientas de gestión de esquemas

  • Manejo integral de errores y validación

  • Compatibilidad con TypeScript

  • Detección automática del espacio de trabajo

Seguridad

  • Utiliza sentencias preparadas para evitar la inyección de SQL

  • Admite el manejo seguro de contraseñas a través de variables de entorno

  • Valida las consultas antes de su ejecución

  • Cierra automáticamente las conexiones cuando termina

Manejo de errores

El servidor proporciona mensajes de error detallados para:

  • Fallos de conexión

  • Consultas o parámetros no válidos

  • Configuración faltante

  • Errores de base de datos

  • Errores de validación del esquema

Contribuyendo

¡Agradecemos sus contribuciones! No dude en enviar una solicitud de incorporación de cambios a https://github.com/enemyrr/mcp-mysql-server

Licencia

Instituto Tecnológico de Massachusetts (MIT)

Available Tools

7 tools
add_columnC

Add a new column to existing table

Inputs: field (required), table (required).

connect_dbC

Connect to MySQL database using URL or config

Inputs: database, host, password, url, +2 more.

create_tableC

Create a new table in the database

Inputs: fields (required), table (required), indexes.

describe_tableB

Get table structure

Inputs: table (required).

executeC

Execute an INSERT, UPDATE, or DELETE query

Inputs: sql (required), params.

list_tablesB

List all tables in the database

Inputs: no named parameters.

queryC

Execute a SELECT query

Inputs: sql (required), params.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 7 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose with no ambiguity. For example, 'execute' handles INSERT/UPDATE/DELETE while 'query' handles SELECT, and 'describe_table' provides structure while 'list_tables' enumerates tables. The separation between schema operations (add_column, create_table) and data operations (execute, query) is well-defined.

    Naming Consistency5/5

    All tools follow a consistent verb_noun pattern with clear, descriptive names. The naming convention is uniform throughout (e.g., add_column, create_table, describe_table, list_tables), making it easy to predict functionality. There are no deviations in style or formatting.

    Tool Count5/5

    With 7 tools, this server is well-scoped for MySQL database operations. Each tool serves a specific, necessary function in the database management workflow, from connection (connect_db) to schema manipulation (create_table, add_column) and data querying (query, execute). The count avoids both bloat and insufficiency.

    Completeness4/5

    The tool set covers core MySQL operations effectively, including connection, schema management, and data querying. Minor gaps exist, such as the lack of tools for updating or deleting tables, which could limit full lifecycle management. However, agents can work around this using existing tools like 'execute' for DROP TABLE queries.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI models to interact with MySQL databases through a standardized interface, supporting queries, data manipulation, table inspection, and query performance analysis with secure prepared statements.
      40 npm
      23
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI models to interact with MySQL databases through standardized operations including querying, executing commands, listing tables, and describing table structures with secure prepared statement support.
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to securely connect to and manage MySQL databases with support for multiple database connections, complete CRUD operations, schema inspection, and dynamic connection management through natural language.
      19 npm
      81
      MIT
    • A
      license
      Not graded
      quality
      Not graded
      maintenance
      Enables AI assistants to securely interact with MySQL databases through tools for query execution, schema inspection, and transaction management. It features built-in safety controls like row limits and query validation to ensure safe and standardized database access.
      716 npm
      -