lzc-mysql-mcp

A read-only MCP (Model Context Protocol) server for querying MySQL databases via stdio transport, supporting multi-database connections, custom table hints, and automatic LIMIT/timeout enforcement. Current stable version is 2.0.0. It is published on npm and can be run immediately with npx without cloning or building. Key differentiators include zero-install usage, multi-source configuration via a single JSON file, table description prompts for AI awareness, and strict read-only enforcement at the protocol level (only SELECT/SHOW/DESCRIBE/EXPLAIN allowed). Uses mysql2 connection pools (max 5 concurrent) and formats results as Markdown tables. Designed for integration with Claude Code, OpenAI Codex, Claude Desktop, Cursor, and Windsurf. Published under MIT license.