pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. It's also one of the few clients to provide a GUI front end to the plpgsql debugger.įree Administration Centre for the PostgreSQL database. It provides a SQL query tool, an editor for procedural languages and a CRUD interface. Windows, Linux, FreeBSD, macOS, OpenBSD, Solarisįor many years the 'standard' freely available GUI client for Postgresql, and so is bundled in many packaged installers. The minimum version of Java supported is 1.8.x as of SQuirreL version 3.8.1.Ĭommentor 1: If it doesn't start in OS X (like nothing appears) see pgAdmin 3 SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

With cross database and platform support. Open source, desktop application to manage your local or remote PostgreSQL databases.Ī simple and lightweight SQL client desktop/terminal Rather than being a native application it's primarily a web application that's also packaged as desktop web shell. PgAdmin 4 is a ground-up rewrite of pgAdmin 3. Clean, smooth, usable UI with dark and light themes.These clients are both 'free' and 'open source'īeekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. 3.2.5 EMS SQL Manager for PostgreSQL Freeware.2.1 Open Source and Completely Free Software.1.2.6 JetBrains IDEs - DataGrip, IntelliJ IDEA, PHPStorm, P圜harm, RubyMine, etc.

Working with universal database db2