MySQL Query MCP Server
About
MySQL Query MCP server for AI assistants - execute read-only MySQL queries
Details
- Author
- devakone
- GitHub stars
- 13
- Downloads
- 227
- Categories
- Database
Jump to
- Read-only MySQL queries (SELECT, SHOW, DESCRIBE)
- Predefined environments: local, development, staging, production
- SSL support for secure database connections
- Query timeout to prevent long-running operations
- Database information and metadata retrieval
- Lists available database environments
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MySQL Query MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install globally with npm install -g mysql-query-mcp-server or run instantly with npx mysql-query-mcp-server. Configure your AI tool’s MCP settings (e.g., .cursor/mcp.json) with environment variables for database credentials (LOCAL_DB_HOST, LOCAL_DB_USER, etc.). The server exposes three tools: query (read-only SQL), info (database metadata), and environments (list configured environments).
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql query mcp server": {
"mysql-query-mcp-server": {
"command": "npx",
"args": [
"mysql-query-mcp-server"
]
}
}
}
}McpServers
{
"mysql-query-mcp-server": {
"command": "npx",
"args": [
"mysql-query-mcp-server"
]
}
}MySQL Query MCP Server
A Model Context Protocol (MCP) server that provides read-only MySQL database queries for AI assistants. Execute queries, explore database structures, and investigate your data directly from your AI-powered tools.
<a href="https://glama.ai/mcp/servers/@devakone/mysql-query-mcp-server">
</a>
Supported AI Tools
This MCP server works with any tool that supports the Model Context Protocol, including:
- Cursor IDE: Set up in .cursor/mcp.json
- Anthropic Claude: Use with a compatible MCP client
- Other MCP-compatible AI assistants: Follow the tool's MCP configuration instructions
Features & Limitations
What It Does
- ✅ Execute read-only MySQL queries (SELECT, SHOW, DESCRIBE only) - ✅ Work with predefined environments (local, development, staging, production) - ✅ Provide database information and metadata - ✅ List available database environments - ✅ Support SSL connections for secure database access - ✅ Implement query timeouts to prevent long-running operationsWhat It Doesn't Do
- ❌ Execute write operations (INSERT, UPDATE, DELETE, CREATE, ALTER, etc.) - ❌ Support custom environment names (limited to local, development, staging, production) - ❌ Provide database design or schema generation capabilities - ❌ Function as a full database management toolThis tool is designed specifically for data investigation and exploration through read-only queries. It is not intended for database administration, schema management, or data modification.
Quick Install
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
