Open Source  ·  GPL v3  ·  v0.1.0

qub

The SQL editor I built because I needed it.
Shared because you might too.

prod-postgres
staging-mysql
TABLES
users
orders
products
sessions
HISTORY
SELECT * FROM users
UPDATE orders SET …
1SELECT u.id, u.name, u.email,
2       o.total AS last_order
3FROM users u
4JOIN orders o ON o.user_id = u.id
5WHERE u.active = true
6  AND o.created_at > '2026-01-01'
7ORDER BY o.total DESC
8LIMIT 100;
▶ Run
↓ CSV
★ Save
id
name
email
last_order
1
Alice
alice@acme.io
4 820.00
2
Bob
bob@acme.io
3 100.00
3
Carol
carol@acme.io
1 540.00
prod-postgres
3 rows · 12 ms

Features

The basics, done well

No clutter, no plugins, no subscriptions. Just a focused SQL editing environment that stays out of your way.

Editor
SQL-centric workspace

The editor is the center of the experience. Write SQL without hunting through menus or fighting modal dialogs.

Connections
Multiple simultaneous tabs

Open several database connections at once and switch between them with tabs. Credentials are stored securely in your OS keychain.

History
Automatic query history

Every query you run is saved automatically. Browse or search your history and rerun any past query in one click.

Library
Saved queries

Save frequently used SQL into named folders. Build up a personal query library that grows with your workflow.

Sessions
Workspace restore

Save your current workspace and restore it later, exactly as you left it — connections, SQL, and all.

Results
CSV export

Export query results to CSV with one click. Share data with your team without copy-pasting from a grid.


Databases

Connects to what you already use

Built on Qt's SQL module, qub supports any database that Qt can talk to out of the box.

PostgreSQL
MySQL
SQLite
ODBC
Oracle (OCI)
Firebird

Story

Why qub exists

There are great open-source SQL editors out there, but none of them ever really clicked for me. DataGrip was the one that gave me the feeling of productivity and control over my database workspace. But once my enterprise license got canceled, instead of picking a new one I decided to build myself an editor the way I always wanted it to be.

So qub was built with an emphasis on SQL centricity, the basics done well, and a clean interface I enjoy looking at all day.

During development, to keep the interface consistent and easier to build, I created a Qt/QML component library (including fonts, icons, and theming) called Mahina, which I also open-sourced. If you're building desktop apps with Qt, it might save you from reimplementing the same primitives from scratch.