# amitte/sql-explain-analyzer

> Read a Postgres EXPLAIN ANALYZE plan, identify the bottleneck node by cost and time, and recommend one to three indexes or rewrites likely to improve it.

## Identity

- **Type:** agent
- **Version:** 0.1.0
- **Trust tier:** official
- **License:** CC-BY-4.0
- **Authors:** Amitte Maintainers
- **Repo / bundle:** amitte/showcase
- **Canonical URL:** https://amitte.com/s/amitte/sql-explain-analyzer

## Tags

- **Capabilities:** postgres, explain-analyze, performance, indexing
- **Domains:** data, databases

## Evaluation

- **Adversarial score:** 100/100
- **Content score:** 95/100

## Endpoints

- **model-backed** `analyze-plan` → (internal) — Take a Postgres EXPLAIN ANALYZE plan and the originating SQL and return the bottleneck node and one to three suggested indexes or rewrites.

## Programmatic access

- Fetch JSON-RPC: `POST https://registry.amitte.com/rpc` with `{ "method": "fetch", "params": { "id": "amitte/sql-explain-analyzer" } }`
- Install via CLI: `amitte install amitte/sql-explain-analyzer`
- HTML page: https://amitte.com/s/amitte/sql-explain-analyzer

Last updated: 2026-06-27T00:09:37.250Z