MySQL MCP Server
Description
# MySQL MCP Server A powerful database management tool built with FastMCP that provides an interactive interface for managing SQLite databases. This project includes both a server component and a client interface for easy database operations. ## Features - List all tables in the…
About
# MySQL MCP Server A powerful database management tool built with FastMCP that provides an interactive interface for managing SQLite databases. This project includes both a server component and a client interface for easy database operations. ## Features - List all tables in the database - Get detailed schema…
Details
- Author
- sajithamma
- GitHub stars
- 1
- Downloads
- 288
- Categories
- Database
Jump to
- List all tables in the SQLite database.
- Get detailed schema information for any table.
- Execute SQL queries with formatted results.
- Interactive client interface for database operations.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MySQL MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Set up a Python 3.8+ environment, clone the repository, install dependencies, and run the fixture to create the database. Start the server with fastmcp run mcpserver.py:mcp --transport sse --host 127.0.0.1 --port 8000, then run the client with python mcpclient.py. Use natural language commands like "Show me all tables in the database" or "Describe the structure of the users table".
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql mcp server": {
"mysql-mcp-server-sajithamma": {
"command": "python",
"args": [
"sqlite_fixture.py"
]
}
}
}
}McpServers
{
"mysql-mcp-server-sajithamma": {
"command": "python",
"args": [
"sqlite_fixture.py"
]
}
}MySQL MCP Server
A powerful database management tool built with FastMCP that provides an interactive interface for managing SQLite databases. This project includes both a server component and a client interface for easy database operations.
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)
Setup
1. Clone the repository:
git clone git@github.com:sajithamma/mysql-mcp-server.git
cd mysql-mcp-server
2. Create and activate a virtual environment:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
