Desktop app · macOS, Windows, Linux · Open source

Sagittarion is a desktop GUI for SQLite and PostgreSQL.

Open SQLite files on your computer, or in place on a server over SSH. Connect to PostgreSQL directly or through an SSH tunnel. Then browse, edit and query, or ask a question in plain English.

DownloadView on GitHub
Sagittarion with two connections open. The question “top 10 customers by revenue last quarter” has become a PostgreSQL query in the editor, its ten result rows are below, and the chat on the right explains the query and its assumptions.

What it does.

Editing

Stage edits, apply them in one transaction.

Cell edits, NULLs, new rows and deletions stay highlighted until you apply them together. Every statement must match exactly one row, or the whole batch rolls back.

A users table with a changed cell, a cell set to NULL and a row marked for deletion, waiting behind an Apply 4 button
SQL editor

Run the statement you're looking at.

⌘↩ runs the block under the cursor and ⌘⇧↩ runs everything. Suggestions follow the statement, and rows from a plain SELECT can be edited in place.

The SQL editor with two statements separated by a blank line, and the results of the first one below
Ask in plain English

A question in, a read-only query out.

A model you choose writes the SQL. Only a single SELECT is accepted, it is checked withEXPLAIN and run read-only, and the chat says what it assumed.

PostgreSQL

Direct, or through an SSH tunnel.

Schemas, functions and procedures in a sidebar that stays quick with a hundred thousand tables.bigint and numeric values never round.

Workspace

Several connections, as you left them.

Every connection is a tab, and its tabs, queries and results come back when you reopen the app. Group connections and reuse SSH profiles.

SQLite over SSH.

The file never leaves the server. Three moving parts, all of them boring on purpose.

The connection form with “The file is on another machine: connect over SSH” ticked, and fields for the SSH host, port, username and key

What you need

  • On the server: an SSH login and python3 3.5 or newer, which Debian, Ubuntu, Fedora, Raspberry Pi OS and most NAS systems already have. SFTP is optional, for the file browser.
  • On your computer: macOS, Windows or Linux. Local SQLite files use python3 as well; on a Mac the Xcode Command Line Tools provide it.
  • For PostgreSQL: version 12 or newer.
  • For Ask: a key for OpenAI, Anthropic, Google Gemini, OpenRouter or Groq, or a local server such as Ollama or LM Studio.

Download.

Free for macOS, Windows and Linux. Every build is published on GitHub.

macOS

Apple silicon and Intel

.dmg or .zip

Latest releaseWindows

64-bit installer

.exe

Latest releaseLinux

AppImage or Debian package

.AppImage or .deb · x86_64

Latest release

Rather build it yourself? Clone the repository, then runnpm install and npm run dist.

Questions.

Is Sagittarion free?

Yes. It is open source under the MIT license. Download a build from GitHub, or build it from the source.

Does it install anything on the server?

No. For SQLite over SSH, a small Python script that uses only the standard library is sent over the connection each time you connect, and runs as your user. Nothing is left behind, and the sqlite3 command-line tool is not needed.

Can Ask change my data?

No. Only a single SELECT is accepted, and it runs under SQLite's query_only pragma or inside a PostgreSQL READ ONLY transaction. You can also turn off automatic runs and review each query first.

What does the model see?

Your question and a compact description of the tables that matter to it. Sample values are sent only if you turn that on. With your own key, requests go straight from the app to the provider. With a local server such as Ollama, nothing leaves your machine.

Does Sagittarion collect any data?

No. There is no account and no telemetry. It connects only to the databases, SSH hosts and model provider you set up.

Are jump hosts or ~/.ssh/config supported?

Not yet. Password, private key and SSH agent authentication work today.