MCP Server for MySQL

MCPOpen Source14.7

by syntaxtrash • Data & Databases

A TypeScript-based MCP server that exposes MySQL database operations (list tables, show table schema and samples, run safe queries) to MCP-compatible agents.

Example Use Cases

1
Discover database structure and available tables in a MySQL database programmatically.
2
Retrieve a table's CREATE statement and example rows to understand schema and sample data.
3
Run safe data operations (SELECT, INSERT, UPDATE, DELETE) against a MySQL database via MCP with Docker or Node.js integration.

Description

This repository implements an MCP (Model Context Protocol) server written in TypeScript to interact with MySQL databases. It provides operations to list tables, retrieve table schema and sample rows, and execute safe SELECT/INSERT/UPDATE/DELETE queries. The project includes instructions for local development, Node.js integration, and running the server in Docker. It is intended to let agents safely access and manipulate MySQL data via the MCP standard.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D40/100

3/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

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownersyntaxtrash

CategoryData & Databases