execute_query
Run SQL queries on Vertica databases to retrieve and analyze data, supporting connection pooling and secure SSL/TLS connections for database operations.
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"
}