Show HN: TablePlus – A macOS client for relational databases (opens in new tab)

Looks quite nice.

Currently stuck on pgAdmin 1.22, as I won't touch the "modern" Electron version of it.

I would like to stay in the terminal even when working on a DB. But I never found a decent terminal based DB client with a GUI (TUI?). So I am writing my own at the moment. A terminal based database editor. It's a bit like vim for databases.

If you too are interested in such a thing, let me know.

Are there other macOS apps that can read both MySQL and SQLite?

Sorry but I'm gonna rain on your parade here.

DBVisualizer already runs on Windows/Mac/Linux, connects to more databases, and implements just about every feature you're currently working on, plus all the ones you'll excitedly announce in the next few years -- like exporting data, query parameters, source table editing, charts, result set search, command-line interface, etc.

https://www.dbvis.com/features/

Your screenshots show so much wasted whitespace... timestamps that line wrap = half as many rows fit on the screen. Tons of unused space in the 'instagram_id' column.

A while back I used DatabaseSpy, which was also much more feature-rich than your tool. https://www.altova.com/databasespy

No relation to either tool, just a customer/user.

I like what TablePlus is offering. My question is the price. $69 isn't horrible, but it is still a lot. Is this one time $69 with a long path of free upgrades or is this $69 once a year like other software I use (VMWare Fusion, Office, etc).

What do they mean by native? That they are using macOS dev frameworks supplied by Apple, instead of a framework like Electron? If that is the case, how are they planning to have a Windows version?

Love it! Please don't bother with people who don't care about proper native experience. I've been waiting for a tool like that for sooooo long and I'm really happy to see it. I love when developers use the platform to its full extent instead fighting with it (like Electron and all rest of cross-platform approaches)

And for those whining about "macOS-only" - take a look at Tower, a Git client that was initially macOS-only as well. They later released a dedicated, native Windows version, just like the developer of TablePlus wants to do, and it's awesome. True native experience will always win in my heart with cross-platform solutions and that's where I'm putting my money.

https://tableplus.io/ for those who want to try it without reading the launch post.

Mac-only, Windows version planned. Free to download with paid upgrades giving more features: https://tableplus.io/pricing.

Looks like a good potential alternative to https://www.sequelpro.com/ (Mac and MySQL -only, donationware).

I've been using DataGrip by JetBrains for a while now. I have no qualms with it, but the price would be an issue if I didn't have the full JetBrains pack already from my employer.

What is the killer feature of TablePlus? Should I try it even though I'm happy with DataGrip? Or is it just as good for a lower price?

https://www.jetbrains.com/datagrip/

Been using it for a month now and I love the modern sleek interface. It's very similar to Postico (which is Postgres only unfortunately). One killer feature for me is that you can assign colors to connections. When you open a window this color is prominently displayed at the top, very useful for distinguishing production and dev. ⌘+P command prompt is also supported, like in Sublime Text. Some nice touches is that you can assign custom icons to connections and that empty space is filled with cute drawings. One thing I miss is that if you don't specify a DB in the connection info, the main window doesn't list all the available DBs, you have to ⌘+K to get the selection panel.

Well done!

Now I wish I had something as fancy for my meek Linux box.

How is this better than DBeaver

They have somehow managed to write a 500-word article on their project, advertising that it's "built native", without mentioning which platforms it runs on.

The answer appears to be "only macOS, maybe Windows later".

This looks promising, i will look forward to the windows version, but the MacOSX as a first supported platform seems a bit odd, I used to think most DBA worked under Windows/Linux.

For people that have tested it: can it set up connections over ssh tunnels? Would be a handy step to skip

This is timely! I spend all of yesterday setting up a Windows 10 VM just to have access to MSMS. The existing field of macOS MSSQL clients are light on features, including Microsoft own cross-platform SQL Operations Studio.

Question: Does TablePlus have a way to create a linked_server via the GUI?: https://www.sqlshack.com/how-to-create-and-configure-a-linke...

I’d pay for a Linux version. Graphical SQL clients in Linux are the worst ever.

Any plans for BigQuery support?

They complain about Sequel Pro but TablePlus is limited to Mac :(

Wow, I am so excited about this app. I have to wonder, how come the market hasn't supported something like this in the past - or more specifically - why hasn't SequelPro thrived and evolved to eventually support Postgres? Are developers too cheap?

I love it, while it clearly gets 'inspiration' from Postico - (not a bad thing, Postico's interface is awesome) - the fact that it supports all databases and even redis support planned is making me a customer.

There is a certain difficult to describe joy about tight native development. Ignore the haters, congrats on your release.

Thank you for this. If there is one area where there is a dearth of tools it's universal SQL workbenches. Only tool that's worth considering till now is Datagrip and now this looks promising.

I work at an Oracle shop, so this doesn’t work for me right now, but I’m looking forward to playing with it once Oracle support comes out.

Absolutely love it. Buying it, thanks!

I wish they have something like this for MongoDB. Didn't find anything good on OSX. Maybe Mongo 3G is still the best option and they just sold.

Their tech stack faq (https://tableplus.io/faq) mentions "go for server side"

Can someone confirm what this is related to? Surely this app isnt sending all connections via some server(farm) the developers control?

Any major differences related to SQLPro Studio? https://www.sqlprostudio.com (apart from access to some systems, and price, but since I consume it via Setapp...).

And so: Plans to make it available on Setapp?

I've used Querious for a while and really like it: https://www.araelium.com/querious

Like TablePlus, it's a native MacOS app, has great performance, and a clean interface.

Just wondering, when a new tool like this comes out, how can one be sure that it doesn't contain any malicious code? Would love to try it for work, but am a bit concerned about this, at least until it gets vetted more.

It would be cool to see a plugin or native support for visualizing query plans.

This is fantastic! I need to use it for a bit, but this might just replace tsql (finally!).

Some feedback:

I wasn't able to figure out how to mark something as favorite (no star icon, right clicking a table doesn't show an option).

Looks great! But please put up some information about who makes it. The "about us" link doesn't go anywhere. Trust is critical for such a product.

I think this looks great. But do you know what I would really enjoy - and that's a psql on steroids. Basically what I mean by that is take a lot of features in TablePlus but make a console app of it. You'd be expected to run super wide windows but it would lend itself to being used very rapidly without ever using the mouse, and being able to retain the incredible usefulness of psql while still getting an overview of your queries, your result sets, different view formats, etc. Maybe it's just me, but I would buy such a console app.

Seems quite good, it does have issues with chunkwm though if you open two databases and then try and switch between them

The UI looks nice. Is there any plan for Linux version?

Navicat has a high price tag but its still a better tool and I wish everyday if I had to use a GUI it could be Navicat over TablePlus.

TablePlus looks good but its design is confusing and downright stupid.

Awesome! I can't believe it took this long for someone to get it right! Support for Redis too?! Finally! Navicat is great, but very expensive, and its Mac implementation is a bit slow and buggy in my experience. Definitely not a first-class citizen on Mac. DataGrip is my primary tool right now, and I had no complaints, except that it was also slow on Mac, and had no Redis support, or table structure editing. And you've solved all of that! One small tip: Advertise the WHERE filter more prominently on the homepage. Fast WHERE filtering/column selection is crucial to a productive workflow, but it took me a while to find it on your interface.

Wow, pretty nice so far. Sequel Pro has been my main workhorse, but the fact that it's MySQL only has often left me looking for other tools.

It would be great to see better support for relationships and triggers and such like Sequel pro, but I like what it has so far in the structure view. I think the idea of the colored connection status bar, but it would be good to see some sort of logic for coloring the text on top to match or at least contrast sufficiently (something like how iTunes did it[0] would be awesome).

Lastly, better import/export would be nice. You can export and specify a few options but it would be good to see a little more full featured (see also Sequel Pro).

The price point seems reasonable too. Honestly, it feels a little awkward that Theming (even using alternating row colors) is a paid feature, but it probably will generate sales as I am inclined to use it immediately just to get rid of the popups.

[0] https://panic.com/blog/itunes-11-and-colors/

Thanks! I love Sequel Pro but multi-clause filters are a pain with it, and I'm never able to save my queries and have them available the next time I use the app.

Great job, I'll probably buy it after a few weeks of testing!

EDIT: love the commit feature. Not a fan of the cloud account thing, but the app still works without creating any.

This looks pretty sweet so far. I love having multiple panes, multiple tabs, and good shortcuts. When you click on a row it also appears in a vertical orientation in the sidebar on the right, that's a nice touch.

Today, I use mysql in the terminal most of the time. The main reason I've been using the terminal instead of SequelPro is my terminal has the scrollback available from my previous queries. This is great for comparing results, printing out a few table schemas to help write a query, and acting as kind of a log of my thought process. Terminal has a lot of other disadvantages, but I've accumulated a lot of tricks to mitigate them.

A nice implementation of tabs and panes could chip-away at that advantage, definitely, so this app is exciting. One limitation in the current implementation is it looks like table views need to take up the whole tab. It would be nice to have a table view in one pane, and a query editor in the next.

The app has a nice query history sidebar. In addition to the query, it has the timestamp; my terminal doesn't have that. Could this concept be expanded to include query results? My first instinct was also to try dragging and dropping one of the queries from my history into the desired pane. That didn't work, but its behavior of adding it to the pane where the cursor was last works well.

All in all, I think this will definitely find a regular place in my tool set; thank you for making something cool!

I'll buy that this is a true native macOS app, but why does it seem to be trying so hard not to be? Why does everything have a flat white background, and why is the list of data not a standard Cocoa list view? It's still a bit too visually disruptive for my taste.

This is the missing PostgreSQL client for OSX that I have been looking for. I am blown away by the intuitive UX. First time user and I already feel like I have been using the app for months.

Coming from pgAdmin, I couldn't be more pleased to see this. I was considering building something like this for myself with an electron app, but this is far more ideal. Great work!

Yay, finally a Paw for SQL! :)

Do you consider adding Clickhouse support? I would really appreciate that

(https://clickhouse.yandex)

FYI: Most of your footer links are not working & point to https://tableplus.io/#

There's also TeamSQL [0], which is pretty nice.

[0]: https://teamsql.io/

tl;dr: visit https://tableplus.io and see for yourself

Can I connect to SQLite file over ssh? I could not manage it through the "Connect with URL"

Looks better than MySQLWorkBench btw

Fast, beautiful and useful database tool

This is really well done. Thank you.

Great

Awesome app!

Been using it for months and love it! Great work :thumb-up: