stream_query
Execute SQL queries on Vertica databases and retrieve results in manageable batches, optimizing memory usage and performance for large datasets.
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
| Name | Required | Description | Default |
|---|---|---|---|
| batch_size | No | ||
| query | Yes |
Input Schema (JSON Schema)
{
"properties": {
"batch_size": {
"default": 1000,
"title": "Batch Size",
"type": "integer"
},
"query": {
"title": "Query",
"type": "string"
}
},
"required": [
"query"
],
"title": "stream_queryArguments",
"type": "object"
}