- Category
- Developer Tools
- Rank
- No. 3902Tools index
Previous survey · No. 3733 ·
- Pricing
- Open Source
- Type
- TOOL
- Use case
- Deployment & Operations
- Interfaces
- CLI
- GitHub
- 2 stars
- Latest release
- v1.5.0
- Date
About
iCli is a Go command-line tool that reads PostgreSQL query statistics, explains the most expensive queries and flags plan bottlenecks. It also detects foreign keys missing a covering index and reports unused indexes. It runs only read-only SQL, so it does not modify data.
At a glance
iCli inspects PostgreSQL query statistics, plans and index signals from a terminal. It is worth evaluating when you need leads on repeated or slow queries before choosing what to optimize.
Good fit
Developers with an approved database role and a representative test workload.
Consider something else when
Use application traces when you need to know exactly which request or code path issued each query.
Start here
Run a known repetitive workload in staging. Compare the profiler’s findings with application logs and review the plan before changing an index.
Cost and requirements
Go CLI requiring a PostgreSQL connection and access to the relevant statistics. The project documents a read-only profiling workflow.
Limits to know
Repeated query shapes can suggest an N+1 pattern without proving its cause. Treat index suggestions as hypotheses and measure query behavior before acting.
Sources checked 2026-11-05. Source-based assessment.
Tags
Tech Stack
Comments (0)
No comments yet
Editorially curated, with community endorsements as a secondary signal. Corrections welcome.