list_indexes
Retrieve all index information for a specified table in Vertica databases to analyze database structure and optimize query performance.
Instructions
List all indexes for a specific table.
Args:
ctx: FastMCP context for progress reporting and logging
table_name: Name of the table to inspect
schema: Schema name (default: public)
Returns:
Index information as a string
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | public | |
| table_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"schema": {
"default": "public",
"title": "Schema",
"type": "string"
},
"table_name": {
"title": "Table Name",
"type": "string"
}
},
"required": [
"table_name"
],
"title": "list_indexesArguments",
"type": "object"
}