MCP ServersMCP Servers

MySQL MCP Server

Created at 7 months ago

by OTA-EITA

starstarstarstarstar

Categories

databases

Tags

mysql

mcp

database-server

Visit MySQL MCP Server 👉
MySQL MCP Server

What is MySQL MCP Server?

MySQL MCP Server is a server that facilitates interaction with MySQL databases using the Model Context Protocol (MCP). It provides an interface for accessing MySQL databases in a WSL (Windows Subsystem for Linux) environment.

How to use MySQL MCP Server?

To use the MySQL MCP Server, clone the repository, set up a virtual environment, install dependencies, and run the server using one of the provided methods (direct execution, module execution, or Docker).

Key features of MySQL MCP Server?

  • Retrieve a list of tables in the MySQL database.
  • Read data from tables (up to 100 rows).
  • Execute SQL queries (SELECT, SHOW TABLES, INSERT, UPDATE, DELETE, etc.).

Use cases of MySQL MCP Server?

  1. Accessing and managing MySQL databases in a WSL environment.
  2. Executing SQL queries programmatically.
  3. Integrating with applications that require database interactions.

FAQ from MySQL MCP Server?

  • What are the prerequisites for using MySQL MCP Server?

You need Python 3.11 or higher, a MySQL server, a virtual environment, and optionally Docker.

  • Can I run this server on Windows?

Yes, it is designed to work with WSL, allowing you to run MySQL in a Linux environment on Windows.

  • Is there a license for this project?

Yes, this project is released under the MIT license.

View More