Skip to main content
Glama

MCP Vertica

by nolleh

stream_query

Execute SQL queries on MCP Vertica and retrieve results in manageable batches, enabling efficient data processing and reducing memory overhead for large datasets.

Instructions

Execute a SQL query and stream the results in batches.

Args: ctx: FastMCP context for progress reporting and logging query: SQL query to execute batch_size: Number of rows to fetch at once Yields: Batches of query results as strings

Input Schema

NameRequiredDescriptionDefault
batch_sizeNo
queryYes

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" }
Install Server

Other Tools from MCP Vertica

Related Tools

    MCP directory API

    We provide all the information about MCP servers via our MCP API.

    curl -X GET 'https://glama.ai/api/mcp/v1/servers/nolleh/mcp-vertica'

    If you have feedback or need assistance with the MCP directory API, please join our Discord server