DEV Community

Cover image for Why I Built My Own MySQL Client for macOS (SQL Gnome)
Harry Wynn
Harry Wynn

Posted on

Why I Built My Own MySQL Client for macOS (SQL Gnome)

I’ve been building software professionally for more than 25 years, and like most developers, I spend a lot of time inside databases. MySQL in particular shows up everywhere: analytics systems, internal tools, production apps, and quick debugging sessions.

Over the years I’ve used a lot of database clients. Some were good. Some were frustrating. Eventually I reached a point where I kept thinking:

“Why does this feel harder than it should?”

That question is what led me to build SQL Gnome, a native MySQL client for macOS focused on speed and simplicity.


The Problem With Existing Tools

Most database clients fall into one of a few categories.

Electron apps

A lot of modern tools are built with Electron. That’s not inherently bad, but it often means:

  • high memory usage
  • slow startup
  • UI lag when browsing large tables

When you're opening a database client dozens of times a day, those little delays add up.


Feature overload

Some clients try to do everything:

  • schema design
  • migrations
  • visual query builders
  • dashboards
  • collaboration layers
  • cloud integrations

For some teams that’s great.

But most of the time I just want to:

  • run queries
  • browse tables
  • inspect results
  • move on

The extra complexity ends up getting in the way.


Subscription fatigue

Another trend is database clients moving to subscription pricing.

For teams that makes sense. But for individual developers, it can feel strange paying monthly just to run SQL queries.


What I Wanted Instead

When I started thinking about building my own client, I kept coming back to a few simple goals.

I wanted something that was:

Fast

  • launches instantly
  • runs queries without lag

Simple

  • clean interface
  • minimal setup

Native

  • built specifically for macOS
  • not a cross-platform wrapper

Focused

  • query execution
  • table browsing
  • result inspection

No dashboards.

No workflow engines.

No unnecessary complexity.

Just a solid tool for working with MySQL.


How SQL Gnome Works

The goal with SQL Gnome is to make working with MySQL quick and straightforward.

Connect to a database

Add your connection details and connect instantly.

SQL Gnome Conenction Screen


Run queries quickly

Write your SQL and execute it immediately.

The editor is intentionally minimal and focused on speed.

SQL Gnome Query Screen


Browse tables

You can quickly explore schemas and inspect table contents without needing to write queries for everything.

SQL Gnome Content Screen


Explore table structure

Understanding a database quickly often starts with understanding its schema.

SQL Gnome lets you inspect table structure instantly — columns, data types, keys, and indexes — without writing DESCRIBE or SHOW CREATE TABLE queries.

This makes it easy to understand unfamiliar databases or debug schema issues.

SQL Gnome Structure Screen


Why the Name "SQL Gnome"?

Honestly?

I like tools with personality.

Not every development tool has to look like a corporate dashboard.

The idea was a small, helpful tool that quietly does its job while you focus on your work.


Lessons Learned While Building It

Building a developer tool teaches you a lot about what developers actually care about.

Speed matters more than features

Developers forgive missing features.

They don't forgive slow tools.


Simplicity is surprisingly hard

Adding features is easy.

Deciding what not to build takes much more discipline.


Small details matter

Things like:

  • keyboard shortcuts
  • query formatting
  • scrolling behavior
  • rendering large result sets

Developers notice these details immediately.


Try SQL Gnome

SQL Gnome is still early, and I’m continuing to improve it based on feedback.

If you spend a lot of time working in MySQL, I’d love to hear what would make a tool like this better.

Download SQL Gnome

👉 https://sqlgnome.com

Feedback and suggestions are very welcome.

Top comments (1)

Collapse
 
harrywynn profile image
Harry Wynn

If anyone wants to try SQL Gnome:

sqlgnome.com

I'm especially curious what features people care most about in a MySQL client.