{"library":"lzc-mysql-mcp","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"2.0.0","tags":["javascript","mcp","mysql","query","read-only","multi-database","ai","claude","codex","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install lzc-mysql-mcp","imports":["npx lzc-mysql-mcp","import { setupServer } from 'lzc-mysql-mcp/src/index.js'","import type { Config, ConnectionConfig } from 'lzc-mysql-mcp/dist/types.js'"]},{"cmd":"yarn add lzc-mysql-mcp","imports":[]},{"cmd":"pnpm add lzc-mysql-mcp","imports":[]}],"homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"lzc-mysql-mcp","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}