Warehouse status & selection
manage_warehouseInspect SQL warehouses and selection logic: list ranked warehouses, check status, and determine which warehouse SQL tools use based on config and availability.
Instructions
Inspect SQL warehouses and the server's warehouse-selection logic. Selection is transparent and configurable: an explicit warehouse_id wins, then DBX_MCP_DEFAULT_WAREHOUSE_ID, then (with DBX_MCP_WAREHOUSE_SELECTION=prefer_running) the best visible warehouse ranked running > starting
stopped, then serverless > pro > classic, then name.
Safety classification: READ_ONLY.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | No | list: warehouses ranked for SQL execution; status: state/health of one warehouse; select: which warehouse SQL tools will use and why. | select |
| warehouse_id | No | Warehouse id for status (or to validate in select). | |
| require_running | No | For select: only accept a RUNNING warehouse. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| page | No | ||
| plan | No | ||
| tool | Yes | ||
| action | No | ||
| safety | No | ||
| status | No | success | |
| summary | Yes | ||
| warnings | No | ||
| next_steps | No | Suggested follow-up calls. | |
| request_id | No |