Overview

The MCP MySQL Server enables AI models to interact with MySQL databases, providing a standardized interface for working with this popular relational database management system. MySQL is widely used for web applications, enterprise software, and data-driven applications, making it essential for AI integrations.

Created by:

Developed by Fawaz Jullian

Key Features

⚡

Secure Connection Handling

Secure connection handling with automatic cleanup

🔑

Prepared Statement Support

Prepared statement support for query parameters

⏰

Comprehensive Error Handling

Comprehensive error handling and validation

💾

Automatic Connection Management

Automatic connection management

Available Tools

Quick Reference

Tool	Purpose	Category
`connect_db`	Establish database connection	Connection
`query`	Execute SELECT queries	Read
`execute`	Execute INSERT/UPDATE/DELETE	Write
`list_tables`	List all tables	Schema
`describe_table`	Get table structure details	Schema

Detailed Usage

connect_db▶

Warning:

only use when requested or if other commands fail

Establish connection to MySQL database using provided credentials.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "connect_db",
  arguments: {
    host: "localhost",
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

query▶

Execute SELECT queries with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = ?",
    params: [1]
  }
});

execute▶

Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "execute",
  arguments: {
    sql: "INSERT INTO users (name, email) VALUES (?, ?)",
    params: ["John Doe", "[email protected]"]
  }
});

list_tables▶

List all tables in the connected database.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "list_tables",
  arguments: {}
});

describe_table▶

Get the structure of a specific table.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "describe_table",
  arguments: {
    table: "users"
  }
});

Installation

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@f4ww4z/mcp-mysql-server"
      ],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Sources

Content and Media MCP Servers

Explore seamless integration with leading content management systems, media processing tools, and digital asset management platforms through our Content & Media category. These integrations enable robust content creation, media processing, and asset management for your AI-powered applications.

Docker Integration MCP Servers

Docker MCP servers provide interfaces for LLMs to interact with Docker containers and services. These servers enable AI models to manage containers, handle image operations, and assist with Docker infrastructure tasks.

ArangoDB MCP Server

ArangoDB MCP servers enable AI models to interact with ArangoDB databases, providing capabilities for document operations, graph queries, AQL queries, and multi-model data management.

MySQL MCP Server