Open-source Studio 3T alternatives

DbGate is a cross-platform database client for working with several databases at once. It supports SQL and NoSQL systems including MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Redis, SQLite, MariaDB, CockroachDB, ClickHouse, Cassandra and DuckDB, and runs on Windows, Linux and macOS or as a web application.

Day-to-day tools include table browsing with Excel-like and multi-value filters, table data editing with a preview of the generated SQL change script, schema editing for indexes and keys, and an SQL editor. More advanced features include comparing and synchronizing database structure, ER diagrams, a visual query designer that builds queries without hand-written SQL, master/detail views, foreign key lookups, a JSON view for MongoDB collections, and batch export and import.

The Community edition is licensed under GPL-3.0 and is free to use for any purpose. The web version can be run as an NPM package or Docker image, a Node.js scripting interface is available, and an online demo lets you try it first. The README marks some database drivers, such as Amazon Redshift and CosmosDB, as Premium.

TablePro is a database client for macOS written in Swift with native frameworks, with no Electron, JDBC or JavaScript runtime involved. Its author describes it as the open-source, native tool they wished TablePlus would be, and the README compares it with single-database clients such as Sequel Ace for MySQL and Postico for PostgreSQL.

It connects to SQL and NoSQL databases through native drivers, including MySQL, PostgreSQL, SQLite, SQL Server, MongoDB and Redis, and offers a SQL editor and database GUI. AI is built in through chat, inline suggestions and an MCP server, so tools like Cursor, Raycast or Claude Desktop can work with your databases. You bring your own API key, choose your provider, or run models locally with Ollama.

TablePro is licensed under AGPL-3.0 and free to use. It runs as a desktop application on your Mac, so there is no server to host. It suits developers who want a fast native client and an open-source alternative to commercial macOS database tools.

WhoDB is a single workspace for browsing databases, changing rows, running queries and seeing how a schema is put together. It works in a browser, is straightforward to self-host, and is also available as a desktop app and a terminal CLI. The authors position it for inspecting a local database or helping a teammate explore unfamiliar data without a heavyweight client.

Optional AI features let you ask questions in plain English by hooking up a local or hosted model through Ollama, LM Studio, OpenAI, Anthropic or any compatible API. Repository topics also mention an SQL editor, a visual query builder, ER diagrams, text-to-SQL, data lineage and catalog features, and an MCP server. MySQL, PostgreSQL, SQL Server and Oracle are among the topics, and the backend is written in Go.

WhoDB is licensed under Apache-2.0 and offers a live demo and documentation. It suits developers, analysts and internal tool builders who want a simple database front end that they control, rather than a heavyweight client.

Nosqlclient is a cross-platform, self-hosted MongoDB management tool, previously known as Mongoclient, aimed at developers and administrators who want a browser-based interface for inspecting and managing MongoDB databases rather than working purely from the mongo shell.

It supports MongoDB 4.0 and newer and runs as a web application, built with Meteor on JavaScript, that connects to an existing MongoDB instance or can install its own inside its Docker container. Settings and connections can be persisted by binding a data directory to the host machine.

The README states the project is no longer being actively developed, though Docker builds remain usable and the maintainer accepts email inquiries. Versions before 2.0.0 are licensed under MIT, while 2.0.0 and later versions are licensed under AGPLv3, so check which version applies to a given deployment.