Skip to content
MCP server

MCP Local WP

Read-only SQL and schema access to Local by Flywheel WordPress sites for assistants

Runs locallyStatus and history
Pricing
Open source
Platforms
CLI, macOS, Windows
Runs
Locally
Version
2.0.0
Listing updated
2 days ago

About MCP Local WP

MCP Local WP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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.

Install

Run in a terminal

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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-local-wp": {
      "command": "npx",
      "args": [
        "-y",
        "@verygoodplugins/mcp-local-wp"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

What it does

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

Pricing

Open source

Free open-source npm package

Prices change. Check verygoodplugins.com before you buy.

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 to MCP Local WP

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ouroboros

    MCP server

    Spec-first layer that pins requirements and verifies results of AI coding agent work

    Runs locally
    • Open source
    • 6.4K GitHub stars
    • Developer tools