MySQL MCP Server

MySQL & PostgreSQL MCP Server

Overview

This project provides a read-only Model Context Protocol (MCP) server for interacting with MySQL & PostgreSQL databases. It allows clients compatible with MCP to inspect database schemas, retrieve metadata, and execute read-only SQL queries through a set of defined tools. The server is built with extensibility in mind and enforces read-only operations for safety.

Features & Implemented Tools

The server exposes several tools via MCP for database interaction. All tools are designed for read-only operations.

Schema & Metadata Tools

• get_table_columns: Retrieves column definitions for a specific table.
• get_schema: Fetches detailed schema information including tables, columns, indexes, and constraints, with varying detail levels.
• get_indexes: Retrieves index information for a specific table or all tables.
• get_constraints: Fetches constraint information (Primary Key, Foreign Key, Unique, Check) for a specific table or all tables.
• compare_schemas: Compares the structure (tables and columns) of two different database schemas.
• explain_schema: Generates a textual or structured (JSON) description of the database schema.
• detect_schema_changes: Returns a snapshot of the current schema. (Note: Does not compare against a specific past time).
• find_relationships: Discovers explicit foreign key relationships. Can optionally attempt to find implicit relationships based on naming conventions (use with caution).
• find_navigation_paths: Finds paths between two tables using explicit foreign key relationships (BFS algorithm).

Query Execution Tools

• execute_query: Executes a given read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN).
• execute_batch: Runs multiple read-only SQL queries sequentially. Can stop on the first error or attempt all.
• prepare_statement: Prepares and executes a read-only SQL statement with parameters.
• explain_query: Executes EXPLAIN on a given SQL statement to show the query execution plan (TEXT or JSON format).
• get_query_history: Placeholder tool. Server-side query history is not currently implemented.

Visualization Tools

• visualize_schema: Generates schema representations (tables, columns, relationships) in JSON, DOT (Graphviz), or Mermaid syntax suitable for creating ER diagrams.

Performance Tools

• get_performance_metrics: Retrieves selected global status variables from MySQL (e.g., Uptime, Threads, Queries). Does not provide query-specific history.

Setup & Installation

1. Prerequisites:

   • Node.js
   • npm
   • Access to a MySQL or PostgreSQL database

2. Clone the Repository:

   git clone https://github.com/kaulvimal/mysql-mcp
   cd mysql-mcp
   

3. Install Dependencies:

   npm install
   

4. Build the Project:

   npm run build
   

   This will create a build directory with the compiled code.

5. Using the server

• Create a shell script (e.g., mysql-mcp.sh) in the project root or a convenient location:

  #!/bin/bash
  # Set environment variables (if not using .env or want to override)
  export MYSQL_HOST=""
  export MYSQL_USER=""
  export MYSQL_PASSWORD=""
  export MYSQL_PORT=""
  
  export PG_HOST=""
  export PG_USER=""
  export PG_PASSWORD=""
  export PG_PORT=""
  export PG_DATABASE=""
  node $(dirname "$0")/build/index.js
  

• Make the script executable:

  chmod +x mysql-mcp.sh
  

• Integration Example (Cursor)

  To integrate this server with an Cursor, you can configure the client to run the server's execution script:

  {
  "mcpServers": {
  	"mysql-mcp": {
  	"command": "/path/to/your/mysql-mcp.sh" // Replace with the actual path to your script
  	}
  }
  }