Quite good, but not 100% perfect PostgreSQL support (yet?). Good query editor with syntax highlighting, completion and autosave.Įditing of query results. Supports many SQL databases from different vendors, as well as few NoSQL ones (Cassandra, etc). It has some restrictions on use by government employees. It supports schema comparison ('diff') and copying data between databases. All SQL Workbench specific commands can also be run in batch mode to automate export and import task. It can be used in GUI mode or as a console application. It has strong support for exporting and importing data between databases using its own SQL command extension. Data can be edited directly in the result set. Inspired by the proprietary Toad client.Īn OpenSource (though it prohibits usage by government agencies from USA, UK, Canada, China, Russia, North Korea, Syria, Saudi Arabia, Turkey and the Chechen Republic) SQL GUI tool similar to Squirrel. Oracle, MySQL, and PostgreSQL, as well as limited support for ODBC targets. Note that binary packages for platforms like RPM don't show up in every point release, you currently have to go back to v1.8.0 to get the last full set of packages.ĭevelopment has been discontinued by, but is still being maintained by BigSQL who are doing basic maintenance to support newer versions of PostgreSQL and packaging it for current OS releases. PgAdmin III is bundled with the Windows installer on older versions of Postgres, and you can use that as a client to administer a remote server on another OS. Features full Unicode support, fast, multithreaded query and data editing tools and support for all PostgreSQL object types. PgAdmin III is an Open Source management tool for PostgreSQL databases. Available in more than 30 languages and for several operating systems. The graphical interface supports all PostgreSQL features and makes administration easy. 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.

Postico sql