mysql-mcp-webui

library0.1.7jsnpmunverified

A MySQL Model Context Protocol (MCP) server (v0.1.7) that gives Claude Desktop and Claude Code direct access to MySQL databases through a secure, permission-controlled interface. It provides four MCP tools (query, list-tables, describe-table, list-databases) for SQL execution, schema exploration, and database navigation. Includes a React-based web UI for live configuration management, token-based authentication, and a multi-instance permission system. Requires Node.js >=20.0.0 and MySQL 5.7+. Distinguishes itself from other MCP database servers by bundling a web UI for connection management and generating API tokens.

database devops

npm install mysql-mcp-webui

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · MYSQL-MCP-WEBUI

mysql-mcp-webui

databasejavascriptv0.1.7

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Install the MCP server globally, generate an API token, configure Claude Desktop to launch it via npx, and manage connections via the web UI.

npm install -g mysql-mcp-webui # Generate API token mysql-mcp-webui --generate-token # Output: mcp_abc123... # Create ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows) with: { "mcpServers": { "mysql": { "command": "npx", "args": ["-y", "mysql-mcp-webui"], "env": { "TRANSPORT": "stdio", "AUTH_TOKEN": "mcp_abc123..." } } } } # Restart Claude Desktop, then open http://localhost:9274 # Login with admin / admin, add MySQL connection

Debug

Known issues

gotchaAUTH_TOKEN must be generated before configuring Claude Desktop; you cannot start the server without it.

fix

Run 'mysql-mcp-webui --generate-token' first and copy the token.

affects: >=0.1.0

gotchaToken is shown only once during generation; if lost, you must generate a new one.

fix

Regenerate token with 'mysql-mcp-webui --generate-token' and update Claude config.

affects: >=0.1.0

deprecatedGlobal install with 'npm install -g mysql-mcp-webui' is deprecated in favor of npx (no install).

fix

Use 'npx -y mysql-mcp-webui' in Claude config instead of a global command.

affects: >=0.1.5

gotchaDefault web UI credentials are admin/admin; you must change password on first login.

fix

After first login, immediately change the admin password in the web UI.

affects: >=0.1.0

gotchaNode.js >=20.0.0 required; using older versions will cause startup failure.

fix

Upgrade Node.js to v20 or later via https://nodejs.org.

affects: >=0.1.0

Errors

Common errors & fixes

Error: Cannot find module 'mysql-mcp-webui'

Running globally installed version but PATH not configured or package not installed.

fix

Use 'npx -y mysql-mcp-webui' instead, or ensure global install with 'npm install -g mysql-mcp-webui'.

Error: AUTH_TOKEN environment variable is required

Missing or unset AUTH_TOKEN environment variable in Claude config.

fix

Generate a token with 'mysql-mcp-webui --generate-token' and add it to the env section of claude_desktop_config.json.

Upgrade

Version history

0.1.7latest on npm

Audit

Dependencies

mysql2requiredMySQL database driver for query execution

Agent activity

7 hits · last 30 days

node

Resources

githubhttps://github.com/yashagldit/mysql-mcp-webui ↗

packagemysql-mcp-webui ↗

homepagehttps://github.com/yashagldit/mysql-mcp-webui#readme ↗