Labsco
MCP SERVER

MySQL MCP Server

by LeonMelamud

MySQL for an assistant: find the table you need among hundreds, read its structure, run the query, and keep notes in the database itself.

Relational SQL Databases
Summary
Table search, for schemas too big to list.

Listing every table is useless past a certain size, and that size arrives sooner than people expect. Pattern search and a table count turn discovery into a question rather than a wall of output — which is the difference between an assistant that can work in a large legacy schema and one that cannot.

What it is

Direct MySQL access with a discovery layer on top. Tables can be counted and searched by pattern rather than only listed, which is what makes it usable against a schema too large to read. Notes stored in the database are readable as MCP resources.

What you get
  • Every table listed, and the total count
  • Tables searched by a LIKE pattern, for finding one among hundreds
  • The structure of a specific table
  • Arbitrary SQL executed
  • Notes created in the database, each with a title and content
  • Those notes exposed as resources, addressable individually
Requirements

A running MySQL server and a database with the permissions you intend to use, its host, user, password and database name supplied through the environment. Node.js 18 or newer.