mysql-mcp

mysql-mcp

5
databases

The MySQL MCP Server is a robust Model Context Protocol server that facilitates interaction between AI agents and MySQL databases. It allows executing SQL queries and managing database content efficiently. The server supports multiple features such as note creation and table management.

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

  • Access notes stored in the database via URIs
  • Create, list, count, search, and describe tables
  • Execute custom SQL queries

Prerequisites

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

Setup

  1. Clone the repository.
  2. Install dependencies.
  3. Configure MySQL connection.
  4. Build the server.

Installation

Add server config to Claude Desktop or Cline settings.

Usage Examples

  • List all tables.
  • Execute SQL queries.
  • Create a note.