listTables

Search for database tables by databaseId and optional table name. Retrieve table details efficiently, enabling precise metadata access and management in Alibaba Cloud DMS.

Instructions

Search for tables by databaseId and (optional) table name. If you don't know the databaseId, first use getDatabase or searchDatabase to retrieve it.(1)If you have the exact host, port, and database name, use getDatabase.(2)If you only know the database name, use searchDatabase.(3)If you don't know any information, ask the user to provide the necessary details.Note: searchDatabase may return multiple databases. In this case, let the user choose which one to use.

Input Schema

Name	Required	Description
`database_id`	Yes	DMS databaseId
`page_number`	No	Pagination page number
`page_size`	No	Results per page (max 200)
`search_name`	No	Optional: Search keyword for table names

Input Schema (JSON Schema)

{
  "properties": {
    "database_id": {
      "description": "DMS databaseId",
      "title": "Database Id",
      "type": "string"
    },
    "page_number": {
      "default": 1,
      "description": "Pagination page number",
      "title": "Page Number",
      "type": "integer"
    },
    "page_size": {
      "default": 200,
      "description": "Results per page (max 200)",
      "title": "Page Size",
      "type": "integer"
    },
    "search_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional: Search keyword for table names",
      "title": "Search Name"
    }
  },
  "required": [
    "database_id"
  ],
  "title": "list_tablesArguments",
  "type": "object"
}

Alibaba Cloud DMS MCP Server

listTables

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Alibaba Cloud DMS MCP Server

Related Tools

MCP directory API