Skip to main content
Glama
xingyuli

just-a-mysql-mcp

by xingyuli
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_DBNoAlias for MYSQL_DATABASE.
MYSQL_HOSTNoMySQL host.127.0.0.1
MYSQL_PASSNoAlias for MYSQL_PASSWORD.
MYSQL_PORTNoMySQL port.3306
MYSQL_USERNoMySQL username.
MYSQL_DATABASENoMySQL database name. Alias: MYSQL_DB
MYSQL_PASSWORDNoMySQL password. Alias: MYSQL_PASS

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_tablesA

List tables in the bound database. Returns table names only (schema browsing — no row data).

describe_tableA
Describe columns for one table in the bound database.

Args:
    table: Unquoted table name (letters, digits, underscore)
mysql_queryA
Run one read-only SQL statement against the bound database.

Allowed: SELECT (including WITH…SELECT), SHOW, DESCRIBE/DESC, EXPLAIN.
Results are capped (default 100 rows, max 1000); truncation is explicit.

Args:
    sql: A single read-only SQL statement
    limit: Max rows to return (default 100, max 1000)

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A4.1/5.0

Scored across 3 tools

Disambiguation4/5

The tools are mostly distinct in purpose: list_tables for table names, describe_table for column details, and mysql_query for arbitrary read-only SQL. However, mysql_query also supports DESCRIBE/DESC, creating a partial overlap with describe_table.

Naming Consistency4/5

list_tables and describe_table follow a clear verb_noun pattern, but mysql_query deviates with a noun_verb structure. All names are snake_case and readable, so the inconsistency is minor.

Tool Count4/5

Three tools is a minimal but well-scoped set for a read-only MySQL server. It is slightly on the small side, but each tool serves a distinct core need and the count fits the intentional minimalism.

Completeness4/5

The set covers the essential read-only workflow: discovering tables, inspecting schema, and running queries. Missing explicit tools for views/indexes are easily handled via mysql_query, so gaps are minor.

Maintenance

ActivitySlowing
ResponsivenessNo issues

Resources