What is Query Studio?

Query Studio is a free, open-source desktop database client with AI-assisted queries, SQL editing, ER diagrams, query plans and data-file tools. It connects to PostgreSQL, MySQL, SQLite, MongoDB, Redis and Firebase.

Which platforms does Query Studio support?

Query Studio runs on macOS (Apple Silicon and Intel), Windows (x64), and Linux (AppImage, .deb and .rpm). Signed updater artifacts support in-app updates. If installation fails in an older version, download the latest installer manually.

Is Query Studio free?

The app is free and open source under the MIT license. Cloud AI providers may charge for their API usage. You can also use local Ollama.

How are credentials and AI requests handled?

Saved connection secrets and API keys are encrypted locally using a key held in the OS credential store. Portable connection backups use a separate passphrase. AI features can send prompts, schema context and sampled database or query-result rows to your configured provider. Use Ollama on your own machine for local inference.

Query Studio v0.0.9 is out

Talk to your database in plain English

Write SQL or ask in plain English. Explore relationships, inspect query plans, and work with database results or local files in one desktop app. Free and open source for macOS, Windows and Linux.

Download for Free Star on GitHub

macOS Windows Linux · Free & Open Source · MIT

Query Studio

More ways to work with your data

New in v0.0.9: fixed in-app update installation. Includes the editing, exploration, connection and file tools introduced in v0.0.8.

SQL editing that knows your schema

Complete table and column names, format SQL, run a selection, and return to saved query tabs.

AI with your choice of provider

Use Gemini, OpenAI, Anthropic, DeepSeek, Groq, local Ollama, or an OpenAI-compatible endpoint. Updated suggestions preserve your saved model ID.

Relationships and query plans

Explore declared foreign keys in interactive ER diagrams. Inspect estimated EXPLAIN plans without running ANALYZE.

Results you can inspect

Resize columns, sort and filter loaded rows, scroll virtualized results, and open a cell to read its full value.

Connections with clear boundaries

Use SSH tunnels, read-only connections, groups and environment labels. Credentials are encrypted locally with a key held in the OS credential store.

Files alongside your databases

Preview CSV/XLSX files, map columns and import into SQL tables in a transaction. Query local CSV, JSON and Parquet files with DuckDB.

Compare column schemas

Compare SQL column metadata and copy conservative migration drafts for manual review. Drafts are never applied automatically.

Read-only automation

Build the CLI separately from source for allowlisted access to saved SQL connections, including MCP tools over stdio.

Also connects to MongoDB, Redis, Firestore and Firebase Realtime Database, with live Firebase streams.

Read the release notes CLI and MCP setup

Connect to the databases you already use

PostgreSQL MySQL SQLite MongoDB Redis Firestore Realtime DB

How it works

From question to result in three steps

1

Connect your database

Add your Postgres, MySQL, SQLite, MongoDB, Redis, or Firebase project. Use an SSH tunnel or a read-only connection where needed.
2

Ask in plain English

Bring your own provider key, or use local Ollama. Ask a question or write SQL with schema-aware completion.
3

Run, explain, iterate

Review the query and explanation before running it. Inspect an estimated plan, then sort, filter and explore the returned rows.

Ask in plain English

List the top 5 customers by total spend last quarter.

Generated SQL

SELECT c.id, c.name, SUM(o.total) AS spend
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.created_at >= date_trunc('quarter', now() - interval '3 months')
  AND o.created_at <  date_trunc('quarter', now())
GROUP BY c.id
ORDER BY spend DESC
LIMIT 5;

Example PostgreSQL query. Review generated SQL before execution.

Download v0.0.9

Get Query Studio for your platform

Free and open source. Direct downloads from GitHub Releases, no account required.

macOS

.dmg installer

Apple Silicon (M-series) aarch64 Intel x64

Windows

.exe / .msi installer

Windows installer x64 .exe Windows MSI package x64 .msi

Linux

AppImage / .deb / .rpm

AppImage amd64 Debian / Ubuntu .deb Fedora / RHEL .rpm

Looking for older builds? See all releases on GitHub.

Before you connect

What is Query Studio?: Query Studio is a free, open-source desktop database client with AI-assisted queries, SQL editing, ER diagrams, query plans and data-file tools. It connects to PostgreSQL, MySQL, SQLite, MongoDB, Redis and Firebase.
Which platforms does Query Studio support?: Query Studio runs on macOS (Apple Silicon and Intel), Windows (x64), and Linux (AppImage, .deb and .rpm). Signed updater artifacts support in-app updates. If installation fails in an older version, download the latest installer manually.
Is Query Studio free?: The app is free and open source under the MIT license. Cloud AI providers may charge for their API usage. You can also use local Ollama.
How are credentials and AI requests handled?: Saved connection secrets and API keys are encrypted locally using a key held in the OS credential store. Portable connection backups use a separate passphrase. AI features can send prompts, schema context and sampled database or query-result rows to your configured provider. Use Ollama on your own machine for local inference.