Show HN: Outerbase Studio – Open-Source Database GUI

1. Jailer

   1 226 3,030 9.1 Java

   Database Subsetting and Relational Data Browsing Tool.

   

   Jailer (https://wisser.github.io/Jailer/) is awesome and really not “niche”. Also, it's not something for exploring "datasets", but for tables and relational databases in an innovative way. I think it would be fantastic if more people knew about it.

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. studio

   2 4 4,898 9.6 TypeScript

   A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.

   

4. pglite

   3 34 12,720 9.3 TypeScript

   Embeddable Postgres with real-time, reactive bindings.

   

   Would be nice to add support for PGlite [0] to have the same “spin up in the browser” experience with Postgres.

   Let me know if we can help with it!

   [0] https://pglite.dev

5. database-build

   4 3 2,882 9.7 TypeScript

   In-browser Postgres sandbox with AI assistance (formerly postgres.new)

   

   you can also find some code for "pglite in the browser" here: https://github.com/supabase-community/database-build

6. starbasedb

   5 5 1,088 9.4 TypeScript

   HTTP SQLite scale-to-zero database on the edge built on Cloudflare Durable Objects.

   

   Definitely! We actually embed studio as part of another one of our offerings. It's actually iframed in, but you could achieve similar results if you wanted to dockerize it.

   https://github.com/Brayden/starbasedb/blob/main/src/studio/i...

7. sdk

   6 2 27 9.3 TypeScript

   Typescript ORM and automated model generation direct from your database schema. Supports Outerbase features for saved queries & AI. (by outerbase)

   

   Correct. Our goal is to have all of our data sources across all Outerbase products powered by our SDK - https://github.com/outerbase/sdk. Currently the Studio product is not powered by it but our cloud and other offerings are.

8. sqlpad

   7 3 5,153 7.3 JavaScript

   Discontinued Web-based SQL editor

   

9. Sevalla

   sevalla.com featured

   Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

   

10. supabase

    8 914 87,716 10.0 TypeScript

    The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

    

    For similar projects, check out Supabase Studio (open source, Postgres only) [0], and Prisma Studio (closed source, supporting most popular databases) [1].

    [0]: https://github.com/supabase/supabase/tree/master/apps/studio

11. studio

    9 17 2,027 4.0

    🎙️ The easiest way to explore and manipulate your data in all of your Prisma projects. (by prisma)

    

12. pgadmin4

    10 60 3,118 9.7 Python

    pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

    

    > browser based

    For whatever reason, this is the main limiting factor, because local software can be really good, for example:

    DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/

    DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/

    DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/

    HeidiSQL - haven't really used this myself but the version graph on the page is cool https://www.heidisql.com/

    There's also some solutions that are specific to certain databases, like:

    pgAdmin - for PostgreSQL https://www.pgadmin.org/

    MySQL Workbench - for MySQL/MariaDB, sometimes a bit buggy but I really like the reverse engineering and forward engineering functionality https://www.mysql.com/products/workbench/

    (out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)

    Adminer - one of the somewhat rare web based solutions for the likes of MySQL/MariaDB, actually pleasant to use as long as you use it securely, this I think is a good example of web based DB tools https://www.adminer.org/

13. Adminer

    11 58 6,980 9.9 PHP

    Database management in a single PHP file

    

    > browser based

    For whatever reason, this is the main limiting factor, because local software can be really good, for example:

    DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/

    DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/

    DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/

    HeidiSQL - haven't really used this myself but the version graph on the page is cool https://www.heidisql.com/

    There's also some solutions that are specific to certain databases, like:

    pgAdmin - for PostgreSQL https://www.pgadmin.org/

    MySQL Workbench - for MySQL/MariaDB, sometimes a bit buggy but I really like the reverse engineering and forward engineering functionality https://www.mysql.com/products/workbench/

    (out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)

    Adminer - one of the somewhat rare web based solutions for the likes of MySQL/MariaDB, actually pleasant to use as long as you use it securely, this I think is a good example of web based DB tools https://www.adminer.org/

14. Metabase

    12 85 43,423 10.0 Clojure

    The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

    

    The Web UI over DB is also the motivation of more BI oriented tool https://github.com/metabase/metabase

15. qstudio

    13 12 749 9.2 Java

    qStudio - Free SQL Analysis Tool

    

    QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author

16. dbgate

    14 36 6,351 9.9 Svelte

    Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

    

17. dbeaver-jdbc-libsql

    15 1 69 7.3 Java

    LibSQL JDBC driver

    

18. tbls

    16 8 3,958 9.1 Go

    tbls is a CI-Friendly tool to document a database, written in Go.

    

    Two more tools I really enjoy:

    - https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

    - https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)

19. enventory

    17 6 17 8.9 Go

    Centrally manage environment variables with SQLite

    

    Two more tools I really enjoy:

    - https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

    - https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)

20. beekeeper-studio

    18 66 20,344 9.9 TypeScript

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    

    Two more tools I really enjoy:

    - https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

    - https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)

21. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project