The Postgres GuyToolkit
Interactive tools for anyone working with PostgreSQL.
Tools
EXPLAIN Visualizer
Paste a query plan, get a visual tree with cost heatmap and row estimate analysis.
Query Formatter
Paste messy SQL, get clean formatted output instantly.
Index Advisor
Analyze a query and get missing index suggestions.
pg_stat_statements Analyzer
Paste your stats output, get ranked slow queries with insights.
Data Type Picker
Guided selector for tricky type decisions — text vs varchar, timestamptz vs timestamp, and more.
Schema Generator
Describe your data in plain English, get DDL output.
RLS Policy Builder
Wizard for building row-level security policies.
Version Diff
See exactly what changed between PostgreSQL versions.
Connection String Builder
Build a connection string once, get every format: libpq, JDBC, SQLAlchemy, psycopg2, node-postgres, Go, and more.
Error Code Lookup
Search any PostgreSQL SQLSTATE code or error keyword. Get plain-English explanations, causes, and fixes.
Migration Reference
Side-by-side syntax comparison for migrating from MySQL or SQL Server to PostgreSQL. Types, functions, DDL, and gotchas.
All tools are free to use. AI-powered features include a monthly usage limit.