SQL Index Analyzer

Paste your CREATE TABLE and CREATE INDEX statements, plus an optional query, to get instant index recommendations. Detects missing foreign key indexes, duplicate indexes, and query-slowing column gaps.

Schema (CREATE TABLE + CREATE INDEX)

Query (optional — for query-specific recommendations)