mcp-mysql-server

mcp-mysql-server

0
databases

The project is a Python-based command-line tool designed to simplify interactions with a local MySQL database using standard input/output. It supports Docker deployment and offers features like query execution and schema inspection, making it ideal for developers working in local environments.

MCP MySQL Server Overview

  • Description: A command-line tool designed for interacting with a local MySQL database using standard input/output, primarily for local development setups.
  • Features:
    • Execute SQL SELECT statements
    • Insert data into tables
    • Retrieve database schema details
    • Test database connections
    • Configurable access controls through a configuration file
    • Supports Docker deployment
  • Getting Started:
    • Requires Python 3.x and a local MySQL server
    • Install dependencies using requirements.txt
    • Configure access via config.ini, specifying MySQL connection details

Docker Support

Provides an option to run within Docker containers, enabling a quick setup of a MySQL server and the MCP MySQL Server.

Testing

Contains unit tests that simulate database interactions without an actual database connection, ensuring the reliability of functions.

Development

Developers can extend the tool by adding new functions using an @mcp.tool() decorator to handle specific database operations.