List database tables
db_list_tablesLists all tables in the connected Oracle database excluding system schemas. Optionally filter by schema/owner name to discover tables before running queries.
Instructions
List all tables in the connected Oracle database (excluding system schemas like SYS, SYSTEM, etc.).
Use this FIRST to discover what tables exist before running queries.
Args:
owner (string, optional): Filter by schema/owner name (case-insensitive)
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "db_list_tables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| owner | No | Optional: filter by schema/owner name (case-insensitive). E.g., 'HR', 'APP'. If omitted, lists all non-system schemas. |