The MCP Server provides AI assistants with direct, read-only access to Local by Flywheel WordPress databases, allowing them to interact with actual data structures without guessing. This enables accurate query generation and debugging.
From the registry: WordPress database access via Local by Flywheel. Execute read-only MySQL queries and inspect schema.
Please install the `mcp-local-wp` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Local by Flywheel with running site** — Install Local by Flywheel and start at least one site (https://localwp.com/)
Canonical MCP server config (stdio transport):
- command: `npx`
- args: ["-y","@verygoodplugins/mcp-local-wp@latest"]
- optional environment variables:
- `SITE_ID`: Explicit Local site ID (highest priority) (example: `lx97vbzE7`)
- `SITE_NAME`: Local site name lookup (example: `dev`)
- `MYSQL_DB`: MySQL database name (example: `local`)
- `MYSQL_USER`: MySQL user (example: `root`)
- `MYSQL_PASS`: MySQL password (example: `root`)
Note: Auto-detects active Local by Flywheel MySQL instance. Read-only queries only.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.SITE_IDrequiredExplicit site ID for connecting to the correct database.SITE_NAMEHuman-readable site name for lookup.MYSQL_DBDatabase name for non-Local setups.MYSQL_HOSTHost for MySQL connection.MYSQL_PORTPort for MySQL connection.MYSQL_USERUsername for MySQL connection.MYSQL_PASSPassword for MySQL connection.Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB