Index Analyzer

Real index usage counters, least-read first, with a script-first DROP INDEX for the ones you choose.

Real usage counters for every index in the database, sorted least-read first, so the indexes nobody is using rise to the top. The columns are the engine's own numbers: seeks, scans, lookups, and updates from SQL Server's usage DMV; scans, tuples read and fetched, and on-disk size on PostgreSQL; read and write events from MySQL and MariaDB's Performance Schema. A footer reminds you of the catch every DBA eventually relearns: counters reset on server restart, so a zero-read index on a freshly bounced server proves nothing yet.

Removing one is script-first: Script DROP INDEX prepares a commented, reviewed DROP INDEX in a query tab for the row you selected. Indexes that enforce a primary-key or unique constraint are refused outright, with a note to drop the constraint instead - the tool will not help you saw off a limb by accident.

SQLly

SQLite keeps no usage counters, so the tool says so there rather than showing zeros.