cosmic-mcp

All servers

MySQL MCP

io.github.gistrec/mcp-mysql-client ยท version 1.1.1

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

MCP server for one MySQL database: schema, read-only queries and guarded writes.

https://github.com/gistrec/mcp-mysql-client

Quick facts

  • Listing: Community
  • Published Nov 4, 20:44 UTC
  • Transport: stdio
  • Package: npm mcp-mysql-client 1.1.1
  • Listed by cosmic-mcp: Nov 9, 04:26 UTC

Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (npm)

npx -y '[email protected]'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOW_DELETE_OPERATION": "<your allow delete operation>",
        "ALLOW_INSERT_OPERATION": "<your allow insert operation>",
        "ALLOW_UPDATE_OPERATION": "<your allow update operation>",
        "MYSQL_DB": "<your mysql db>",
        "MYSQL_HOST": "<your mysql host>",
        "MYSQL_MAX_ROWS": "<your mysql max rows>",
        "MYSQL_PASS": "<your mysql pass>",
        "MYSQL_PORT": "<your mysql port>",
        "MYSQL_SSL": "<your mysql ssl>",
        "MYSQL_SSL_CA": "<your mysql ssl ca>",
        "MYSQL_TIMEOUT_MS": "<your mysql timeout ms>",
        "MYSQL_USER": "<your mysql user>"
      }
    }
  }
}

Claude Code

claude mcp add 'mcp-mysql-client' -- npx -y '[email protected]'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOW_DELETE_OPERATION": "<your allow delete operation>",
        "ALLOW_INSERT_OPERATION": "<your allow insert operation>",
        "ALLOW_UPDATE_OPERATION": "<your allow update operation>",
        "MYSQL_DB": "<your mysql db>",
        "MYSQL_HOST": "<your mysql host>",
        "MYSQL_MAX_ROWS": "<your mysql max rows>",
        "MYSQL_PASS": "<your mysql pass>",
        "MYSQL_PORT": "<your mysql port>",
        "MYSQL_SSL": "<your mysql ssl>",
        "MYSQL_SSL_CA": "<your mysql ssl ca>",
        "MYSQL_TIMEOUT_MS": "<your mysql timeout ms>",
        "MYSQL_USER": "<your mysql user>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOW_DELETE_OPERATION": "<your allow delete operation>",
        "ALLOW_INSERT_OPERATION": "<your allow insert operation>",
        "ALLOW_UPDATE_OPERATION": "<your allow update operation>",
        "MYSQL_DB": "<your mysql db>",
        "MYSQL_HOST": "<your mysql host>",
        "MYSQL_MAX_ROWS": "<your mysql max rows>",
        "MYSQL_PASS": "<your mysql pass>",
        "MYSQL_PORT": "<your mysql port>",
        "MYSQL_SSL": "<your mysql ssl>",
        "MYSQL_SSL_CA": "<your mysql ssl ca>",
        "MYSQL_TIMEOUT_MS": "<your mysql timeout ms>",
        "MYSQL_USER": "<your mysql user>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.
  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • AI2SQL Verified domain
    Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
  • AICasePredict Verified domain
    Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts.
  • APC Security Reference Server
    Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...