MySQL MCP Server

What is MySQL MCP Server?

MySQL MCP Server is an MCP server that gives AI agents direct access to MySQL databases. It lets agents execute SQL queries, manage database content, and interact with database objects through a simple interface.

How to use MySQL MCP Server?

Clone the repository, install dependencies with npm install, create a .env file with MySQL connection details, and run npm run build. Then configure the server for Claude Desktop or Cline by adding the appropriate MCP server configuration pointing to the built index.js file. Once installed, you can ask your AI agent to list tables, execute SQL queries, or create notes.

Key features of MySQL MCP Server

• Access notes stored in the database via note:///{id} URIs
• Create new text notes with create_note tool
• List all tables with list_tables tool
• Count tables with count_tables tool
• Search tables using LIKE pattern with search_tables
• Execute custom SQL queries with execute_sql

Use cases of MySQL MCP Server

• List all tables in a MySQL database through natural language prompts
• Execute arbitrary SQL queries and retrieve results via an AI agent
• Create and store text notes directly in the database
• Search for tables matching a pattern or describe a table’s structure

FAQ from MySQL MCP Server

What are the prerequisites for running MySQL MCP Server?

You need Node.js 18 or higher, a running MySQL server, and a database with appropriate permissions.

How do I configure MySQL MCP Server for Claude Desktop?

Add a server entry to ~/Library/Application Support/Claude/claude_desktop_config.json (MacOS) or %APPDATA%/Claude/claude_desktop_config.json (Windows), specifying the command, args path to build/index.js, and env variables for MySQL connection.

Where is my database data stored?

All data resides in your own MySQL database. The server connects to the database you configure, and does not store data externally.

What tools does the server provide?

The server provides seven tools: create_note, list_tables, count_tables, search_tables, describe_table, and execute_sql. It also exposes notes as resources.

How do I debug the server?

Use the MCP Inspector by running npm run inspector, which provides a URL for debugging tools in your browser.