@f4ww4z/MCP Mysql Server

@f4ww4z

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

f4ww4z

关于 @f4ww4z/MCP Mysql Server

A Model Context Protocol server for MySQL database operations

@f4ww4z/MCP Mysql Server 配置

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

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

@f4ww4z/MCP Mysql Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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.

数据库分类下的更多 MCP 服务器

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K