MySQL MCP Server

Example Use Cases

• 1

  Run arbitrary SQL queries against a MySQL database to fetch or update data.

• 2

  Inspect database structure and metadata (list tables, describe table schemas, count tables).

• 3

  Create or retrieve simple text notes stored in the database via note:///{id} URIs.

Description

This project provides a Node.js MCP server that exposes MySQL databases to AI agents, enabling direct execution of SQL queries and database inspection. It includes utilities to list and search tables, describe table schemas, and create or access simple text notes via note:///{id} URIs. The server is intended for local deployment with environment-based MySQL credentials and is distributed with an MIT license for straightforward use and development.