@enemyrr/mcp-mysql-server

git clone https://github.com/enemyrr/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build

DATABASE_URL=mysql://user:password@host:3306/database

DB_HOST=localhost
DB_USER=your_user
DB_PASSWORD=your_password
DB_DATABASE=your_database

use_mcp_tool({
 server_name: "mysql",
 tool_name: "connect_db",
 arguments: {
 url: "mysql://user:password@host:3306/database"
 // OR
 workspace: "/path/to/your/project" // Will use project's .env
 // OR
 host: "localhost",
 user: "your_user",
 password: "your_password",
 database: "your_database"
 }
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "query",
 arguments: {
 sql: "SELECT * FROM users WHERE id = ?",
 params: [1]
 }
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "execute",
 arguments: {
 sql: "INSERT INTO users (name, email) VALUES (?, ?)",
 params: ["John Doe", "john@example.com"]
 }
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "list_tables"
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "describe_table",
 arguments: {
 table: "users"
 }
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "create_table",
 arguments: {
 table: "users",
 fields: [
 {
 name: "id",
 type: "int",
 autoIncrement: true,
 primary: true
 },
 {
 name: "email",
 type: "varchar",
 length: 255,
 nullable: false
 }
 ],
 indexes: [
 {
 name: "email_idx",
 columns: ["email"],
 unique: true
 }
 ]
 }
});

use_mcp_tool({
 server_name: "mysql",
 tool_name: "add_column",
 arguments: {
 table: "users",
 field: {
 name: "phone",
 type: "varchar",
 length: 20,
 nullable: true
 }
 }
});

Looking for Admin?