Find your way
through the schema.
Browse databases, schemas, and tables. Inspect data, columns, indexes, and constraints.
Explore tables, run SQL, and edit data in a native Linux workspace for PostgreSQL and SQLite.
PostgreSQL + SQLite · Native Linux app · Built in Rust
Browse databases, schemas, and tables. Inspect data, columns, indexes, and constraints.
Run selected SQL or an entire script. Each query tab has its own session, and each statement gets its own results.
Search query history and reopen SQL with its original connection and database.
Insert rows with explicit values, NULLs, or database defaults for each field.
Updates and deletes use the table’s primary key and check the original row. Conflicting edits stop before overwriting newer changes.
Your SQL drafts, open table tabs, layout, and appearance preferences are there when you return.
Ctrl+N for a query tab. Ctrl+Enter to run SQL.
Open a cell’s full contents and copy its value.
Create, rename, clone, or delete a database. Inspect sessions.
PostgreSQL and SQLite. Connect to a PostgreSQL server, open an existing SQLite file, or create a new SQLite database.
Linux, with Wayland and X11 support.
Insert rows with explicit values, NULLs, or database defaults. Update and delete rows in writable tables with a primary key, including composite keys. Queri stops conflicting edits before overwriting newer changes.
Connection metadata, preferences, SQL drafts, and query history. Saved PostgreSQL passwords are stored in your system’s Secret Service keyring.
SQL drafts, query history, open table tabs, layout, and preferences. Temporary database objects and uncommitted transactions do not survive a restart.
Requires the native Rust checkout, Wayland or X11, and OpenGL or Vulkan. Saved passwords need an unlocked Secret Service keyring; file dialogs use xdg-desktop-portal.
On Debian or Ubuntu:
sudo apt install build-essential clang cmake pkg-config libssl-dev libdbus-1-dev \
libfontconfig1-dev libfreetype6-dev libwayland-dev libxkbcommon-dev \
libxkbcommon-x11-dev libxcb1-dev libxcb-xkb-dev libvulkan1 libegl1 \
desktop-file-utilsFrom the native source directory containing Cargo.toml:
cargo run --lockedOptional; requires Python 3. Installs to ~/.local. Use the generated archive name for your architecture.
bash scripts/package-linux.sh
tar -xf dist/specdb-0.1.0-linux-x86_64.tar.gz
./specdb-0.1.0-linux-x86_64/install.sh