mysql-mcp

mysql-mcp

3.2

If you are the rightful owner of mysql-mcp 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.

The MySQL & PostgreSQL MCP Server is a read-only server for interacting with databases using the Model Context Protocol.

The MySQL & PostgreSQL MCP Server is designed to facilitate read-only interactions with MySQL and PostgreSQL databases. It allows clients to inspect database schemas, retrieve metadata, and execute read-only SQL queries. The server is built with extensibility in mind and enforces read-only operations to ensure data safety. It provides a suite of tools for schema and metadata retrieval, query execution, visualization, and performance monitoring. The server is particularly useful for developers and database administrators who need to access and analyze database structures without modifying the data.

Features

  • Schema & Metadata Tools: Retrieve and compare schema details, including tables, columns, indexes, and constraints.
  • Query Execution Tools: Execute read-only SQL queries and explain query execution plans.
  • Visualization Tools: Generate schema representations suitable for creating ER diagrams.
  • Performance Tools: Retrieve selected global status variables from MySQL.
  • Extensibility: Built with extensibility in mind, allowing for future tool additions.