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

Features and capabilities supported by this server

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