Paste your CREATE TABLE schema — get heuristic index and constraint recommendations: unindexed foreign keys, missing primary keys, candidate unique constraints, and composite indexes for common filter/sort patterns.
Most ORMs and migration tools won't warn you when a foreign key column has no index, or when a table has no primary key at all. This advisor applies the same heuristics an experienced DBA would — scanning your schema for the patterns that reliably cause slow joins, slow deletes, and full table scans.
email, username, or slug that look like natural keys but have no UNIQUE constraint.status, created_at, deleted_at and similar columns that are commonly used in WHERE/ORDER BY clauses.Catch missing indexes before a new table ships to production.
Paste a PR's migration diff and sanity-check the new schema in seconds.
Run an inherited schema through the advisor to find quick wins.
See the reasoning behind common indexing decisions, with explanations.
Does this run against my real database? No — it's a static analysis of the CREATE TABLE text you paste. Nothing connects to a live database.
Are these recommendations guaranteed correct? They're heuristics based on common patterns, not query-plan analysis. Always validate with EXPLAIN/EXPLAIN ANALYZE on your actual workload before applying in production.
Why no index suggested on every column? Over-indexing slows down writes and wastes storage — the advisor only flags columns with a strong structural or naming signal.