MySQL Database Access MCP Server

Created By
MCP-Mirrora year ago
Mirror of
Overview

what is MySQL Database Access MCP Server?

MySQL Database Access MCP Server is a server that provides read-only access to MySQL databases, allowing users to interact with their databases securely and efficiently.

how to use MySQL Database Access MCP Server?

To use the server, install it via NPM or build it from source, configure the necessary environment variables, and add it to your MCP settings. You can then use various tools to interact with your MySQL databases.

key features of MySQL Database Access MCP Server?

  • Read-only access to databases
  • Query validation to prevent SQL injection
  • Query timeout to manage resource consumption
  • Row limit to prevent excessive data return

use cases of MySQL Database Access MCP Server?

  1. Listing available databases and tables.
  2. Describing table schemas for better understanding.
  3. Executing read-only SQL queries for data retrieval.

FAQ from MySQL Database Access MCP Server?

  • Can I modify data using this server?

No, the server only allows read-only operations to ensure data integrity.

  • How do I install the server?

You can install it globally via NPM or build it from source by cloning the repository.

  • What types of queries can I execute?

You can execute SELECT, SHOW, DESCRIBE, and EXPLAIN statements only.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
MCP-Mirror
Star
0
Language
JavaScript
License
MIT license
Category
databases

Recommend Servers

View All
Shippo
@Shippo

20 hours ago
Mnemom

13 hours ago