Databases & StorageMCP Registrynpm3 toolsA · 85

read-only-local-mysql-mcp-server

capital.hove · Updated 8mo ago

MCP server for read-only MySQL database queries in Claude Desktop

At a glance

read-only-local-mysql-mcp-server is an MCP server in the Databases & Storage category. It runs locally over stdio via `npx -y @hovecapital/read-only-mysql-mcp-server`, and declares no required credentials. It exposes 3 tools, including connect, disconnect and query. It scores A (85/100) on the MCP Skills Hub health score as of Oct 28, 2026.

Source 7

One-click install

VS Code VS Code Insiders Cursor

Opens your editor and pre-fills the config. Your editor will ask before adding it.

How to install read-only-local-mysql-mcp-server in your AI client

Setup for Claude Code, Claude Desktop, Cursor, Codex, Windsurf, Cline and VS Code — copy-paste ready.

How to install read-only-local-mysql-mcp-server in Claude CodeAnthropic's agentic CLI

Add the server

bash

claude mcp add read-only-local-mysql-mcp-server -- npx -y @hovecapital/read-only-mysql-mcp-server

2
Verify it's connected
bash
```
claude mcp list
```
Sharing it with your team?
Add `--scope project` to write it to .mcp.json in the repository root, which you can commit (with the secrets left as environment variables).
Use it in a session
Ask Claude to use the tools this server exposes (e.g. connect, disconnect, query). It discovers them automatically.

How to install read-only-local-mysql-mcp-server in Claude DesktopDesktop app (MCP config)

Open your MCP config
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

Add this server

json

{
  "mcpServers": {
    "read-only-local-mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-mysql-mcp-server"
      ]
    }
  }
}

Restart Claude Desktop
The tools appear under the 🔌 menu once the app reloads.

How to install read-only-local-mysql-mcp-server in CursorAI-first code editor

Create / edit .cursor/mcp.json in your project

json

{
  "mcpServers": {
    "read-only-local-mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-mysql-mcp-server"
      ]
    }
  }
}

Enable it
Cursor Settings → MCP → toggle the server on. Tools become available to the Composer/Agent.

How to install read-only-local-mysql-mcp-server in Codex CLIOpenAI coding agent

Add to ~/.codex/config.toml

toml

[mcp_servers.read-only-local-mysql-mcp-server]
command = "npx"
args = ["-y", "@hovecapital/read-only-mysql-mcp-server"]

Run Codex
Codex loads MCP servers from config.toml on startup and exposes their tools to the agent.

How to install read-only-local-mysql-mcp-server in WindsurfCodeium's agentic IDE

Edit ~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "read-only-local-mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-mysql-mcp-server"
      ]
    }
  }
}

Reload
Windsurf → Cascade → refresh MCP servers. Cascade can now call the tools.

How to install read-only-local-mysql-mcp-server in ClineVS Code autonomous agent

Open Cline → MCP Servers → Configure
Adds to cline_mcp_settings.json.

Add the server

json

{
  "mcpServers": {
    "read-only-local-mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-mysql-mcp-server"
      ]
    }
  }
}

How to install read-only-local-mysql-mcp-server in VS CodeCopilot / MCP support

Create .vscode/mcp.json

json

{
  "servers": {
    "read-only-local-mysql-mcp-server": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-mysql-mcp-server"
      ]
    }
  }
}

Start it
VS Code shows a ▶ Start action above the server entry. Agent mode (Copilot Chat) can then use the tools.

What tools does read-only-local-mysql-mcp-server expose? (3)

Taken from the project's README — the server itself was not queried, so check its docs for the exact schemas.

connectConnect to a MySQL database using a connection string. The connection persists for subsequent queries until changed or disconnected.
disconnectDisconnect from the current runtime database and revert to the default environment-configured connection. Takes no parameters.
queryRun a read-only SQL query against the currently connected database.

What the code can do

Read from the published package source — never executed. Parsed 2 of 2 source files.

This server can read your environment variables.

How it was published

No provenance attestation — there is nothing linking this published artifact to a specific source commit.
1 npm maintainer — a single point of compromise · last published by xwj30.

Maintainer of this package and think something here is wrong? Tell us and we'll correct it.

Before you install

Signals gathered from the source repo and package registry — not a safety verdict.

What it can reach

Runs code on your machine — Executes as a local process with your user's permissions, including filesystem access.
Downloads at launch — The package is fetched from its registry each run unless you pin a version.

Last commit 7 days ago — Actively maintained.
7 GitHub stars — Very little community usage so far.

Client compatibility

Claude Code: NativeClaude Desktop: NativeCursor: NativeCodex CLI: NativeWindsurf: NativeCline: NativeVS Code: Native

Health score

A · 85

Maintenance, adoption, transparency and packaging — not a safety audit. How this is calculated

Maintenance30%100%
Last commit 7 days ago.
Adoption20%27%
7 stars.
Transparency20%100%
4/4: ✓ public source repo, ✓ declared license, ✓ documentation, ✓ discoverable tool list.
Provenance15%100%
Package and registry entry point at the same repository.
Packaging15%100%
Publishes a pinned version (0.1.1).

Documentation

Full README

MySQL MCP Server

A Model Context Protocol (MCP) server that enables Claude Desktop to interact with MySQL databases through natural language queries.

Features

Execute read-only SQL queries through Claude Desktop
Dynamic connection configuration — connect to any MySQL database at runtime via connection string
Built-in security with query validation (SELECT, WITH, SHOW, DESCRIBE and EXPLAIN only, one statement, no comments) plus a server-side read-only transaction
Easy integration with Claude Desktop
JSON formatted query results
Environment-based configuration for database credentials

Quick Start

For Claude Code Users (Recommended - Easiest Method)

bash

claude mcp add mysql -s user -- npx -y @hovecapital/read-only-mysql-mcp-server@latest

Then set your database environment variables:

bash

export DB_HOST=localhost
export DB_PORT=3306
export DB_DATABASE=your_database_name
export DB_USERNAME=your_username
export DB_PASSWORD=your_password

Done! Restart Claude Code and ask: "What tables are in my database?"

For Claude Desktop Users (Manual Configuration)

1. Open your config file:

bash

# macOS
open ~/Library/Application\ Support/Claude/claude_desktop_config.json

# Windows
notepad %APPDATA%\Claude\claude_desktop_config.json

2. Add this configuration:

Excerpt — the full document is on GitHub.

Alternatives to read-only-local-mysql-mcp-server

Maintain read-only-local-mysql-mcp-server? Add a badge to your README

Shows its health grade, and links readers to install steps for every client.

markdown

[![read-only-local-mysql-mcp-server on MCP Skills Hub](https://mcp-skills-hub.vercel.app/badge/capital-hove-read-only-local-mysql-mcp-server)](https://mcp-skills-hub.vercel.app/mcps/capital-hove-read-only-local-mysql-mcp-server)

Catalog data refreshed Oct 28, 2026. Something wrong? Report it.