index-advisor

Read-only-by-default MCP server for PostgreSQL. Query, introspect schemas, explain plans, health checks.

Find the Postgres queries that cost the most time, the index that fixes each, and whether it really did. Self-hosted, read-only, Postgres 16–18.

Intelligent PostgreSQL management platform. Native Python3/GTK4 desktop IDE with multi-tab SQL editor, visual schema designer, AI index advisor, and a Python/Perl plugin system. Built-in hooks include Auto-Vacuum Advisor, Schema Anomaly Detector, PostgreSQL Log Analyzer, the Keboola normalizer pipeline and Polars-powered statistical analysis.

Offline toolkit for MongoDB structured logs. Slow query analysis, deterministic index advice, FTDC decoding. Never connects to your database.

Read-only performance advisor for self-hosted MongoDB: slow query shapes, ESR index recommendations, unused and redundant indexes. The Atlas Performance Advisor, for your own servers.

LLM for Index Recommendation

MySQL slow query log analyzer grouping bottleneck queries and recommending composite index optimizations

Postgres docker image with hypopg, pg_stat_statements, pg_qualstats and supabase index_advisor pre installed

Slow query interceptor and index advisor for Mongoose 8+. Automatically runs explain() on slow queries, detects COLLSCAN/SORT stages, and suggests optimal indexes following the ESR rule - zero runtime dependencies

An application-level MySQL query optimization layer using dependency-aware caching, query statistics, and adaptive index recommendations.

Database schema intelligence engine with relation inference, missing index detection, and Mermaid ER generation in pure PHP

Automated PostgreSQL query plan analyzer, EXPLAIN cost breakdown, and index tuning advisor in Python & Docker

High-performance PostgreSQL wire proxy, N+1 cascade detector & automated index advisor.

A workload-driven PostgreSQL Index Advisor for Django. Find missing indexes and generate safe, reviewable recommendations.

pgHeal — PostgreSQL autonomous index & PR robot. HypoPG-proven, zero data exfiltration.