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

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

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

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

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

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

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

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

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

Parses execution plan nodes to detect full table scans, Cartesian cross joins, and suggests optimal composite indexes with cost estimation | GenPark: https://www.genpark.ai | LinkedIn: https://www.llinkedin.com/company/92955550