index_advisor is a PostgreSQL extension developed by Supabase that suggests index optimizations based on query performance. It passively monitors query patterns and recommends indexes to improve performance without requiring deep database expertise. This tool helps developers and DBAs reduce query latency and improve efficiency in production environments.