

artisan db:openĪ few months back, Caleb Porzio tweeted a Gist about how to use the open command on MacOS and a custom Artisan command to read your Laravel DB config and create a proper mysql:// link that would cause TablePlus to open your local dev database without having to set up a connection. Some of them still insist on using DataGrip, which I cannot understand. I’ve happily bought a license for it and for anyone on my team who wants to use it. Yes, it costs money, but often the good things in life do. It’s modern, kept up to date, supports every database you’d ever credibly want to connect to, and pretty to look at. I learned that this thing even existed from Taylor Otwell on Twitter. I used that for many years, but alas, it has become somewhat abandonware.Įnter TablePlus.

Navicat still exists, but for whatever reason I transitioned to Sequel Pro (“Pancakes”). When I later moved to MacOS, they had a version there too, though it never really felt as polished as the Windows version. Navicat was an actual good SQL GUI (MySQL specifically) that worked on Windows. I usually use Sequel Ace for day-to-day updating but if I'm in the mood to write more in-depth queries I'll jump into Atom and integrate that with some Python.I spent probably about half of my professional career as a hardcore Navicat user. The SQL is a DB I made to track projects from pitch to publication.

If you used Sequel Pro, you will be familiar with Sequel Ace.įYI Sequel Pro hasn’t been updated in a while and has some major issues atm. It’s free and it gets the job done when I’m working with MySQL. I use Sequel Ace for MySQL database management. Take a look at some app based SQL clients like and you’ll never go back to a web based client.

Why is this happening? phpmyadmin doesn't run, but the dbs do work. We tend to recommend Tableplus () or Sequel Ace () if free. Best MariaDB/MySQL database GUI for macOS?.It is not free tho, and a bit expensive for my personal use. I used TablePlus at work, and it was amazing. Mac user - What's the best SQL GUI for personal use? Another app that you can use is Table Plus. You can go to the Sequel Ace website or use this command brew install - cask sequel-ace to install it. I strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier.
