LibreDB Studio

This package is maintained by the LibreDB project itself. It repackages the official upstream desktop build unmodified.

LibreDB Studio is an open-source SQL IDE for developers and data teams. The desktop app runs entirely on your machine: it starts a local LibreDB Studio server in the background and shows it in a native window. Nothing is sent to a cloud service.

Databases it speaks:

• PostgreSQL
• MySQL and MariaDB
• SQLite
• Microsoft SQL Server
• Oracle Database
• MongoDB
• Redis

What you get:

• A Monaco-based SQL editor with schema-aware completion and formatting
• A virtualized results grid built for large result sets, with CSV and JSON export
• Schema browser, entity-relationship diagrams and index advice
• Query plans, slow-query and session monitoring
• Optional AI assistance (natural language to SQL, query explanation) using your own API key
• An embedded sample database, so there is something to query on first launch

Connections are made over TCP, which covers a database running on this machine as well as a remote one, and those need no extra permission. The sandbox has no access to your home directory by default, so the cases that read a path from disk have to be granted once: a SQLite database file with "flatpak override --user --filesystem=/path/to/db.sqlite org.libredb.Studio", a database listening on a Unix socket with "--filesystem=/run/postgresql:ro", and the SSH-tunnel feature with "--filesystem=~/.ssh:ro".

Updates arrive through "flatpak update": FlatPark re-pins this package whenever a new LibreDB Studio release is published on GitHub.