Free PostgreSQL tools
Practical Postgres tools for learning, designing, and querying.
Use PostgresGUI's free PostgreSQL tools to practice SQL, design schemas, pick column types, build connection strings, generate UUIDs, and move into a native Mac Postgres client when you are ready to work with real databases.
Online SQL editor
Write SQL, create tables, insert sample data, and run queries in your browser.
Online SQL compiler
A search-friendly guide to the browser SQL runner and how to use it for practice.
Schema designer
Design database tables visually, then import or export SQL.
PostgreSQL data types
Compare column types, storage notes, SQL examples, and common tradeoffs.
Connection string builder
Build and understand PostgreSQL connection strings without memorizing every field.
UUID generator
Generate UUIDs for test rows, fixtures, migrations, and app development.
Postgres viewer for Mac
Browse real PostgreSQL tables and query results in the native Mac app.
PostgreSQL GUI for Mac
The pillar guide for choosing a native Mac PostgreSQL client.