Repolode
Submit
libredb

libredb/libredb-studio

A browser-based SQL IDE that deploys beside your data and connects to dozens of databases and data stores, with SSO, audit trail and AI-assisted queries under MIT.

Open-source alternative to:DBeaverTablePlus

View on GitHubWebsite
Stars
1,230
Forks
265
Open issues
56
Last commit
22 hours ago

What is it?

LibreDB Studio is a web-based database editor that you run yourself, typically as a container, a Helm chart, or an npm package embedded in your own product. Instead of opening database ports to a laptop or installing a desktop client on every machine, the editor sits next to the data and is reached through the browser. A single interface covers a long list of engines, including PostgreSQL, MySQL, Oracle, SQL Server, SQLite, DuckDB, MongoDB, Redis, ClickHouse, Elasticsearch, Kafka, Neo4j and Kubernetes, with an explorer, a Monaco-based SQL editor, a schema-aware data grid, and ER diagrams where the engine supports them.

The project also includes an admin layer for teams: local login or OIDC single sign-on, role-based access control, a query audit trail, and a DBA panel with monitoring and maintenance commands on supported engines. An optional database agent can draft SQL and write a report from results, using Gemini, OpenAI, or a local Ollama model. Its read-only enforcement and per-engine support are documented separately. Many engines are read-only in Studio by design, such as the S3-compatible, MQTT, and Kubernetes connectors.

The project is written in TypeScript on Next.js and React and is released under the MIT license.

Key features

  • 01Browser-based SQL editor built on Monaco, with schema-aware autocomplete and multi-tab workspace
  • 02Single explorer and data grid across many database and data store engines
  • 03Interactive ER diagrams, schema diff and migration SQL generation for supported engines
  • 04OIDC single sign-on, role-based access control and query audit trail
  • 05Data profiler, ORM code generator and test data generator
  • 06Optional AI helpers that work with Gemini, OpenAI or local Ollama models

Use cases

  • Giving a team browser access to internal databases without exposing ports or installing clients
  • Embedding a database console inside an existing internal platform or PaaS
  • Exploring data across mixed systems such as PostgreSQL, MongoDB, Kafka and Kubernetes from one tool
  • Running self-hosted SQL access with SSO and an audit trail for compliance reviews

Quick start

  1. 1

    Run with Docker (recommended)

    docker run -p 3000:3000 ghcr.io/libredb/libredb-studio:latest
  2. 2

    Or run with Node.js 24+ without Docker

    npx @libredb/studio
  3. 3

    Open http://localhost:3000 in your browser; the admin password is printed to the log on first run

Things to know

  • If accessed over a LAN address without HTTPS, you must set AUTH_COOKIE_SECURE=false or login fails silently.
  • Several engines are read-only by design, such as Druid, Elasticsearch and OpenSearch, which lack UPDATE and CREATE TABLE.

Topics

#sql-editor#database#self-hosted#postgresql#mysql#mongodb#web-ui#sso#cassandra#clickhouse

FAQ

What is libredb-studio?
A browser-based SQL IDE that deploys beside your data and connects to dozens of databases and data stores, with SSO, audit trail and AI-assisted queries under MIT. LibreDB Studio is a web-based database editor that you run yourself, typically as a container, a Helm chart, or an npm package embedded in your own product. Instead of opening database ports to a laptop or installing a desktop client on every machine, the editor sits next to the data and is reached through the browser. A single interface covers a long list of engines, including PostgreSQL, MySQL, Oracle, SQL Server, SQLite, DuckDB, MongoDB, Redis, ClickHouse, Elasticsearch, Kafka, Neo4j and Kubernetes, with an explorer, a Monaco-based SQL editor, a schema-aware data grid, and ER diagrams where the engine supports them.
Is libredb-studio free to use? What license does it have?
libredb-studio is open source under the MIT license. Check the license terms before using it in commercial products.
Is libredb-studio still maintained?
Actively maintained. The last commit to libredb-studio was on Oct 19, 2026.
What can I use libredb-studio for?
Giving a team browser access to internal databases without exposing ports or installing clients Embedding a database console inside an existing internal platform or PaaS Exploring data across mixed systems such as PostgreSQL, MongoDB, Kafka and Kubernetes from one tool Running self-hosted SQL access with SSO and an audit trail for compliance reviews
How do I install libredb-studio?
Run with Docker (recommended): docker run -p 3000:3000 ghcr.io/libredb/libredb-studio:latest Or run with Node.js 24+ without Docker: npx @libredb/studio Open http://localhost:3000 in your browser; the admin password is printed to the log on first run
Where can I get libredb-studio?
The source code and installation instructions are on GitHub: https://github.com/libredb/libredb-studio

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects