How to visually manage your databases in Sequel Pro using favorites, colors and emojis.

I will present you some tips to make it easy to visually manage your servers and databases using emojis and colors. The idea comes originally from that fideloper’s tweet.

Favorites

To manage my databases, I use Sequel Pro’s favorites, and I add some cool hacks.

Enhance your favorites in Sequel Pro.

Folder

I combine favorites depending of the same project in a folder. I help myself to visually determine the project adding an emoji corresponding to the project at the beginning of the folder’s name.

Color

First, I add a color to my favorite to determine if the favorite is in production or local:

Red: Server in production (Danger)

Yellow: Project (database) in production (Warning)

Green: Local database or local server (Ok)

I make a difference between a project and a server. But basically, a project is just a server with a database selected.

Add colors to your favorites.

Emoji

Then, I add an emoji at the beginning of favorite’s name to visually explicit in a cool way the type:

🚨: Server in production (Danger)

⚠️: Project (database) in production (Warning)

✅: Local database or local server (Ok)

Text

Finally, I add a text between square brackets in the name of the favorite to explicit the type:

SERVER: Server in production

PROD: Project (database) in production

LOCAL: Local database or local server

Bonus tips: Tabs

Don’t forget to always display tabs !