Free PostgreSQL Tools
Tools for PostgreSQL developers and DBAs. Analysis runs locally in your browser without signup. If you choose Share in the plan visualizer, the selected plan and its details are uploaded to MyDBA and accessible through the generated link.
SQL Query Analyzer
Paste a PostgreSQL query and get deterministic + heuristic findings, risk and lint grades, access-path hints, and rewrite templates. No signup, no execution — analysis runs entirely in your browser.
Open tool
EXPLAIN Plan Visualizer
Paste your EXPLAIN output and get an interactive tree view, flame graph, timing waterfall, and actionable optimization insights.
Open tool
PostgreSQL Config Tuner
Enter your server specs and workload type to get optimized postgresql.conf settings with explanations.
Open tool
SQL Formatter
Format messy SQL into clean, readable queries with customizable indentation and keyword casing.
Open tool
Connection String Builder
Build and parse PostgreSQL connection strings across 6 formats: URI, keyword/value, JDBC, psql, pgAdmin, and environment variables.
Open tool
Index Advisor
Paste your SQL queries and get heuristic-based index recommendations for WHERE, JOIN, and ORDER BY clauses.
Open tool
pg_hba.conf Generator
Build pg_hba.conf rules with a visual form. Add, reorder, and export rules for your PostgreSQL authentication config.
Open tool
Table Bloat Estimator
Estimate table and index bloat from pg_stat output or pgstattuple results with actionable VACUUM recommendations.
Open tool
Lock Chain Visualizer
Paste pg_locks output to visualize lock dependency chains and identify blocking queries.
Open tool
Migration Linter
Check SQL migrations for common issues: missing transactions, unsafe ALTER TABLE, missing IF NOT EXISTS, and more.
Open tool
RLS Policy Builder
Generate Row Level Security policies from templates. Build SELECT, INSERT, UPDATE, DELETE policies with preview.
Open tool
Data Type Picker
Search and browse PostgreSQL data types with storage sizes, ranges, and usage recommendations.
Open tool
Cron Expression Builder
Build and validate cron expressions for pg_cron with a visual editor and next-N-runs preview.
Open tool