Skip to main content
Glama
MySQL MCP Server

MySQL MCP Server

by ashenud

MySQL MCP Server

A Model Context Protocol (MCP) server for MySQL database integration with Cursor IDE. This server provides tools to connect to, query, and manage MySQL databases directly from Cursor.

Features

  • πŸ”Œ Easy Connection: Connect to MySQL databases with simple configuration

  • πŸ” Query Execution: Run SQL queries and get structured results

  • πŸ“Š Database Management: List databases, tables, and table schemas

  • πŸ›‘οΈ Secure: Supports SSL connections and prepared statements

  • ⚑ Performance: Connection pooling for optimal performance

  • 🎯 TypeScript: Fully typed for better development experience

Related MCP server: MySQL MCP

Installation

npm install -g @ashenud/mcp-mysql-server

From source

git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build
npm link

Usage

Cursor IDE Configuration

Add the following to your Cursor MCP settings:

{
  "mcpServers": {
    "mysql": {
      "command": "@ashenud/mcp-mysql-server",
      "args": [],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Available Tools

1. mysql_connect

Connect to a MySQL database.

Parameters:

  • host (string, optional): MySQL host (default: "localhost")

  • port (number, optional): MySQL port (default: 3306)

  • user (string, required): MySQL username

  • password (string, required): MySQL password

  • database (string, optional): Database name

  • ssl (boolean, optional): Use SSL connection (default: false)

  • connectionLimit (number, optional): Connection pool limit (default: 10)

Example:

{
  "name": "mysql_connect",
  "arguments": {
    "host": "localhost",
    "port": 3306,
    "user": "myuser",
    "password": "mypassword",
    "database": "mydb",
    "ssl": false
  }
}

2. mysql_query

Execute a SQL query.

Parameters:

  • query (string, required): SQL query to execute

  • params (array, optional): Query parameters for prepared statements

Example:

{
  "name": "mysql_query",
  "arguments": {
    "query": "SELECT * FROM users WHERE age > ?",
    "params": ["25"]
  }
}

3. mysql_list_databases

List all available databases.

Example:

{
  "name": "mysql_list_databases",
  "arguments": {}
}

4. mysql_list_tables

List tables in a database.

Parameters:

  • database (string, optional): Database name (uses current if not provided)

Example:

{
  "name": "mysql_list_tables",
  "arguments": {
    "database": "mydb"
  }
}

5. mysql_describe_table

Get table structure and schema information.

Parameters:

  • table (string, required): Table name

  • database (string, optional): Database name (uses current if not provided)

Example:

{
  "name": "mysql_describe_table",
  "arguments": {
    "table": "users",
    "database": "mydb"
  }
}

6. mysql_disconnect

Close the MySQL connection.

Example:

{
  "name": "mysql_disconnect",
  "arguments": {}
}

Development

Prerequisites

  • Node.js 18.0.0 or higher

  • npm or yarn

Setup

  1. Clone the repository:

git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-server
  1. Install dependencies:

npm install
  1. Build the project:

npm run build
  1. Run in development mode:

npm run dev

Testing

Run the test suite:

npm test

Configuration

The server can be configured through environment variables or by passing parameters to the mysql_connect tool:

  • MYSQL_HOST: Default MySQL host

  • MYSQL_PORT: Default MySQL port

  • MYSQL_USER: Default MySQL username

  • MYSQL_PASSWORD: Default MySQL password

  • MYSQL_DATABASE: Default database name

  • MYSQL_SSL: Use SSL connection (true/false)

Security Considerations

  • Always use strong passwords for database connections

  • Enable SSL for production environments

  • Use connection pooling to limit concurrent connections

  • Validate and sanitize all user inputs before executing queries

  • Consider using read-only database users for MCP connections

Error Handling

The server provides detailed error messages for common issues:

  • Connection failures

  • Invalid SQL queries

  • Authentication errors

  • Database access permissions

  • Network timeouts

Contributing

  1. Fork the repository

  2. Create a feature branch: git checkout -b feature-name

  3. Make your changes and add tests

  4. Commit your changes: git commit -am 'Add some feature'

  5. Push to the branch: git push origin feature-name

  6. Submit a pull request

License

MIT License - see LICENSE file for details.

Support

Changelog

1.0.0

  • Initial release

  • Basic MySQL connection and query functionality

  • Database and table listing

  • Table schema inspection

  • Connection pooling support

  • SSL connection support

Available Tools

8 tools
mysql_connectC

Connect to a MySQL database

Inputs: user (required), password (required), host, port, +3 more.

mysql_describe_tableB

Get table structure and schema information

Inputs: table (required), database.

mysql_disconnectB

Close the MySQL connection

Inputs: no named parameters.

mysql_list_databasesB

List all available databases

Inputs: no named parameters.

mysql_list_tablesC

List tables in the current database

Inputs: database.

mysql_queryC

Execute a MySQL query

Inputs: query (required), params.

mysql_setup_persistentC

Set up persistent connection with default credentials

Inputs: user (required), password (required), host, port, +3 more.

mysql_statusB

Check connection status and database info

Inputs: no named parameters.

Tool Schema Changelog

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

Loading tool schema changelog…

    TDQS

    A3.5/5.0

    Scored across 8 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose with no overlap: connection management (connect, disconnect, status, setup_persistent), metadata listing (databases, tables, describe_table), and query execution (query). The descriptions make it easy to tell them apart, with no ambiguity in their functions.

    Naming Consistency5/5

    All tool names follow a consistent 'mysql_verb_noun' pattern (e.g., mysql_connect, mysql_describe_table, mysql_list_databases). This predictable naming scheme makes it easy for agents to understand and navigate the tool set without confusion.

    Tool Count5/5

    With 8 tools, this server is well-scoped for MySQL database operations. It covers essential functions like connection handling, metadata exploration, and query execution, with each tool earning its place without feeling bloated or insufficient.

    Completeness4/5

    The tool set provides solid coverage for core MySQL workflows: connection lifecycle, database/table listing, schema inspection, and query execution. A minor gap is the lack of tools for more advanced operations like transaction management or user administration, but agents can work around this using the query tool.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      A
      quality
      D
      maintenance
      A tool that provides simple API to execute SQL queries and manage MySQL databases, designed to integrate with Cursor IDE for AI assistants to directly perform database operations.
      8
      3
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      Enables management and querying of multiple MySQL databases through natural language, allowing AI assistants to list databases, execute SQL queries, and explore database schemas.
      1
      -
    • F
      license
      Not graded
      quality
      Not graded
      maintenance
      Enables direct interaction with MySQL databases through SQL queries, table exploration, and schema inspection with support for prepared statements and connection pooling.
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to interact with MySQL databases by executing SQL queries, describing table schemas, and listing tables. It provides seamless database integration for tools like Cursor through the Model Context Protocol.
      798 npm
      MIT