MCP Vertica

MIT License

Overview InspectNew Endpoints Schema Related Servers Reviews Score

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

This server cannot be installed

Other Tools from MCP Vertica

Related Tools

execute_query
@nolleh/mcp-vertica
run_select_query
@gigapi/gigapi-mcp
query
@knight0zh/mssql-mcp-server
query_database
@jdbcx/pydbcx-mcp
handle_execute_ad_hoc_query
@vinodismyname/redshift-utils-mcp
execute_sql
@oceanbase/mcp-oceanbase

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