create_index
Define indexes on specified table columns to optimize query performance and accelerate data retrieval in CockroachDB databases using table_name, index_name, and column parameters.
Instructions
Create a new index on a specified table to improve query performance. This tool allows users to define indexes on one or more columns, enabling faster data retrieval and optimized execution plans for read-heavy workloads.
Args: table_name (str): Name of the table. index_name (str): Name of the index. columns (List[str]): List of column names to include in the index.
Returns: A success message or an error message.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table_name": "<table_name>",
"index_name": "<index_name>",
"columns": "<columns>"
},
"name": "create_index"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | Yes | ||
| index_name | Yes | ||
| table_name | Yes |