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