Skip to content

Mission 03 · Open source · Desktop app

Plutón SQL

An open source SQL database manager for Linux and Windows.

Platform
Linux and Windows
Stack
Go · Wails · Svelte
Fig. 1 · Plutón SQL query editor with results

01

The mission

A lightweight desktop tool to work with several SQL engines from one place, that never touches the database without first showing what it will run, and never leaves data half-written: every change goes in one transaction and applies entirely or not at all.

Database manager for PostgreSQL, MySQL/MariaDB, SQLite and SQL Server, on Linux and Windows. Schema explorer, context-aware autocomplete, data and structure editing that shows the exact SQL before applying it, and import and export with no row limit.

  • Four SQL engines
  • Changes in a single transaction
  • Passwords in the system keyring

02

What it does

  1. 02.1Editor with autocomplete

    Suggests tables and columns by context (after FROM, after an alias or inside the query) and quotes names the way each engine needs.

  2. 02.2Data editing

    Paging, sorting, WHERE filters and cell and row editing. Nothing is written until you apply, and it all goes in a single transaction.

  3. 02.3Structure with the SQL in view

    Columns, indexes, foreign keys and DDL. Every change first shows the exact SQL, with warnings when it's destructive.

  4. 02.4Import and export

    Exports every row to CSV, JSON or INSERT by streaming, and imports CSV with a preview and column mapping.

  5. 02.5Workspaces and history

    Connections grouped by workspace, per-connection history and saved queries, plus opening and saving .sql files.

  6. 02.6Passwords in the keyring

    Passwords go to the system keyring (Secret Service or Credential Manager), never to a config file.

03

How it's built

The backend is Go with Wails v2 and the UI is Svelte and TypeScript, with the editor built on CodeMirror. The database drivers are pure Go, so it cross-compiles for Linux and Windows without CGO, with .deb and .rpm packages and a Windows installer. It runs on Wayland and X11, and even connects to SQL Server 2005 and 2008 over TLS 1.0.

Stack

  • Go
  • Wails
  • Svelte
  • TypeScript
  • CodeMirror

04

On screen

Fig. 2 · Table data in Plutón SQL