mcpserver.so LogoMCPFly
Submit
MySQL MCP Server logo

MySQL MCP Server

by comonetso

Data/DatabasesMySQLCursor IDEDatabase ManagementSQL

This is a Model Context Protocol (MCP) server for interacting with MySQL databases, designed for use with the Cursor IDE. It allows you to execute SQL queries and manage your MySQL database directly from the IDE.

View on GitHub

Last updated: N/A

What is MySQL MCP Server?

The MySQL MCP Server is a server that implements the Model Context Protocol (MCP) to enable interaction with a MySQL database from within the Cursor IDE. It provides functionalities for executing SQL queries and managing database schemas.

How to use MySQL MCP Server?

  1. Install the necessary packages using npm install. 2. Start the server using npm start. 3. Configure the server by setting environment variables such as MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, and MYSQL_READONLY. 4. Add a mcp.json file to your Cursor IDE project with the server configuration.

Key features of MySQL MCP Server

  • SQL query execution

  • Table listing

  • Table structure description

  • Database listing

  • Database switching

  • Connection status check

Use cases of MySQL MCP Server

  • Executing SQL queries within Cursor IDE

  • Managing MySQL database schemas from Cursor IDE

  • Developing and debugging SQL queries

  • Quickly inspecting table structures

  • Switching between different databases

FAQ from MySQL MCP Server

What is the default MySQL host?

The default MySQL host is 'localhost'.

What is the default MySQL port?

The default MySQL port is 3306.

What is the default MySQL user?

The default MySQL user is 'root'.

What is the default MySQL password?

The default MySQL password is an empty string.

What is the default database?

The default database is 'test'.