I have recently started using PostgreSQL with my rails app.

TeamSQL is a free multi-platform SQL client that supports PostgreSQL. Open-source and hugely popular, it's the default for macOS Server, but you'll probably want a full-featured client to work with your databases. Here's what TeamSQL offers: Sharing: TeamSQL comes built-in with robust sharing tools. 3 Battle-Tested Ways to Install PostgreSQL. How to Install Postgres on Mac OS X. This guide will show you how to install PostgreSQL, the easy way, on a Mac. This tutorial is designed for Max OS 10.9 - Mavericks. Brew also installs all the commands and tools needed to manage Postgres, and installs it all to the standard locations on your. With PostgreSQL 8.3 having been officially available for a couple of weeks now, we are now revving the of Mac project to 8.3 as well. Last thursday we published to the PostgreSQLforMac site, and with those updates, we have gotten some feedback. Writing a PostgreSQL adapter for Sequel Pro is a good idea. I don't know how an adapter can fit into Sequel Pro's architecture though. I'll take a look at Sequel Pro's codebase and consider this approach. The PostgreSQL database query tool features provided by RazorSQL include a custom PostgreSQL database browser tailored to PostgreSQL, a PostgreSQL SQL editor with PostgreSQL specific features and syntax highlighting, custom PostgreSQL GUI tools, and PostgreSQL specific database administration tools. Listed below are more details on these features. Mac OS packages. 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 PostgreSQL.

Psequel is a PostgreSQL GUI tool for macOS. @psequel PSequel. PostgreSQL GUI tool for macOS. PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.

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

Anything better than pgadmin3?

closed as off-topic by Paul White♦, Philᵀᴹ, Mark Storey-Smith, Aaron Bertrand♦Jun 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

4 Answers

Check the wiki page, many different tools available.

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.

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

Chrome Cleanup Tool For Mac

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.

Full disclosure: I'm the founder of JackDB.

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.

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

Join the DZone community and get the full member experience.

Postgres Client Mac Brew

To install PostgreSQL on Mac, the two most common ways are Docker and Homebrew service. But Docker might be too big and eat up a large portion of memory, or sometimes you feel clumsy configuring the local server using the command line. On the other hand, it's really hard to install and manage multiple versions of PostgreSQL on your computer.

In this post, we are going to use DBngin, a free tool for database version management on Mac. It allows you to set up a local PostgreSQL server of any versions within a click.

1. First, go to DBngin, and download and install the app on your Mac.

2. Open DBngin and click on + New Server button.

3. Choose PostgreSQL from the drivers' list; choose the PostgreSQL version and name your server to create a new server. You can edit the server and change the port later on.

Now you already have a local PostgreSQL server running on your computer.

With DBngin, you can install and manage multiple servers of not only PostgreSQL but MySQL, Redis. You can turn on and off any database server by just a click. Turn it on when you need and just quit when you're done. No dependencies.

Thank you for viewing this quick tutorial on how to install PostgreSQL on your Mac using DBngin. Let me know your thoughts or any questions you might have regarding this tutorial in the comments section. Have a great day!

Opinions expressed by DZone contributors are their own.