How do I configure the MySQL connection?

Connection details are configured using environment variables such as MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, and MYSQL_DB.

What kind of data can I retrieve from tables?

You can fetch data from specified tables, limited to a maximum of 100 rows per request.

What SQL queries can I execute?

You can execute SELECT, SHOW, EXPLAIN, and DESCRIBE queries.

What is the MySQL MCP Server?

It's an MCP (Model Context Protocol) server that allows you to interact with MySQL databases programmatically.

What are the available MCP tools?

The available tools include 'query' for executing SQL queries, 'table-schema' for retrieving table structure, and 'list-tables' for getting a list of all tables in the database.

Mysql

Name: Mysql
Author: vitalyDV

•

Enables interaction with MySQL databases via the Model Context Protocol (MCP).

MySQL empowers interaction with MySQL databases by implementing a Model Context Protocol (MCP) server. This allows execution of SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE), retrieval of table schemas, listing of database tables, and fetching data from specified tables, all through the MCP interface.

Key Features

01Lists all tables in a database.

02Executes SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE).

03Uses environment variables for MySQL connection configuration.

04Retrieves table schemas.

052 GitHub stars

06Fetches data from specified tables (up to 100 rows).

Use Cases

01Providing a read-only interface to a MySQL database.

02Automating database querying and schema inspection tasks.

03Integrating MySQL data into MCP-based applications.