Advertise
MCP.so
Sign In

@enemyrr/MCP Mysql Server

@enemyrr

Repository

Basic information

Category

Databases

Last updated

License

MIT

Transports

stdio

Author

enemyrr

About @enemyrr/MCP Mysql Server

No overview available yet

@enemyrr/MCP Mysql Server config

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

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

@enemyrr/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 @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

Frequently asked questions

1

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).

2

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.

3

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.

4

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.

5

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.

Comments

More Databases MCP servers

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

NPILayer

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

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
Advertise