Alibaba Cloud DMS MCP Server

Official
by aliyun

getTableDetailInfo

Retrieve detailed metadata for a database table, including schema and index information, using a unique table identifier. Access column names, types, auto-increment status, and index details for better database management.

Instructions

Retrieve detailed metadata information about a specific database table including schema and index details. Parameters: table_guid (str): Unique table identifier(format: dmsTableId.schemaName.tableName). Obtained via searchTable or listTable tool. Returns: Dict[str, Any] containing: ColumnList: List of column metadata dictionaries with fields: - ColumnName(str): Name of the column - ColumnType (str): Full SQL type declaration (e.g., 'varchar(32)', 'bigint(20)') - AutoIncrement (bool): Whether the column is an auto-increment field - Description (str): Column comment/description text - Nullable (bool): Whether NULL values are allowed IndexList: List of index metadata dictionaries with fields: - IndexColumns (List[str]): List of column names included in the index - IndexName (str): Name of the index - IndexType (str): Type of index ('Primary', 'Unique', etc.) - Unique (bool): Whether the index enforces uniqueness

Input Schema

NameRequiredDescriptionDefault
table_guidYes

Input Schema (JSON Schema)

{ "properties": { "table_guid": { "title": "Table Guid", "type": "string" } }, "required": [ "table_guid" ], "title": "getMetaTableDetailInfoArguments", "type": "object" }

You must be authenticated.

Other Tools from Alibaba Cloud DMS MCP Server

Related Tools

ID: hyhi1ys72b