Case Study Deskcasestudydesk.com
Developer toolsSourced

Case Study: Retool manages 300K+ Postgres databases with one engineer using the Neon API

Retool Case StudySourced & dated by Case Study Desk
Key facts · TL;DR
Company
Retool
Industry
Developer tools
Challenge
Offering a dedicated Postgres database per customer at scale without idle cost or a large ops team.
Headline result
Retool automated its database fleet on the Neon API, letting a single engineer manage more than 300,000 Postgres databases.

Key results

300K+
Postgres databases managed
Via the Neon API
1
Engineer runs the fleet
Scale-to-zero avoids idle-resource cost

The challenge

Retool wanted to offer each customer a dedicated Postgres database while keeping management overhead and idle-resource cost low across a very large fleet.

The solution

Retool automated virtually all database management through the Neon API and relied on Neon's scale-to-zero to avoid paying for idle databases, letting a single engineer operate the fleet.

We've been able to automate virtually all database management tasks via the Neon API. This saved us a tremendous amount of time and engineering effort. The scale-to-zero functionality of Neon allows us to offer dedicated databases to our customers without worrying about the cost of idle resources

HB
Himanshu Bhandoh
Software Engineer, Retool

The results, in context

Retool reported managing more than 300,000 Postgres databases with a single engineer by automating database management through the Neon API. Neon's scale-to-zero let it offer each customer a dedicated database without paying for idle resources.

Products used

Neon Neon PostgresNeon Neon APINeon Scale to zero