run_query_safely
Execute SQL queries on Vertica Analytics Database with built-in safety controls including size detection, pagination, and timeout management to prevent resource overload.
Instructions
Safe query execution with size detection, pagination, and timeout support.
Args:
query: SQL query to execute
row_threshold: Maximum rows before requiring confirmation
proceed: Whether to proceed with large result set
mode: Execution mode ('page' or 'stream')
page_limit: Rows per page when paginating
include_columns: Include column names in response
precount: Count total rows for large results (expensive)
timeout: Query timeout in seconds (default from env)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| row_threshold | No | ||
| proceed | No | ||
| mode | No | page | |
| page_limit | No | ||
| include_columns | No | ||
| precount | No | ||
| timeout | No |