🖊️ SQL Query Editor

Write, run, and format SQL with a professional-grade editor designed for speed.

⌨️

Keyword Autocomplete

Live-filtered SQL keyword popup appears after 2+ characters. Navigate with arrow keys, confirm with Tab or Enter — no mouse required.

📑

Multi-Tab Editor

Open multiple query tabs per connection. Each tab has its own editor state, result grid, and history — just like a real IDE.

⚡

Keyboard-First Execution

F5, F9, or Ctrl+Enter to run. Ctrl+Shift+E to EXPLAIN. F12 to format. Ctrl+Shift+U/L for case conversion. Full keyboard workflow.

🕒

Query History

Every executed query is auto-saved with timestamp, duration, and error status. Tap any entry to reload it into the editor.

📊 Results Grid

View and edit query results with a high-performance virtual grid supporting thousands of rows.

✏️

Inline Row Editing New

Toggle edit mode on any SELECT result. Change cell values and save — SQLvanta auto-generates UPDATE statements using the first column as PK.

📤

CSV Export

Export any result set to a CSV file in the Downloads folder with one click. Proper quoting handles commas, quotes, and newlines.

📋

Copy as SQL

Right-click any row to copy it as an INSERT or UPDATE statement — useful for reproducing issues or seeding test data.

🔍

Column Filter

Toggle per-column filter inputs to search within large result sets without re-running the query.

🗃️ Table Data Browser

Browse any table without writing SQL — with smart pickers for dates and foreign keys.

📅

Date Picker

Date, datetime, and timestamp columns show a calendar picker when editing — no need to remember ISO format strings.

🔗

FK Row Picker

Foreign key columns open a searchable popup showing the referenced table's rows. Pick the right value without looking up IDs manually.

📥

CSV Import New

Paste CSV text, preview the first 5 rows, then import all rows as INSERT statements — with header detection and NULL handling.

🔢

Pagination Control

Set the starting offset and row limit. Load exactly the window of data you need for large tables.

🗺️ Schema Tools

Visualise, explore, and alter your database schema without memorising ALTER TABLE syntax.

🧩

ER Diagram Designer

Drag-and-drop canvas. Zoom, pan, show/hide tables via sidebar. Cross-database FK tables auto-loaded with db.table headers. Export as PNG.

🔬

Schema Explorer

Columns tab with PK/FK/UQ badges, full type display, and clickable FK navigation. Relationships tab shows incoming and outgoing FKs. DDL preview with copy.

🔧

ALTER TABLE UI New

Add, modify type, rename, and drop columns through a guided form. SQL preview shown before execution — no typos in production.

🔎

Query EXPLAIN Visualizer New

Run EXPLAIN on any SELECT with Ctrl+Shift+E. Color-coded access types (ALL=red, const=blue), rows-scanned bars, and key/extra highlighting.

🌲 Object Browser

Navigate your entire database structure from an intelligent sidebar.

🗄️

Lazy-Loaded Tree

Databases and tables load on demand. Expand a database to see tables, views, stored procedures, triggers, and events — each in their own group.

🏷️

PK / FK / UQ Badges

Each column in the tree shows colour-coded badges for Primary Key, Foreign Key, and Unique constraints at a glance.

⚡

Double-Click to Load

Double-click any table to instantly switch to the Table Data tab and load the first 1 000 rows — no SQL needed.

🔍

Real-Time Search

Filter tables and columns across all databases as you type. Find any object in large schemas instantly.

📊 How SQLvanta Compares

SQLvanta vs popular MySQL GUI tools — all features, zero cost.

Feature	SQLvanta	MySQL Workbench	HeidiSQL	DBeaver CE	TablePlus
Free & Open Source	✓ Free	✓ Free	✓ Free	✓ CE Free	Freemium
Windows / macOS / Linux	✓ All 3	✓ All 3	Windows only	✓ All 3	✓ All 3
Visual ER Diagram	✓	✓	✗	✓	✗
SQL Autocomplete	✓	✓	Basic	✓	Basic
Query EXPLAIN Visualizer	✓	✓	✗	✓	✗
Inline Table Editing	✓	✓	✓	✓	✓
FK Row Picker	✓	✗	✗	✗	✗
CSV Import via UI	✓	Wizard	✓	✓	✓
ALTER TABLE UI	✓	✓	✓	✓	Partial
Built with Flutter (native perf)	✓	✗	✗	✗	✗
In-app Update Checker	✓	✗	✗	✗	✓

Everything You Need toManage MySQL Databases