iCli

Tired of running manual SQL diagnostics? iCli is a lightweight terminal tool that safely audits your PostgreSQL database—spotting missing indexes, expensive queries, unused indexes and plan bottlenecks instantly, with zero data mutation and much more.

No need to do EXPLAIN ANALYZE on each query just one terminal and you are done , you've identified and fixed your database performance

Key Features

• Expensive Query Analysis: Leverage pg_stat_statements to pinpoint slow and resource-intensive queries that affect performance.
• ** Gives actual actionable sql queries, so you can just copy and execute it .
• Execution Plan Profiling: Utilize EXPLAIN (FORMAT JSON) to identify execution plan bottlenecks such as sequential scans and inefficient joins, enabling more efficient query planning.
• Missing Foreign Key Index Detection: Quickly locate foreign key constraints on child tables that lack covering indexes, which can significantly hinder performance during UPDATE or DELETE operations on parent tables.
• Unused Index Scanner: Identify indexes that are non-primary and non-unique with zero recorded scans, helping to enhance the overall performance of INSERT and UPDATE operations.
• Database Health Reports: Generate real-time insights into database connection metrics, cache hit ratios, and server metadata using the icli report command.
• Modern Terminal UI: Results are presented in an intuitive format, including container cards, severity badges, and easy-to-run SQL remediation snippets, powered by the Lipgloss library.

Read-Only Guarantee

iCli guarantees a read-only experience, executing only read operations and metadata queries, ensuring no data changes occur within your database.

With iCli, achieving a well-optimized PostgreSQL database is streamlined, allowing for clear visibility into performance bottlenecks and areas for improvement.