MySQL MCP Server

MCPOpen SourceMIT40.7

by kevinwatt • Data & Databases

A Node.js MCP server that provides secure, controlled MySQL database access for LLMs and agent integrations.

Example Use Cases

1
Secure, read-only access to MySQL data with query length and result-size safeguards.
2
Perform parameterized INSERT/UPDATE/DELETE operations with automatic transaction handling and returned affected row/insert ID info.
3
Discover database structure and schema (list tables, describe table columns) before formulating queries.

Description

This MCP server implements a MySQL-backed service exposing read and write database operations tailored for use by LLM agents. It supports read-only SELECT queries with limits and timeouts, as well as transactional INSERT/UPDATE/DELETE with parameterized queries and automatic transaction handling. The server includes safety and monitoring features such as query length/result size limits, performance logging, and read-only transaction mode. It's packaged for easy installation (npm) and integration with Dive Desktop and other MCP-compatible LLM services.

Capabilities(4 total)

Tools (4)

mysql_query

Execute read-only SELECT queries against the MySQL database. - Maximum query length: 4096 characters - Maximum result rows: 1000 - Query timeout: 30 seconds

sql:string*

mysql_execute

Execute data modification queries (INSERT/UPDATE/DELETE). - Returns affected rows count and insert ID - Supports parameterized queries - Automatic transaction handling

sql:string*params:array

list_tables

List all tables in current database

describe_table

Show table structure

table:string*

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C56/100

6/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities4 Tools / 0 Prompts / 0 Resources

Ownerkevinwatt

CategoryData & Databases

DependenciesStandalone

Set Your Username