03.05.2020

Best Postgresql Client For Mac

20
Best Postgresql Client For Mac Average ratng: 5,6/10 6136 votes
  1. PostgreSQL database query tool and GUI client, SQL editor, and database browser features and information such as tools for creating PostgreSQL databases and users, a PostgreSQL database browser, and more.
  2. SQuirreL SQL Client is a JAVA-based database administration tool for JDBC compliant databases. It allows you to view the database structure and issue SQL commands. It supports databases such as Firebird, IBM DB2, InterBase, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostreSQL, and Sybase.
  3. Tags: PostgreSQL module, PostgreSQL stack, PostgreSQL configurator, postgresql, stack, module 3. BitNami PostgreSQL for Linux 5.3.6-0 1.0 BitNami PostgreSQL module is a add. Module ships and configure PostgreSQL database server and phpPgAdmin. Handle the administration of PostgreSQL over the Web.
  4. Why yet another PostgreSQL GUI client? Why not just pgAdmin? Well, pgAdmin is great for its feature-richness. However, I found its UI is clumsy and complicated. I know there is a list of PostgreSQL GUI Tools. However, they are either web-based, Java-based * or don't support the features I want.
  1. Postgresql Mac Client
  2. Postgresql Client For Mac
  3. Postgresql Gui Client
  4. Best Postgresql Gui For Mac
Active5 years, 3 months ago

I have recently started using PostgreSQL with my rails app.

I was looking for a SQL GUI to the PostgreSQL database (for Mac).

Anything better than pgadmin3?

Postico makes PostgreSQL approachable. PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike.

Max Vernon
55.7k13 gold badges121 silver badges247 bronze badges
Aram BhusalAram Bhusal

closed as off-topic by Paul White, Philᵀᴹ, Mark Storey-Smith, Aaron BertrandJun 2 '14 at 13:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • 'Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope.' – Paul White, Philᵀᴹ, Mark Storey-Smith, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

4 Answers

Postgresql Mac Client

Check the wiki page, many different tools available.

Frank HeikensFrank Heikens
18.1k1 gold badge21 silver badges19 bronze badges

I'm currently developing a Mac client for PostgreSQL named PG Commander. My goal is to make the best designed PostgreSQL client for the Mac -- it's not as full featured as pgAdmin, but it's a lot easier to use.

Jakob EggerJakob Egger

Check out JackDB, it's a database client entirely in your web browser.

There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.

Migration of Sites and Options - Sites and Global Options settings in previous installation will be automatically migrated during upgrade. A sample TappIn connection will be included by default. Go global mobile client. CuteFTP Mac Professional is the most advanced Mac FTP client available. WebDAV Support - CuteFTP v9 includes support for the WebDAV protocol in order to provide additional possible endpoints for CuteFTP. Support for UNICODE Character Set - CuteFTP v9 supports the UTF-8 character set throughout the product.

Full disclosure: I'm the founder of JackDB.

sehropesehrope

I've been experimenting DbSchema (www.dbschema.com). I've been using the trial version and I'm pretty close to purchasing a license. While there are lots of tools for editing and submitting SQL requests (I like DbVisualizer) I like features in DbSchema. First, it has an interesting graphical database schema design tool for creating schemas and then applying them to a database. Second, it has a graphical way of querying tables. The 'graphical' part is selecting the join criteria, to use multiple tables. While I'm comfortable with SQL I'm also interested in a tool that will let others search tables without resorting to SQL.

I'm using it to manage a Postgres DB. Although I'm designing my schema from scratch DbSchema does 'import' schemas from existing databases.

I should add that I'm using DbSchema in Mavericks with Postgres running on the same laptop. DbSchema doesn't act like a native app. It's probably a Java client app--which is not a problem for me.

user39309user39309

Not the answer you're looking for? Browse other questions tagged postgresqlmac-os-x or ask your own question.

PostgreSQL is the default database on macOS Server as of OS X Server version 10.7.macOS without the macOS Server add-on installed includes only the PostgreSQLlibpq shared library.

macOS Server 10.12 ships with PostgreSQL 9.4. Minor updates are providedby Apple, but not necessarily right after a new PostgreSQL minor release.

There are several other installers available for PostgreSQL on macOS,which is the recommended way to install.

Interactive installer by EnterpriseDB

Download the installercertified by EnterpriseDB for all supported PostgreSQL versions.

This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developingyour databases, and StackBuilder; a package manager that can be used to download and installadditional PostgreSQL tools and drivers. Stackbuilder includes management,integration, migration, replication, geospatial, connectors and other tools.

This installer can run in graphical, command line, or silent install modes.

Best

The installer is designed to be a straightforward, fast way to get up and running withPostgreSQL on macOS.

Advanced users can also download azip archiveof the binaries, without the installer.This download is intended for users who wish to include PostgreSQL as part of another application installer.

Postgresql Client For Mac

Platform support

The installers are tested by EnterpriseDB on the following platforms. They will generally work on newer versions of macOS as well:

PostgreSQL Version64-bit macOS Platforms
1110.12 - 10.14
1010.10 - 10.12
9.610.10 - 10.12
9.510.8 - 10.10
9.410.6 - 10.9

Postgres.app

Postgres.app is a simple, native macOS app that runs in the menubar without the need of an installer. Open the app, and you have a PostgreSQL serverready and awaiting new connections. Close the app, and the server shuts down.

Fink

PostgreSQL packages are available for macOS from theFink Project.Please see the Fink documentation for information on how to install packages.

A list ofPostgreSQL packagescan be found using the package search tool on the Fink website.

MacPorts

PostgreSQL packages are also available for macOS from theMacPorts Project. Please see theMacPorts documentation for information on how to install ports.

A list ofPostgreSQL packagescan be found using the portfiles search tool on the MacPorts website.

It can be used with a torrent program, for example, so that the program is only active when the VPN is connected. Torrent client for mac.

Homebrew

Postgresql Gui Client

PostgreSQL can also be installed on macOSusing Homebrew. Please see the Homebrewdocumentation for information on how to install packages.

Best Postgresql Gui For Mac

A listof PostgreSQLpackages can be found using the Braumeister search tool.