stream_query
Execute SQL queries on Vertica databases and retrieve results in manageable batches to handle large datasets efficiently without overwhelming memory resources.
Instructions
Execute a SQL query and return the results in batches as a single string.
Args:
ctx: FastMCP context for progress reporting and logging
query: SQL query to execute
batch_size: Number of rows to fetch at once
Returns:
Query results as a concatenated string
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| batch_size | No | ||
| query | Yes |