1 required secret

MySQL

Execute SQL queries and explore MySQL databases with structured access control

Containerized Updated 6 hours ago
DatabasesData & Analytics

About

Tests PyPI - Downloads

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

VariableDescriptionRequired
MYSQL_HOSTThe hostname or IP address of your MySQL databaseYes
MYSQL_PORTThe port number of your MySQL database. Defaults to 3306.No
MYSQL_USERThe username for your MySQL database.Yes
MYSQL_PASSWORDThe password for your MySQL database.Yes
MYSQL_DATABASEThe 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