3 Lessons from 7 Years of Building a GUI for MongoDB

How do you build a tool for the whole team? Scratch, listen, then sweat the small stuff.

Studio 3T
Studio 3T
Jul 13 · 7 min read
Image for post
Image for post

Search for “mongodb gui” and you’ll see a full search results page of ads, listicles, and tool options.

That wasn’t the case in 2013.

We were SQL users back then who liked what we saw in MongoDB, the new NoSQL database launched in 2007.

We liked the ease and flexibility of the database itself, but the mongo shell can be pretty time-consuming and the tools available at the time were not up to scratch.

Image for post
Image for post
A not-so-pretty mongo shell (Photo: w3resource)

And so we built 3T Data Manager, which, along with Schema Explorer and Data Compare & Sync we then combined into MongoChef.

Then in 2017, MongoChef turned into what we are today: Studio 3T.

We’ve seen the third-party tooling space grow alongside MongoDB. The growth of this independent software vendor (ISV) ecosystem is one of the reasons MongoDB has grown to be a multi-billion dollar company.

In a similarly organic way, the Studio 3T feature set has also grown wider and stronger.

How did we decide what to build and improve? We listened to our pain points and to our customers. Then sweated the small stuff.

Lesson 1: Scratch your own itch

“If you are not embarrassed by the first version of your product, you’ve launched too late.”

Reid Garrett Hoffman, co-founder of LinkedIn

We spent the first months releasing our software publicly but quietly, honing core features born out of our own pain points:

  • We needed a multi-platform tool
  • Viewing data was a nightmare, MongoDB lacked a proper GUI
  • Comparing two collections wasn’t possible
  • There was no way to debug a collection and spot mistakes in the schema
  • The mongo shell could be much better

Finally in May 2014, we announced 3T Data Manager to the world.

Image for post
Image for post
Studio 3T (then 3T Data Manager) in 2014

As an “in-place data browser and editor GUI for MongoDB”, it already had the key core features which remain in Studio 3T to this day:

  • In-Place Data Editing — Double-click on a cell to edit
  • Visual Query Builder — Drag-and-drop MongoDB query generation
  • Table, Tree, and JSON views — Flexible ways to view collections
  • Schema Explorer — Easy schema analysis
  • Data Compare & Sync — Compare two MongoDB collections side-by-side

By September 2014, we started gathering customer feedback through Uservoice, which we still use.

Image for post
Image for post
Studio 3T (then MongoChef) in 2016

Lesson #2: Listen to customers

Features are born out of pain points — that’s why we built a GUI for MongoDB in the first place — and our customers have been instrumental in shaping Studio 3T by not holding back when they’re annoyed.

We respond to each support email and customer ticket, talk to users at conferences, and conduct regular UX sessions to better understand what works, what doesn’t, and what’s missing.

Users know what annoys them. But they don’t always know the solution. That’s our job.

Since we started using Uservoice in September 2014, we’ve seen around 520 customer tickets come in, of which:

  • 214 have been completed
  • 42 are under review
  • 15 have been planned
  • 11 have been declined
  • 5 have been started

But those 520 requests pale in comparison to the Niagara of feedback we receive daily through our support inboxes, UX sessions, customer surveys, and the conferences — live and in person — that we attend, all of which gets logged for consideration in upcoming releases.

Lesson #3: Sweat the small stuff

If you use Studio 3T, here are a few features you might recognize — the first of their kind in the MongoDB tool space since replicated by many others — which came directly from customer tickets:

And the small stuff — the time-saving hotkeys, the shortcuts, the menu options, the logically-placed buttons — that our users have flagged over the years:

Sometimes it might not even be about functionality. We care about how the app feels just as much as we care about how it performs.

This means that when users ask for a dark mode, we build one — and we will keep iterating until it’s as good as it can be.

When we get feedback that our app feels like it’s “stuck in a time machine”, we get with the times.

When our icon gets called out, we work on it.

Image for post
Image for post
The evolution of Hugh Manatee

And when it comes to our key features, we strive to make them better, even if that means ripping them apart. Aggregation Editor, the very first MongoDB aggregation pipeline builder, is a great example.

The core feature that we recently re-engineered in February 2020 started out as a customer feature suggestion in April 2015 and quickly became a favorite. It saved users so much time.

“Studio 3T is the tops for me. In only 30 minutes, I can gain one whole day of work when building aggregation queries.”

Pierre Yves Folens, DevOps Engineer at Orange

But we could only rebuild it thanks to our users who pointed out the small stuff we could improve, which are now an integral part of the Aggregation Editor UX.

Image for post
Image for post
The history of Aggregation Editor

The present and future

Image for post
Image for post
Studio 3T in 2020

Seven years later, the Studio 3T feature list continues to grow as we ship improvements to our key, core features.

Why are we writing about our approach to product development now?

Because release note after release note, we’ve found ourselves highlighting only the new features, reducing fixes and improvements to a few bullet points, and burying the rest in our change log.

So we’re taking a break from the usual in our latest release to put the spotlight back on the small stuff that’s made all the difference in the last seven years — and counting.

Finally, we want to give a shout-out to all those customers who have taken the time to tell us when something needed improving. These are the people who really made Studio 3T a pleasure to use:

Andreas Kroll
Mark Hague
Chris Daniels
J. Parkinson
Thomas Ingham
Claus Nielsen
Kirk Sefchik
Victor Silva
Ed Lomonaco
Dmitry Khokhlov
Arjan Keeman
Austen Holmes
Andrew Maxwell
Gerhard Pretorius
Priyanka Baviskar
Valentin Slawicek
David Henderson
Alex Ilyaev
Dave Smith
Aytek Ustundag
Stephen Mandeville
Kevin Frugier
Simon Berger
Christian Laakmann
Dave Sharone
João Sena Ribeiro
Nicolas Durand
Bob Phillips
Plamen Parvanov
Kevin Blake
Javier Fernández
Robin Speekenbrink
Maurice Frank
Craig Felton
Barry Kaplan
Kai Virkki
Dakota Baer
Maarten Dreves
Daniel Halan
Tommi Reinikainen
Sefi Kushnir
Ádám Bálint
Alex Paransky
Andrey Savchuk
Andrew Perella
John Norton
Mark Delbert
Roly Vicaria
Michael Wills
Jóhann Geir Jónsson
Harish Krishnan
Carlos Garay
Peter Širka
Mike Donnelly
Mark Wienk

And countless others :-)

Dev Genius

Coding, Tutorials, News, UX, UI and much more related to development

Sign up for Best Stories

By Dev Genius

The best stories sent monthly to your email. Take a look

By signing up, you will create a Medium account if you don’t already have one. Review our Privacy Policy for more information about our privacy practices.

Check your inbox
Medium sent you an email at to complete your subscription.

Studio 3T

Written by

Studio 3T

MongoDB is easy — now make it powerful with Studio 3T, the professional GUI for MongoDB. Try it for free: https://studio3t.com/

Dev Genius

Coding, Tutorials, News, UX, UI and much more related to development

Studio 3T

Written by

Studio 3T

MongoDB is easy — now make it powerful with Studio 3T, the professional GUI for MongoDB. Try it for free: https://studio3t.com/

Dev Genius

Coding, Tutorials, News, UX, UI and much more related to development

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium