Connect to MySQL databases for querying and schema management
npx -y @modelcontextprotocol/server-mysql
Paste this into your MCP client configuration (Cursor, Windsurf, etc).
Connect your AI assistant to MySQL databases.
npm install @modelcontextprotocol/server-mysql
Add to your MCP settings:
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/server-mysql"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "password",
"MYSQL_DATABASE": "mydb"
}
}
}
}
query: Execute SELECT queriesexecute: Execute INSERT/UPDATE/DELETEdescribe: Get table schemalist_tables: List all tablesMCP (Model Context Protocol) servers extend your AI assistant with external tools and data sources. Follow these steps to install MySQL MCP Server in your preferred AI coding tool.
claude_desktop_config.jsonConnect Claude to PostgreSQL databases for natural language data querying, schema exploration, and SQL generation.
Connect to Supabase for database queries, auth, and storage operations.
Query and manage SQLite databases for local data storage and analysis.
Access and modify Airtable bases