libredb-studio

Project Overview

LibreDB Studio is an open-source SQL IDE that deploys next to your data, not on your laptop. It runs as a container, Helm chart, or one-click template on your PaaS, eliminating the need to expose your database to the internet.

Key Features

• 14+ database engines: PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Redis, Couchbase, ClickHouse, Druid, Elasticsearch, OpenSearch, Apache Trino, Apache Cassandra
• Unified interface: The same explorer and interface for all engines
• ER diagrams, schema diff, and monitoring: Entity relationship diagrams, schema comparison, and database monitoring
• SSO and audit trails: Single sign-on with complete audit logging
• AI-assisted queries: AI-powered query assistance

Target Audience

• Developers and administrators who need to manage multiple databases
• Teams who want to deploy SQL IDE next to their data rather than on laptops
• Enterprise users who require SSO and audit capabilities

Quick Start

# Docker (recommended)
docker run -p 3000:3000 ghcr.io/libredb/libredb-studio:latest

# Or with Node.js 24+ (no Docker)
npx @libredb/studio

Open http://localhost:3000. On first run, the admin password is printed to the log.

Core Advantages

• Deploys next to your data without exposing databases to the internet
• Supports 14+ database engines
• Fully open-source under MIT license with no enterprise feature restrictions
• SSO, audit trails, and AI-assisted queries included