Advertise
MCP.so
Sign In

@enemyrr/MCP Mysql Server

@enemyrr

Repository

Basic information

Category

Databases

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637
Advertise