# MCP Local WP

> MCP Local WP is an open-source MCP server for databases. Read-only SQL and schema access to Local by Flywheel WordPress sites for assistants. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, macOS, Windows, Linux
- **Website:** https://verygoodplugins.com
- **Repository:** https://github.com/verygoodplugins/mcp-local-wp
- **MCP Registry name:** io.github.verygoodplugins/mcp-local-wp
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-15

## About

Written for WordPress developers who debug against real data, this server lets Claude or Cursor inspect the MySQL database of a site running in Local by Flywheel. The README's example is a LearnDash quiz query: without database access the assistant guessed a nonexistent activity_meta column, with it the assistant saw that metadata lives in a separate user_activity_meta table and joined correctly.

Version 2.0 needs Node.js 24 or newer and uses MCP SDK v2. Query results come back as a rows object, and schema listing returns bounded pages of table names with a hasMore flag. Successful calls return matching structured and JSON-text results, while failures set isError. Configuration is resolved lazily, so tool discovery works even when no site is running, and setting MYSQL_HOST or MYSQL_SOCKET_PATH selects a manual connection instead of Local detection.

It runs over stdio and is published on npm. The same vendor, Very Good Plugins, also publishes MCP servers for Toggl Track, Evernote, FreeScout and AutoMem.

## Features

- **Read-only queries:** Runs MySQL queries against a local WordPress database without write access.
- **Schema inspection:** Lists tables in bounded pages so large databases stay manageable.
- **Local site detection:** Resolves the Local by Flywheel site, with manual host or socket override.
- **Lazy configuration:** Tool discovery works without a running site.
- **Structured results:** Successes return structured and JSON-text output; failures set isError.
- **Stdio cleanup:** A parent watchdog removes abandoned stdio servers.

## Good for

- Debug a plugin integration against real table structures
- Write an accurate JOIN across WordPress meta tables
- Check what a plugin stores in the database
- Explore the schema of a Local site before writing a migration

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp-local-wp -- npx -y @verygoodplugins/mcp-local-wp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp-local-wp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
```

## FAQ

### Can the assistant change my data?

No. The README describes access as read-only.

### What does version 2.0 require?

Node.js 24 or newer; query results are now an object with a rows array.

### Does it need a running site for tool discovery?

No. Database and Local configuration are resolved lazily.

### How can I point it at a database without Local?

Set MYSQL_HOST or MYSQL_SOCKET_PATH to choose the manual connection.

### Is MCP Local WP free?

Yes. MCP Local WP is open source, so you can use and self-host it for free.

### How do I add MCP Local WP to Claude Code?

Run this command in your terminal: claude mcp add mcp-local-wp -- npx -y @verygoodplugins/mcp-local-wp

### What are the best alternatives to MCP Local WP?

The closest alternatives to MCP Local WP are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/mcp-local-wp
