🎯 What if your AI assistant could actually SEE your WordPress database?
A Model Context Protocol (MCP) server that gives AI assistants like Claude and Cursor direct, read-only access to your Local by Flywheel WordPress database. No more guessing table structures. No more writing SQL queries blind. Your AI can now understand your actual data.
🤔 What’s an MCP Server?
Think of MCP (Model Context Protocol) as a secure bridge between AI assistants and your development tools. Instead of copying and pasting database schemas or query results, MCP servers let AI assistants directly interact with your tools while you maintain complete control.
Without MCP: “Hey AI, I think there’s a table called wp_something with a column that might be named user_meta… can you write a query?”
With MCP: “Hey AI, check what’s in my database and write the exact query I need.”
💡 The WordPress Developer’s Dilemma – Solved
Picture this: You’re debugging a LearnDash integration issue. Quiz results aren’t syncing properly. You fire up Cursor to help diagnose the problem, but without database access, even the most advanced AI is just making educated guesses about your table structures.
With MCP Local WP, your AI assistant can see your actual tables and columns, understand table relationships through JOIN operations, verify that data exists before suggesting queries, adapt to any plugin’s custom tables (WooCommerce, LearnDash, etc.), and provide instant debugging capabilities.
🔧 Key Features
- 🚀 Auto-Detection: Automatically finds and connects to your active Local by Flywheel MySQL instance
- 🔍 Dynamic Path Resolution: Handles Local’s changing site identifiers without manual configuration
- 📊 Schema Inspection: Browse database structure with INFORMATION_SCHEMA access
- 🔒 Read-Only Safety: Only SELECT/SHOW/DESCRIBE/EXPLAIN queries allowed
- ⚡ Smart Connection: Uses Unix sockets for optimal performance
- 🎯 WordPress-Aware: Understands WordPress table structures and relationships
- 🔄 Restart Resilient: Works every time you restart Local by Flywheel
- 🛡️ Secure by Design: No external connections, local development only
🛠️ Available Tools
- mysql_query: Execute read-only SQL queries against your WordPress database
- mysql_schema: Inspect database schema and table structures
⚡ Performance & Reliability
- Process-Based Detection: Scans for active MySQL processes to find the right instance
- Config Parsing: Extracts MySQL configuration from the active Local site
- Dynamic Connection: Connects using the correct socket path or port automatically
- Fallback Support: Falls back to environment variables for non-Local setups
🚀 Recent Updates
- Auto-Detection System: Revolutionary approach to finding Local’s MySQL instance
- Dynamic Path Resolution: No more hardcoded paths that break on restart
- WordPress Integration: Optimized for WordPress database structures
- Enhanced Error Handling: Clear error messages for troubleshooting
Perfect for WordPress developers who want to leverage AI assistants for database queries, debugging plugin issues, analyzing data structures, and understanding complex table relationships – all while maintaining complete control over their local development environment.