Skip to main content
pgconfigurator
pgconfigurator
Tune
Explain
Inspect
Docs
Talk to sales
Schema review
Paste DDL · find missing PKs, FKs, mis-typed columns
Schema review
Where to get your DDL
parsed in your browser
-- example schema with multiple issues to surface CREATE TABLE customers ( id BIGSERIAL PRIMARY KEY, email VARCHAR NOT NULL, name VARCHAR ); CREATE TABLE orders ( id BIGSERIAL PRIMARY KEY, customer_id BIGINT REFERENCES customers (id), status VARCHAR NOT NULL, amount NUMERIC(10,2), created_at TIMESTAMP WITH TIME ZONE ); CREATE TABLE events ( id BIGINT, user_id BIGINT, payload JSONB, created_at TIMESTAMP ); CREATE INDEX orders_status_idx ON orders (status); CREATE INDEX orders_status_created_idx ON orders (status, created_at);
25 lines · 558 chars
load sample
clear
⌘
Analyze
Paste DDL and click Analyze.