mysql-mcp-server

mysql-mcp-server

1
databasesdeveloper_tools

The MySQL MCP Server is a database management tool built using FastMCP, designed to manage SQLite databases interactively. It features a server and a client component that facilitate listing tables, describing table schemas, and executing SQL queries. This project emphasizes ease of use with its natural language command support.

MySQL MCP Server

A powerful database management tool built with FastMCP that provides an interactive interface for managing SQLite databases.

Features

  • List all tables in the database
  • Get detailed schema information for any table
  • Execute SQL queries with formatted results
  • Interactive client interface for database operations

Prerequisites

  • Python 3.8 or higher
  • pip (Python package installer)

Usage

Once both the server and client are running, you can interact with the database using natural language commands. The client supports the following operations:

  1. List all tables in the database
  2. Get detailed schema information for any table
  3. Execute SQL queries to retrieve or modify data

Example commands:

  • "Show me all tables in the database"
  • "Describe the structure of the users table"
  • "Run a query to select all records from the users table"

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This project is licensed under the MIT License - see the LICENSE file for details.