benborla_mcp-server-mysql

benborla_mcp-server-mysql

3.1

If you are the rightful owner of benborla_mcp-server-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

The MCP Server for MySQL based on NodeJS is designed to facilitate read-only interactions with MySQL databases. It allows Language Model Machines (LLMs) to access and inspect database schemas, execute read-only SQL queries, and retrieve schema information for each table. This server is particularly useful for applications that require database insights without the risk of data modification. It operates by executing all queries within a READ ONLY transaction, ensuring data integrity and security. The server automatically discovers table schemas from the database metadata, providing JSON schema information that includes column names and data types. This makes it an ideal tool for developers and data scientists who need to analyze database structures and contents without altering them.

Features

  • Read-only access to MySQL databases
  • Automatic discovery of table schemas
  • Execution of SQL queries within READ ONLY transactions
  • JSON schema information for each table
  • Integration with LLMs for database inspection

Tools

  1. mysql_query

    Execute read-only SQL queries against the connected database. Input: sql (string): The SQL query to execute. All queries are executed within a READ ONLY transaction.