mcp-registry/@f4ww4z/mcp-mysql-server

    ==================
      
       /// MCP ///
      /// @F4 ///
        
    ==================
        
    [server:online]
    [protocol:ready]

@f4ww4z/mcp-mysql-server

by f4ww4z

A Model Context Protocol (MCP) server that exposes MySQL database operations through a standard tool interface.

94
20
Open Source
GitHubNPM

01

connect_db

Establish a connection to a MySQL database using provided credentials

02

query

Execute SELECT queries with optional prepared-statement parameters

03

execute

Execute INSERT, UPDATE, or DELETE queries with optional prepared-statement parameters

04

list_tables

List all tables in the currently connected database

05

describe_table

Retrieve the structure (schema) of a specified table

Installation

1. Prerequisites:
• Node.js ≥ 18
• A running MySQL instance and credentials with CREATE/ALTER/SELECT/INSERT/UPDATE/DELETE privileges.
• Git (to clone the repository).
2. Clone the repository:
git clone https://github.com/f4ww4z/mcp-mysql-server.git cd mcp-mysql-server
3. Install dependencies:
npm install # or: yarn install
4. Configure the server (environment variables or .env file):
DB_HOST=localhost DB_PORT=3306 DB_USER=root DB_PASSWORD=secret DB_NAME=mcp # Optional SERVER_PORT=3000 # Port where MCP server will listen MCP_API_KEY=<your-token> # If API-key protection is enabled
5. Database preparation (if needed):
npm run migrate # If a migration script exists
6. Start the MCP-MySQL server:
npm start # production mode # or npm run dev # development mode with live reload (nodemon)
7. Verify:
Access `http://localhost:3000/health` (or the health-check route) – should return `{ status: "ok" }`.
8. Container option:
docker build -t mcp-mysql-server . docker run -e DB_HOST=host.docker.internal -p 3000:3000 mcp-mysql-server

Documentation

License: MIT License
Updated 7/30/2025