execute_query
Run SQL queries on Vertica databases directly within the MCP Vertica server. Streamline data retrieval and analysis by executing queries efficiently, with support for connection pooling and schema management.
Instructions
Execute a SQL query and return the results.
Args:
ctx: FastMCP context for progress reporting and logging
query: SQL query to execute
database: Optional database name to execute the query against
Returns:
Query results as a string
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes |
Input Schema (JSON Schema)
{
"properties": {
"query": {
"title": "Query",
"type": "string"
}
},
"required": [
"query"
],
"title": "execute_queryArguments",
"type": "object"
}