@f4ww4z/mcp-mysql-server

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

@f4ww4z

代码仓库

关于 @f4ww4z/mcp-mysql-server

A Model Context Protocol server for MySQL database operations

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

f4ww4z

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.