DbSchema is compatible with all relational and few No-SQL databases. It works on all major operating systems, including Windows, Linux and Mac. It works on all major operating systems, including Windows, Linux and Mac. At the time I recommended the Open Source CoRD, a good RDP client for Mac. Since then Microsoft Remote Desktop Client for Mac 2 was released.

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?

Max Vernon

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

If this question can be reworded to fit the rules in the help center, please edit the question.

4 Answers

Check the wiki page, many different tools available.

Frank HeikensFrank Heikens

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.

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.

Dbschema For Mac Is The Best Db Client For Windows

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.

Informix Interactive Diagrams

Manage Informix schema via interactive diagrams. Create new tables, columns and indexes directly in the diagram. The diagrams can be exported as HTML vector images.

• Schema can be edited directly in the layouts (diagrams).
• The layouts are saved to project file and reopen next time you access the application
• HTML5 documentation with interactive vector image can be exported. Sample here.
• Foreign keys can be drawn using different notations, with lines pointing to tables or to columns.

Video IntroductionRead more »

Relational Data Browse

Which Mac Is The Best For Video Editing

Relational Data Browse is a visual data explorer from multiple tables simultaneously. View one table data and then open further tables having foreign keys or virtual foreign keys and view related records.

Data can be edited, filters can be set.

The editor will be saved to file and reopen next time you access the application. In this way you can build different perspectives over the data and reuse them whenever you need.

Video IntroductionRead more »

Schema Synchronization

DbSchema use its own project with schema structure and diagrams, which will be saved to project file. This makes possible to design schema independent from the database and deploy it on multiple databases.

The project file is in XML format. The project file can be stored in GIT and shared in a team.

Restarting DbSchema will open the last saved project file. To ensure the project schema is the same as in the database press 'Refresh schema from database' from the menu. Next you can refresh complete schema or take an action for each difference : merge in DbSchema or in the database.

Video IntroductionRead more »

Visual Query Builder, Query Editor and Random Data Generator

• Visually create SQL queries using the query builder. Multiple JOIN clauses can be used, including LEFT OUTER JOIN, EXISTS, etc. or group by clauses. The joins are using the foreign keys or virtual foreign keys.
• The Query editor with text-autocompletion, script execution and graphical explain plan.
• Random data generator using reverse regular expressions and predefined patterns.

Video IntroductionRead more »

Database Forms and Reports | Database Manager

Dbschema For Mac Is The Best Db Client Login

DbSchema Informix forms and reports can be used to build applications or reports and run them as JavaFx or Web applications. Based on the forms designer we started building Informix applications for space, permission and activity management.

Read more »