@f4ww4z/MCP Mysql Server

@f4ww4z

Basic information

About @f4ww4z/MCP Mysql Server

A Model Context Protocol server for MySQL database operations

@f4ww4z/MCP Mysql Server 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"
      ]
    }
  }
}

@f4ww4z/MCP Mysql Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

Frequently asked questions

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.