@f4ww4z/mcp-mysql-server

Name: @f4ww4z/mcp-mysql-server
Author: f4ww4z

@f4ww4z

Repository

About @f4ww4z/mcp-mysql-server

A Model Context Protocol server for MySQL database operations

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-mysql-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@f4ww4z/mcp-mysql-server",
        "--client",
        "claude"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is @f4ww4z/mcp-mysql-server?

@f4ww4z/mcp-mysql-server is a Model Context Protocol server that provides MySQL database operations. It enables AI models to interact with MySQL databases through a standardized interface.

How to use @f4ww4z/mcp-mysql-server?

Install via Smithery (npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude) or manually (npx @f4ww4z/mcp-mysql-server). Configure it in your MCP settings file using either a MySQL connection string (mysql://user:password@localhost:port/database) or environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Then use the provided tools to connect, query, execute statements, list tables, and describe tables.

Key features of @f4ww4z/mcp-mysql-server

Secure connection handling with automatic cleanup
Prepared statement support for query parameters
Comprehensive error handling and validation
TypeScript support
Automatic connection management
Support for SELECT, INSERT, UPDATE, and DELETE queries

Use cases of @f4ww4z/mcp-mysql-server

AI models querying MySQL databases using natural language
Automated database migrations and data manipulation
Dynamic table discovery and schema exploration
Secure read/write access to MySQL from AI workflows

FAQ from @f4ww4z/mcp-mysql-server

How do I install @f4ww4z/mcp-mysql-server?

You can install it via Smithery (npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude) or manually (npx @f4ww4z/mcp-mysql-server).

How do I configure the MySQL connection?

Pass a MySQL connection string as an argument (mysql://user:password@localhost:port/database) or set the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP settings file.

What tools does this server provide?

It provides five tools: connect_db, query (SELECT statements), execute (INSERT, UPDATE, DELETE statements), list_tables, and describe_table.

How does the server handle security?

It uses prepared statements to prevent SQL injection, supports secure password handling through environment variables, validates queries before execution, and automatically closes connections when done.