List PostgreSQL Indexes
pg_list_indexesList indexes in a PostgreSQL schema, optionally filtering by table. Get index name, type, uniqueness, size, and definition in JSON or Markdown format.
Instructions
List indexes in a schema, optionally filtered to a specific table.
Args:
schema: Schema name (default: public)
table: Filter to a specific table (optional)
response_format: Output format
Returns: JSON: { indexes: IndexInfo[], count: number } Markdown: formatted table with name, table, type, uniqueness, size, definition
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | PostgreSQL schema name (default: public) | public |
| table | No | Filter to this table only (optional) | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |