hkk101_mcp-server-mysql
0
The project is a Model Context Protocol server designed for read-only access to MySQL databases, facilitating schema inspection and query execution by large language models. It includes components for executing read-only SQL queries and providing schema information automatically.
MCP Server for MySQL based on NodeJS
A Model Context Protocol server that provides read-only access to MySQL databases. This server enables large language models to inspect database schemas and execute read-only queries.
Components
Tools
- mysql_query: Execute read-only SQL queries against the connected database. All queries are executed within a READ ONLY transaction.
Resources
- Table Schemas: Provides JSON schema information for each table, including column names and data types, automatically discovered from database metadata.
Usage with Claude Desktop
To use this server with the Claude Desktop app, add the relevant configuration to the claude_desktop_config.json file.