Yooztech MCP MySQL Server

Provides read-only, safe MySQL access through MCP with library inference and query capabilities.

python

1

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "yooztech-mcp_mysql": {
      "command": "yooztech_mcp_mysql",
      "args": [],
      "env": {
        "DB_HOST": "127.0.0.1",
        "DB_PASS": "<your-strong-pass>",
        "DB_PORT": "3306",
        "DB_USER": "mcp_tool"
      }
    }
  }
}

You can securely read MySQL data through an MCP server that exposes safe, read-only access and smart database inference. Use it to list databases you have access to, infer a project’s database, inspect tables and schemas, and safely query rows with built-in protections.

How to use

Connect your MCP client to the yooztech_mcp_mysql MCP server to perform read-only MySQL operations. You will first list accessible databases, then infer the target database for your project, and finally inspect tables or fetch rows with parameterized queries. All actions respect a strict whitelist of tables and columns, and queries are constrained to prevent injection and multi-statement execution.

Recommended usage pattern: check which non-system databases you can access, infer the database associated with your current project, list the tables within that database, review the table schemas, and run safe, limited queries to retrieve only the needed rows. When you need to fetch data, specify the table, optional columns, and an optional where clause or ordering, and always rely on the built-in limit defaults to avoid large results.

How to install

Prerequisites: you need a runtime environment compatible with the MCP server executable type you choose (Python for the package, or a container/runtime like uvx). You will also require a MySQL database you can connect to with read-only privileges.

Step-by-step setup with a local Python package (example flow):

Install the package (example command shown later in the snippet).
Configure a read-only MySQL user in your database if not already present.
Run the MCP server via the provided command or your container runtime.

Step-by-step setup using uvx (recommended if you don’t want to install packages globally):

Additional notes

Configuration relies on environment variables for database connection. The server enforces a read-only policy by design and uses parameterized queries, plus a limit on results to protect data and performance.

Environment variables control connection details and access scope. You will typically set the database host, port, user, and password in a secure, least-privilege manner.

Security and best practices

Whitelist checks ensure only approved tables and columns can be read. Queries are parameterized to prevent injection, and multi-statement execution is blocked. The default result limit is 100 with a maximum of 1000 to prevent large data transfers.

Available tools

list_databases

List the databases accessible to the current account, excluding system databases.

infer_database

Infer the database name from project contents; can include minimal evidence statistics if requested.

list_tables

List tables within a specified database or the inferred database when none is provided.

get_table_schema

Retrieve table structure details including column definitions, primary key, indexes, and table comments.

select_rows

Safely query rows from a table with optional column selection, filtering, ordering, and a limit (default 100, max 1000).