Schema | TiDB Cloud Zero MCP Server

TiDB Cloud Zero MCP Server

Describes the environment variables required to run the server.

Name	Required	Description
`TIDB_URL`	No	MySQL connection string for your own TiDB Cloud instance (e.g., mysql://user:password@host/database)
`TIDB_HOST`	No	TiDB Cloud host (e.g., gateway01.us-west-2.prod.aws.tidbcloud.com)
`TIDB_DATABASE`	No	TiDB Cloud database name
`TIDB_PASSWORD`	No	TiDB Cloud password
`TIDB_USERNAME`	No	TiDB Cloud username

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

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

Functions exposed to the LLM to take actions

Name	Description
queryA	Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN). Returns results as a formatted table. Examples: query("SELECT * FROM users LIMIT 10") query("SHOW TABLES") query("DESCRIBE users")
executeA	Execute a write SQL statement (CREATE, INSERT, UPDATE, DELETE, ALTER, DROP). Returns the number of affected rows. Examples: execute("CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255))") execute("INSERT INTO users (name) VALUES ('Alice')")
batch_executeA	Execute multiple SQL statements sequentially. Args: statements: List of SQL statements to execute in order Example: batch_execute([ "CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255))", "INSERT INTO users (name) VALUES ('Alice')", "INSERT INTO users (name) VALUES ('Bob')" ])
list_tablesA	List all tables in the current database with row counts.
describe_tableA	Get the schema of a table (columns, types, keys). Args: table: Table name to describe
get_database_infoA	Get database connection info, TiDB version, and instance status.

Interactive templates invoked by user choice

Name	Description
`create_crud_table`	Generate SQL to create a table with common CRUD patterns.
`analyze_data`	Generate a data analysis workflow for a table.

Contextual data attached and managed by the client

Name	Description
`resource_tables`	List of all tables in the database.
`resource_info`	Database connection info and TiDB version.

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/siddontang/tidb-cloud-zero-mcp'

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