MySQL
About
Connects to MySQL databases via sockets to enable querying, schema analysis, and read-only data retrieval.
Details
- Repository
- kerongon/mcp-server-mamp-mysql
- License
- MIT
Explore
- List database tables and their schemas
- Execute read-only SQL queries
- Secure connection handling with connection pooling
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
MySQLCommand (node, npx, python, etc.)npxArguments-
Argument 1
-y -
Argument 2
@highlight/mcp-server
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
1. Clone this repository
2. Install dependencies:
npm install
3. Build the project:
npm run build
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql": {
"env": {},
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}
}
}Linux
{
"env": [],
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}Macos
{
"env": [],
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}Windows
{
"env": [],
"args": [
"/c",
"npx",
"-y",
"@highlight/mcp-server"
],
"command": "cmd"
}A Model Context Protocol (MCP) server that provides MySQL database access functionality.
Features
- List database tables and their schemas - Execute read-only SQL queries - Secure connection handling with connection poolingInstallation
1. Clone this repository
2. Install dependencies:
npm install
3. Build the project:
npm run build
Configuration
Set the following environment variables:
- MYSQL_HOST: MySQL server host
- MYSQL_PORT: MySQL server port
- MYSQL_USER: MySQL username
- MYSQL_PASS: MySQL password
- MYSQL_DB: MySQL database name
- MYSQL_SOCKET: MySQL socket path (alternative to host/port)
- MYSQL_POOL_LIMIT: Connection pool limit (default: 10)
Usage
The server will automatically start when the MCP system initializes it. You can then use the provided tools and resources through the MCP interface.
License
MIT
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
