MySQL MCP Server

Example Use Cases

• 1

  Run ad-hoc SELECT queries against a MySQL database and retrieve results as structured JSON.

• 2

  Modify database state (INSERT/UPDATE/DELETE), create tables, and manage schema programmatically.

• 3

  Analyze data and automatically record business insights into a persistent memo (memo://insights) for later retrieval.

Description

This MCP server exposes tools to execute SELECT and modification SQL, create tables, list and describe schema, and append business insights into a continuously updated memo. It uses mysql2 for database connectivity and provides a memo://insights resource that aggregates discovered business intelligence. Configuration is via a .env file and the project is distributed under the MIT license for self-hosting and integration with Claude or other agents.

Capabilities(1 total)