@enemyrr/mcp-mysql-server

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

@enemyrr

代码仓库

关于 @enemyrr/mcp-mysql-server

暂无概览

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

enemyrr

配置

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

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

工具

未检测到工具

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

概览

What is @enemyrr/mcp-mysql-server?

A Model Context Protocol (MCP) server that enables AI models to interact with MySQL databases through a standardized interface. This server provides SQL query execution, schema management, and database exploration, all controllable via MCP tools.

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

Install via Smithery (npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude) or clone and build manually. Configure database connection using a DATABASE_URL in .env, individual environment variables, or pass credentials directly via the connect_db tool. After connecting, use available tools such as query, execute, list_tables, and describe_table.

Key features of @enemyrr/mcp-mysql-server

14 database tools for queries and schema management
MCP Resources for browsing database schema
MCP Prompts for generating SQL queries
Multiple connection methods (URL, workspace, direct)
Secure prepared statements to prevent SQL injection
Automatic connection cleanup after use

Use cases of @enemyrr/mcp-mysql-server

AI assistants executing SQL SELECT queries and returning results
Automated schema management: create, alter, or drop tables and columns
Database exploration: list tables, describe structures, view indexes and foreign keys
Generating SQL templates for common operations (SELECT, INSERT, UPDATE)
Obtaining natural language explanations of database schema

FAQ from @enemyrr/mcp-mysql-server

How do I connect to a MySQL database?

You can connect via a database URL in .env, individual host/user/password environment variables, or directly through the connect_db tool’s arguments (URL, workspace path, or credentials).

How does the server prevent SQL injection?

All queries support prepared statements, and the server validates queries before execution, using parameterized inputs to prevent injection.

What tools are available for schema changes?

Tools include create_table, add_column, alter_column, drop_column, drop_table, and truncate_table. Destructive operations require a confirmation flag.

What MCP resources are exposed?

Resources are provided under URIs like mysql://schema (database overview), mysql://tables (list tables), mysql://tables/{name} (table details), and mysql://tables/{name}/columns, indexes, sample for column definitions, indexes, and sample rows.

Does the server support prepared statement parameters?

Yes, both the query and execute tools accept a params array for parameterized SQL, ensuring safe and efficient query execution.

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

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