SQL Explorer logo SQL Explorer
Download
HomeFeaturesPluginsDocsDownload
Features

Every table, every engine, one calm workspace

From writing a query to committing an edit and shipping an export — the whole loop lives in one native app.

Connections

One tree for every database

Relational, document and key-value engines live side by side. Group connections into folders, see live connection status, and jump between schemas without losing your place.

  • Built-in: PostgreSQL, MySQL, SQL Server, SQLite
  • Via plugins: MongoDB, Redis, DragonflyDB, Elasticsearch
  • Secrets stored in the OS keychain, never in plain text
SQL Explorer — Plugin Store
The Plugin Store listing installed database engines: PostgreSQL, MySQL, SQL Server, SQLite, MongoDB, Redis, DragonflyDB and Elasticsearch
Query editor

Write, run, save — keep your flow

A real editor with syntax highlighting and multiple tabs. Open and save .sql files with a dirty-marker, a recent-files menu and drag & drop.

  • Open/Save/Save-As with Ctrl+O / Ctrl+S
  • Rebindable shortcuts via the shortcut catalog
  • Session persistence — reopen exactly where you left off
SQL Explorer — query editor
The SQL query editor showing a SELECT with a JOIN and GROUP BY, and its result grid with the top customers by spend
Result grid

Edit results, commit changes

Treat the result grid like a spreadsheet. Change a value, add a row, and commit all pending edits in one action — SQL Explorer writes the statements for you.

  • Inline editing with a clear pending-changes indicator
  • Commit with Ctrl+Shift+S
  • Dense, fast rows built for large result sets
SQL Explorer — editable result grid
An editable result grid of customer records with Add row, Delete, Save and Export actions above it
Import & export

Move data in the format your team expects

Import from CSV, export to CSV, JSON or SQL INSERT, and for SQL Server export a full BACPAC/DACPAC — powered by the tool plugins, in-process and without external tooling.

  • CSV, JSON and SQL INSERT export — plus copy-as Markdown or HTML
  • SQL Server BACPAC/DACPAC via DacFx
  • Universal Backup & Restore across engines
The export dialog offering CSV, JSON and SQL INSERT for the whole result set
Extensibility & AI

Grow the app — and let AI help, safely

Add engines and tools through runtime plugins. Turn on the optional MCP server and AI assistants can query your data with guardrails you set.

  • Isolated plugin loading — a plugin can't destabilise the host
  • MCP server is off by default — access is opt-in per connection
  • Read-only or read-write per connection (DDL always rejected), loopback + bearer token, and an opt-in audit log
Explore the plugin ecosystem →
settings.json — AI access
// off by default — you opt in
"McpEnabled":     true,
"McpPort":        5488,   // loopback only (127.0.0.1)
"McpRequireAuth": true,   // bearer token required
"McpMaxRows":     200,    // hard server-side row cap
"QueryLogMcp":    true    // audit every AI query

// Access is per connection, fail-closed:
//   AiAccess = None (default) | ReadOnly | ReadWrite
//   DDL is always rejected · result secrets redacted

Keyboard-first, and rebindable

Every action has a stable id and a default gesture you can change.

Run queryExecute the whole query
F5
Run at cursorExecute just the statement at the cursor
Ctrl + Enter
Open .sql fileLoad a query from disk
Ctrl + O
Save queryWrite the current tab back to its file
Ctrl + S
Commit grid editsPersist pending edits to the database
Ctrl + Shift + S
New query tabOpen a fresh editor tab
Ctrl + T

Ready to try it?

Download SQL Explorer and connect your first database in under a minute.

Download freeBrowse plugins