Repolode
投稿する
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.

代替できる製品:DBeaverTablePlus

GitHub で見る公式サイト
スター
1,230
フォーク
265
未解決の Issue
56
最終コミット
1 時間前

これは何？

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.

主な機能

  • 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

ユースケース

  • 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

トピック

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

よくある質問

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 は無料で使えますか？ライセンスは？
libredb-studio は MIT ライセンスのオープンソースです。商用製品で使う前にライセンス条件を確認してください。
libredb-studio は今もメンテナンスされていますか？
活発にメンテナンス中。libredb-studio の最終コミットは 2026年10月19日 です。
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
libredb-studio はどこで入手できますか？
ソースコードとインストール手順は GitHub にあります：https://github.com/libredb/libredb-studio

概要はプロジェクトの README をもとに AI が生成しています。GitHub の数値は毎日更新されます。

関連プロジェクト