The Postgres GuyToolkit
Interactive tools for anyone working with PostgreSQL.
No signup, no fluff — just what you need.
Tools
EXPLAIN Visualizer
LivePaste a query plan, get a visual tree with cost heatmap and row estimate analysis.
Query Formatter
LivePaste messy SQL, get clean formatted output instantly.
Index Advisor
LiveAnalyze a query and get missing index suggestions.
pg_stat_statements Analyzer
LivePaste your stats output, get ranked slow queries with insights.
Data Type Picker
LiveGuided selector for tricky type decisions — text vs varchar, timestamptz vs timestamp, and more.
Schema Generator
LiveDescribe your data in plain English, get DDL output.
RLS Policy Builder
LiveWizard for building row-level security policies.
Version Diff
LiveSee exactly what changed between PostgreSQL versions.
Connection String Builder
LiveBuild a connection string once, get every format: libpq, JDBC, SQLAlchemy, psycopg2, node-postgres, Go, and more.
Error Code Lookup
LiveSearch any PostgreSQL SQLSTATE code or error keyword. Get plain-English explanations, causes, and fixes.
Migration Reference
LiveSide-by-side syntax comparison for migrating from MySQL or SQL Server to PostgreSQL. Types, functions, DDL, and gotchas.