MySQL MCP Server v2

A MySQL-based MCP server to manage department budgets, query status, and register budget requests.

python

0

GitHub Stars

python

Language

7 months ago

First Indexed

3 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": {
    "w2pwinlinux-mcp-server-presupuesto-mysql1": {
      "command": "python",
      "args": [
        "mysql_mcp_server_v2.py"
      ]
    }
  }
}

This MCP server provides a MySQL-backed interface to manage department budgets, expose budget status, and record budget requests. It runs locally via a Python-based MCP server and communicates with a MySQL database to perform queries and transactional updates, making it a practical backend for budgeting workflows.

How to use

Start by running the MCP server locally so clients can connect to it. Use a standard MCP client to send requests for the following capabilities: get_estado_completo to retrieve the full budget status for a department by its code, registrar_solicitud to register a new budget request for a department, and buscar_por_nombre to search departments by name with partial matches. Once the server is running, you can perform read operations on department data, create new budget requests, and look up departments by name.

How to install

Prerequisites you need before installation are Python 3.6 or newer and a running MySQL server.

Install the required Python packages.

pip install mcp mysql-connector-python

Additional sections

Configuration parameters for the database connection are defined in the server setup. You will typically adjust the host, port, user, password, and database name to match your MySQL instance.

Security and reliability notes include safe handling of database connections using a context manager pattern and proper transaction handling with commits and rollbacks.

Execution to start the server is done with Python, pointing to the server script file.

python mysql_mcp_server_v2.py

Available tools

get_estado_completo

Fetches the complete budget status for a department by its code, returning details such as code, name, initial budget, requested amount, available balance, and paid amount.

registrar_solicitud

Registers a new budget request for a department, updates the requested amount, recalculates the available balance, and ensures transaction-safe handling.

buscar_por_nombre

Searches departments by name using partial matching, returning all matching departments with full details.