indexes
Manage PostgreSQL database indexes by listing, creating, dropping, analyzing usage, rebuilding, and identifying unused indexes to optimize query performance.
Instructions
Index management: list, create, drop indexes and analyze index usage
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Action: list (all indexes), create (new index), drop (remove index), analyze (index statistics), reindex (rebuild index), unused (find unused indexes) | |
| columns | No | Column names for index (required for create) | |
| indexName | No | Index name (required for drop, reindex) | |
| options | No | Index creation options | |
| schemaName | No | Schema name (default: public) | public |
| tableName | No | Table name (required for create, list by table) |