mcp-data-connector-mysql

This module provides an MCP server implementation focused on extracting schema information from a MariaDB environment.

Capabilities

Exposed Endpoints

Provision access to the catalog structure residing within the database.

Functionality Set

• execute_read_only_query
• Facilitates non-mutating data retrieval executions against the underlying MariaDB system.

Prerequisite Setup

MariaDB Client Installation Guidance

• Mac OS Environment
• During the installation of MariaDB components, you might encounter an os error stemming from a missing dependency. The resolution involves ensuring mariadb-connector-c is present.

bash OSError: mariadb_config not found.

  This error typically indicates that MariaDB Connector/C, a dependency which
  must be preinstalled, is not found.
  If MariaDB Connector/C is not installed, see installation instructions
  If MariaDB Connector/C is installed, either set the environment variable
  MARIADB_CONFIG or edit the configuration file 'site.cfg' to set the
   'mariadb_config' option to the file location of the mariadb_config utility.

1. Run: brew install mariadb-connector-c
2. Update shell profile: echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc
3. Explicitly define the configuration variable: export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config
4. Re-attempt package installation: uv add mariadb

Integration with Claude Desktop Environment

Configuration Manifest

File locations for the Claude Desktop configuration utility:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json

Manifest Addition for Published Service Endpoints

{ "mcpServers": { "mcp_server_mariadb": { "command": "/PATH/TO/uvx" "args": [ "mcp-server-mariadb", "--host", "${DB_HOST}", "--port", "${DB_PORT}", "--user", "${DB_USER}", "--password", "${DB_PASSWORD}", "--database", "${DB_NAME}" ] } } } **Note**: Substitute the bracketed placeholders with the actual execution file path: - `/PATH/TO/uvx`: Absolute path to the `uvx` binary.

Manifest Addition for Unreleased/Development Service Endpoints

{ "mcpServers": { "mcp_server_mariadb": { "command": "/PATH/TO/uv", "args": [ "--directory", "/YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb", "run", "server.py" ], "env": { "MARIADB_HOST": "127.0.0.1", "MARIADB_USER": "USER", "MARIADB_PASSWORD": "PASSWORD", "MARIADB_DATABASE": "DATABASE", "MARIADB_PORT": "3306" } } } } **Note**: Replace these placeholders with necessary paths: - `/PATH/TO/uv`: Absolute path to the UV executable. - `/YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb`: Directory pointing to the server source code base.

Licensing Information

This data connector is released under the MIT license. Refer to the LICENSE file within the repository structure for full terms.