mcp-mysql-server

likephp-github/mcp-mysql-server

3.1

If you are the rightful owner of mcp-mysql-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

A fully-featured Model Context Protocol (MCP) server providing comprehensive operations for MySQL and MariaDB databases.

Tools
7
Resources
0
Prompts
0

MCP MySQL/MariaDB Database Server

A fully-featured Model Context Protocol (MCP) server providing comprehensive operations for MySQL and MariaDB databases.

🌟 Features

🗃️ Multi-Database Support

  • Connect to multiple databases simultaneously - Manage multiple MySQL/MariaDB instances within a single MCP Server
  • Flexible connection naming - Support for custom connection names (main, test, analytics, prod, etc.)
  • Default connection setting - Specify the default database connection to use
  • Backward compatibility - Existing single-database configurations work without modification

🌐 Multi-Transport Modes

  • stdio mode - Standard input/output, suitable for local Claude Desktop
  • HTTP mode - HTTP/SSE server for external and remote access
  • both mode - Provide both stdio and HTTP connections simultaneously

🔒 Enterprise-Grade Security

  • SQL Injection Protection - Automatically detect and block dangerous SQL operations
  • Connection Pool Management - Efficiently manage database connection resources
  • SSL/TLS Support - Secure database connection encryption
  • CORS Control - Configurable cross-origin request settings
  • API Key Authentication - Optional security for HTTP endpoints

🛠️ Comprehensive Toolset

  1. execute_query - Execute SQL queries and updates
  2. list_tables - List all tables in the database
  3. describe_table - View table structure and column information
  4. test_connection - Test a specific database connection
  5. list_connections - List all available database connections
  6. get_connection_info - Retrieve detailed connection information
  7. test_all_connections - Batch test all database connections

🚀 Quick Start

1. Install Dependencies

# Install Node.js dependencies
npm install

# Build the project
npm run build

2. Configure Databases

Create a .env file:

Single Database Configuration (Backward Compatible)
# Basic Database Settings
DB_HOST=localhost
DB_PORT=3306
DB_USER=your_username
DB_PASSWORD=your_password
DB_NAME=your_database
DB_SSL=false

# Connection Pool Settings
DB_CONNECTION_LIMIT=10
DB_TIMEOUT=60000

# MCP Server Settings
MCP_TRANSPORT_MODE=stdio
Multi-Database Configuration (Recommended)
# Define connection list
DB_CONNECTIONS=main,test,analytics
DEFAULT_DB=main

# Main Database Connection
DB_MAIN_HOST=localhost
DB_MAIN_PORT=3306
DB_MAIN_USER=main_user
DB_MAIN_PASSWORD="complex@pass#123"
DB_MAIN_NAME=main_database
DB_MAIN_SSL=false

# Test Database Connection
DB_TEST_HOST=test-server.com
DB_TEST_PORT=3306
DB_TEST_USER=test_user
DB_TEST_PASSWORD="test$pass@456"
DB_TEST_NAME=test_database
DB_TEST_SSL=true

# Analytics Database Connection
DB_ANALYTICS_HOST=analytics.company.com
DB_ANALYTICS_PORT=3306
DB_ANALYTICS_USER=analytics_user
DB_ANALYTICS_PASSWORD="analytics#789$"
DB_ANALYTICS_NAME=analytics_db
DB_ANALYTICS_SSL=true

# Connection Pool Settings
DB_CONNECTION_LIMIT=10
DB_TIMEOUT=60000