SQL and analytics
PostgreSQL client for Windows
See your whole PostgreSQL server at a glance, from databases and schemas down to every column, then write SQL with suggestions that know your live schema and PostgreSQL itself.
Download FreeFree is $0 with a free account. For 64-bit Windows 10 and 11.
See it working
Real app screenshots from test workspaces with sample data, some cropped to the working area. A Pro build is shown.
What you get with PostgreSQL
A complete object tree
Schemas, tables, views, materialized views, sequences, functions, extensions, types, foreign data wrappers, publications, event triggers and roles.
Autocomplete with snippets
Live table and column suggestions, plus ready-made PostgreSQL snippets with placeholders you can tab through.
Script as
Right-click an object to script its Create, Alter or Drop statement.
Messages you can read
Server notices and row counts appear in their own Messages tab.
Big exports
Stream a complete result to CSV or NDJSON in the background, and pause, resume or cancel it.
Health dashboards
Watch the state of your server from a dedicated dashboard tab. Pro.
Example
SELECT customer, SUM(total) AS revenue
FROM sales.orders
GROUP BY customer
ORDER BY revenue DESC
LIMIT 10;Free and Pro
Connections, the explorer, the query editor, autocomplete, results and export are in the Free plan. Pro adds saved workspaces, searchable history, visual builders, guided import, data migration, health diagnostics and the AI assistant, where PostgreSQL supports them. Compare plans.
Free is $0 with a free account. For 64-bit Windows 10 and 11.