mcp-server-mamp-mysql
If you are the rightful owner of mcp-server-mamp-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that provides MySQL database access functionality.
MySQL MCP Server
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 pooling
Installation
- Clone this repository
- Install dependencies:
npm install
- Build the project:
npm run build
Configuration
Set the following environment variables:
MYSQL_HOST
: MySQL server hostMYSQL_PORT
: MySQL server portMYSQL_USER
: MySQL usernameMYSQL_PASS
: MySQL passwordMYSQL_DB
: MySQL database nameMYSQL_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