Skip to main content
Glama
Sign In
enesjakozh

MySQL MCP Server

by LeonMelamud
npmGitHub
JavaScript
25
4
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Uses .ENV files for configuration of MySQL connection details including host, username, password, and database name

  • Provides direct access to MySQL databases, allowing execution of SQL queries, table management, and storage of notes with title and content in a MySQL database

  • Runs on Node.js runtime (version 18 or higher) as the execution environment for the MCP server

MySQL MCP Server

A powerful MCP server that provides direct access to MySQL databases. This server enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.

Features

Resources

  • Access notes stored in the database via note:///{id} URIs
  • Each note has a title and content
  • Plain text mime type for simple content access

Tools

  • create_note - Create new text notes in the database
    • Takes title and content as required parameters
    • Stores note in the MySQL database
  • list_tables - List all tables in the connected database
  • count_tables - Get the total number of tables in the database
  • search_tables - Search for tables using LIKE pattern
  • describe_table - Get the structure of a specific table
  • execute_sql - Execute custom SQL queries

Prerequisites

  • Node.js 18 or higher
  • MySQL server installed and running
  • A database with appropriate permissions

Setup

  1. Clone this repository:
    git clone git@github.com:LeonMelamud/mysql-mcp.git cd mysql-mcp
  2. Install dependencies:
    npm install
  3. Create a .env file in the root directory with your MySQL connection details:
    MYSQL_HOST=localhost MYSQL_USER=your_username MYSQL_PASSWORD=your_password MYSQL_DATABASE=your_database
  4. Build the server:
    npm run build

Installation

For Claude Desktop

Add the server config to your Claude Desktop configuration file:

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json On Windows: %APPDATA%/Claude/claude_desktop_config.json

{ "mcpServers": { "mysql": { "command": "node", "args": ["/path/to/mysql-server/build/index.js"], "env": { "MYSQL_HOST": "localhost", "MYSQL_USER": "your_username", "MYSQL_PASSWORD": "your_password", "MYSQL_DATABASE": "your_database" } } } }

For Cline

Add the server config to your Cline MCP settings file:

On MacOS: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json On Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

{ "mcpServers": { "mysql": { "command": "node", "args": ["/path/to/mysql-server/build/index.js"], "env": { "MYSQL_HOST": "localhost", "MYSQL_USER": "your_username", "MYSQL_PASSWORD": "your_password", "MYSQL_DATABASE": "your_database" }, "disabled": false, "autoApprove": [] } } }

Usage Examples

Once installed, you can use the MySQL MCP server in your conversations with Claude:

List all tables in the database

Please list all the tables in my MySQL database.

Execute a SQL query

Run this SQL query: SELECT * FROM users LIMIT 5

Create a note

Create a note titled "Meeting Notes" with the content "Discussed project timeline and assigned tasks."

Development

For development with auto-rebuild:

npm run watch

Debugging

Use the MCP Inspector to debug the server:

npm run inspector

The Inspector will provide a URL to access debugging tools in your browser.

License

MIT

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A powerful server that enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.

  1. Features
    1. Resources
    2. Tools
  2. Prerequisites
    1. Setup
      1. Installation
        1. For Claude Desktop
        2. For Cline
      2. Usage Examples
        1. List all tables in the database
        2. Execute a SQL query
        3. Create a note
      3. Development
        1. Debugging
      4. License

        Related MCP Servers

        • mcp-mysql-server

          f4ww4z
          A
          security
          A
          license
          A
          quality
          This server enables AI models to interact with MySQL databases through a standardized interface.
          Last updated -
          5
          646
          61
          JavaScript
          MIT License
          • Linux
          • Apple

        • MySQL MCP Server

          Mineru98
          -
          security
          A
          license
          -
          quality
          A server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.
          Last updated -
          20
          Python
          MIT License
          • Linux
          • Apple

        • MySql MCP Server

          sussa3007
          A
          security
          A
          license
          A
          quality
          Connect and interact with MySQL databases seamlessly. Execute SQL queries, manage database connections, and retrieve data directly through AI assistants. Enhance your AI capabilities with structured access to your MySQL data.
          Last updated -
          9
          14
          3
          TypeScript
          MIT License

        • MySQL MCP Server

          amornpan
          -
          security
          F
          license
          -
          quality
          Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
          Last updated -
          Python
          • Linux
          • Apple

        View all related MCP servers

        Appeared in Searches

        New MCP Servers

        ID: cp6c716buh