MySQL MCP Server

Model Context Protocol server for MySQL database access.

Features

• Execute SQL queries with prepared statements

• List database tables

• Describe table schemas

• Get table statistics (row counts, sizes)

• Connection pooling for performance

Installation

Configuration

Configure via environment variables:

• MYSQL_HOST - MySQL server hostname (default: localhost)

• MYSQL_PORT - MySQL server port (default: 3306)

• MYSQL_USER - MySQL username (default: root)

• MYSQL_PASS - MySQL password (default: empty)

• MYSQL_DB - MySQL database name (default: empty)

Usage with Claude Code

Add to .claude/.mcp.json:

Available Tools

mysql_query

Execute any SQL query with optional prepared statement parameters.

Example:

mysql_show_tables

List all tables in the current database.

mysql_describe_table

Get the schema/structure of a specific table.

mysql_table_info

Get detailed table information including row counts and sizes.

License

MIT