listTables
listTablesEnumerate table and view names in a database schema, optionally filtered by name or type. Does not return columns; use describeTable for one object's structure.
Instructions
Enumerate table and view names in a known schema, optionally filtered by name or type. Does not return fields/columns; use describeTable for one object's structure.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>"
},
"name": "listTables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| types | No | JDBC table types CSV (default TABLE,VIEW,MATERIALIZED VIEW): TABLE,VIEW,MATERIALIZED VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM | |
| schema | No | Omit to use the connection's defaultSchema or the current schema. | |
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namePattern | No | JDBC pattern ('%' any, '_' one character). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | No | Table and view entries. |