Paste a CREATE TABLE schema, get index recommendations in seconds.
Open the Index Advisor →Most ORMs won't warn you when a foreign key has no index or a table has no primary key. MetaDataLoop's Index Advisor statically analyzes your CREATE TABLE schema and flags the structural patterns that reliably cause slow joins, slow deletes, and full table scans — no live database connection required.
Sample values and the dialect-native type they map to.
| Sample value | Inferred type |
|---|---|
| FK column, no index | CREATE INDEX (high priority) |
| Table with no PK | Add PRIMARY KEY (high priority) |
| email/username, no UNIQUE | CREATE UNIQUE INDEX (medium) |
| status/created_at columns | CREATE INDEX (medium) |
| FK + date column combo | Composite CREATE INDEX (low) |
CREATE TABLE orders ( id SERIAL PRIMARY KEY, customer_id INT REFERENCES customers(id), status VARCHAR(20) NOT NULL, created_at TIMESTAMP NOT NULL );
CREATE INDEX idx_orders_customer_id ON "orders" ("customer_id");
CREATE INDEX idx_orders_status ON "orders" ("status");
No signup, no install — runs entirely in your browser.
Open the Index Advisor →