Schema | just-a-mysql-mcp

just-a-mysql-mcp

Overview Schema Related Servers Score Discussions

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MYSQL_DB`	No	Alias for MYSQL_DATABASE.
`MYSQL_HOST`	No	MySQL host.	127.0.0.1
`MYSQL_PASS`	No	Alias for MYSQL_PASSWORD.
`MYSQL_PORT`	No	MySQL port.	3306
`MYSQL_USER`	No	MySQL username.
`MYSQL_DATABASE`	No	MySQL database name. Alias: MYSQL_DB
`MYSQL_PASSWORD`	No	MySQL password. Alias: MYSQL_PASS

Capabilities

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Tools

Functions exposed to the LLM to take actions

Name Description

Name	Description
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)`

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

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Server Configuration
Capabilities
Tools
Prompts
Resources

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/xingyuli/just-a-mysql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server