MySQL Explorer AI Agent
An intelligent MySQL MCP Server with expert data analytics capabilities and comprehensive caching. Goes beyond basic querying to provide in-depth database analysis, relationship mapping, and user behavior insights with high-performance caching system.
MySQL Explorer handles repetitive tasks for you automatically. It can do 6 different things for you—just connect to it in one click.
Available Tools
MySQL Explorer can do 6 different things for you automatically. Here's what it can handle:
mysql_query
Execute a read-only SQL query against MySQL databases. Supports SELECT, SHOW, DESCRIBE, and EXPLAIN statements.
mysql_schema
Get comprehensive schema information including tables, relationships, constraints, and data patterns.
mysql_analyze_tables
Analyze table relationships and suggest optimal query patterns for user behavior analysis.
mysql_inventory
Get comprehensive inventory of all configured MySQL hosts and their accessible databases.
mysql_cross_host_query
Execute queries across multiple MySQL hosts and combine results for comprehensive analysis.
mysql_discover_analytics
Intelligently discover and analyze database structure with expert data analytics insights. Use summary mode first for large servers.
Configuration Variables
To get MySQL Explorer working, you'll need to give it access to your accounts. You must provide 1 piece of info, and 6 are optional. This usually means logging into apps like Gmail, Slack, or other services you want it to use—just like when you connect apps on your phone.
MYSQL_SSL
MYSQL_HOST
MYSQL_PORT
MYSQL_USER
MYSQL_DATABASE
MYSQL_PASSWORD
MCP_MYSQL_CACHE_ENABLED
Common Questions
What is an AI Agent?
An AI agent is like having a personal assistant who does specific tasks for you. Instead of a general chatbot that just talks, AI agents actually do things—they can check your calendar, send emails, look up information, and handle repetitive work so you don't have to.
What is MCP (Model Context Protocol)?
MCP is simply the way AI agents plug into your apps and services. When you connect something like MySQL Explorer to Lyra, it lets the AI take actions on your behalf.
How do I use MySQL Explorer?
Just install it inside Lyra. It only takes a moment. After that, your AI can instantly use MySQL Explorer—no setup, no technical knowledge required.