MCP Local WP
Read-only SQL and schema access to Local by Flywheel WordPress sites for assistants
- 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-wpAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp-local-wp": {
"command": "npx",
"args": [
"-y",
"@verygoodplugins/mcp-local-wp"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp-local-wp": {
"command": "npx",
"args": [
"-y",
"@verygoodplugins/mcp-local-wp"
]
}
}
}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

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Ouroboros
MCP serverSpec-first layer that pins requirements and verifies results of AI coding agent work
Runs locally- Open source
- 6.4K GitHub stars
- Developer tools