Repolode
Enviar
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.

Alternativa open source a:DBeaverTablePlus

Ver no GitHubSite
Estrelas
1,230
Forks
265
Issues abertas
56
Último commit
há 1 hora

O que é?

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.

Recursos principais

  • 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

Casos de uso

  • 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

Tópicos

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

Perguntas frequentes

O que é 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.
libredb-studio é gratuito? Qual é a licença?
libredb-studio é open source sob a licença MIT. Confira os termos da licença antes de usá-lo em produtos comerciais.
libredb-studio ainda é mantido?
Manutenção ativa. O último commit de libredb-studio foi em 19 de out. de 2026.
Para que posso usar libredb-studio?
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
Onde consigo libredb-studio?
O código-fonte e as instruções de instalação estão no GitHub: https://github.com/libredb/libredb-studio

Resumo gerado por IA a partir do README do projeto. As estatísticas do GitHub são atualizadas diariamente.

Projetos relacionados