1 required secret
MySQL
Execute SQL queries and explore MySQL databases with structured access control
DatabasesData & Analytics
About
Execute SQL queries and explore MySQL databases through a structured, controlled interface.
Features
- Database Exploration: List available MySQL tables as resources and read table contents
- Query Execution: Execute SQL queries with proper error handling and comprehensive logging
- Resource Management: Structured interface for safer database operations
What you’ll need to connect
Required:
- MySQL Host: Database host (e.g. localhost)
- MySQL User: Database username
- MySQL Password: Database password
- MySQL Database: Database name
Optional:
- MySQL Port: Database port (default: 3306)
Security Tips:
- Create a dedicated MySQL user with minimal required permissions
- Never use root credentials or administrative accounts
- Follow the principle of least privilege when configuring database access
Configuration
Environment variables
| Variable | Description | Required |
|---|---|---|
MYSQL_HOST | The hostname or IP address of your MySQL database | Yes |
MYSQL_PORT | The port number of your MySQL database. Defaults to 3306. | No |
MYSQL_USER | The username for your MySQL database. | Yes |
MYSQL_PASSWORD | The password for your MySQL database. | Yes |
MYSQL_DATABASE | The name of your MySQL database. | Yes |
Container runtime
- Image
ghcr.io/obot-platform/mcp-images/mysql-mcp-server:0.2.2- Port
8099- Path
/- Args
mysql_mcp_server