Why I Built Bapu Studio: A Unified, Local-First Cockpit for APIs, Databases, and Secrets
As a software engineer, my daily workflow always felt fragmented. In any given hour of building a feature, I was constantly context-switching between: An HTTP client to test REST endpoints and verify response headers. A database GUI to inspect database tables and run quick SQL/NoSQL queries. Multiple terminal tabs and .env files to manage API keys and credentials. I wanted a single, lightweight…
In his daily work as a software engineer, the author found their workflow to be fragmented and inefficient. They would constantly switch between an HTTP client, a database GUI, and multiple terminal tabs to manage API keys and credentials. This led them to develop a solution that would consolidate these essential tools into a single, lightweight application with zero telemetry. The result is Bapu Studio, a free, open-source developer desktop application.
Bapu Studio's primary features include:
1. An API Studio, which provides a full HTTP/REST client supporting all methods such as GET, POST, PUT, and DELETE. It also includes dynamic variable interpolation (e.g., {{API_URL}}, {{AUTH_TOKEN}}) and pre-request and test assertion scripting engines. The application offers instant code snippet generation in cURL, JavaScript fetch, Python requests, and Go.
2. A Database Studio, which features a multi-engine SQL & NoSQL query console for PostgreSQL, MySQL, MongoDB, and SQLite. The console includes a schema browser with dynamic table column extraction, one-click CSV exports, and query history auditing.
3. A Scoped Secrets Matrix, which allows users to manage environment variables across different environments (Local Dev, Staging, Production) with secret masking. The secrets can be seamlessly exported to standard .env formats.
The application operates entirely offline on a user's local machine, requiring no mandatory accounts, cloud sync, or tracking. Bapu Studio is free and open-source, licensed under the GNU AGPLv3. Pre-built binaries are available for macOS (Apple Notarized), Windows, and Linux. Users can find the GitHub repository at github.com/joravar/bapu-studio and download the latest releases at github.com/joravar/bapu-studio/releases. The author is eager to receive feedback, feature ideas, and thoughts from fellow developers.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
