Does DearSQL support TLS/SSL connections?

Yes. All server-type backends support TLS/SSL encryption with configurable modes including disable, prefer, require, verify-ca, and verify-full depending on the database.

open source

DearSQL — Native SQL client for macOS, Linux & Windows.

AI-powered ImGui-powered.

No Electron. No JVM. No bloat. Built with C++.

* SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, Oracle, MSSQL, Cassandra, Redshift* SSH tunneling & TLS* AI agents: Claude Code, Codex, Gemini CLI, Cursor

DearSQL connects to SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, Oracle, MSSQL, Cassandra, and Redshift from a single app. Browse schemas, edit table data inline, write queries with full syntax highlighting, and route connections through SSH tunnels or TLS/SSL — all from a native C++ interface that starts in under a second. Compare DearSQL to TablePlus, DBeaver, and DataGrip →

> Downloads

v0.6.0 · changelog

* macOS (.dmg)[28 MB]

* Linux (AppImage, x86_64)[40 MB]

or:ARM64 (aarch64)or:

curl -fsSL https://dearsql.dev/install.sh | sh

* Windows (.msi)[16 MB]

DearSQL SQL client on macOS — PostgreSQL schema browser

Features

- Syntax highlighting, query history, and autocomplete that knows your schema, aliases and CTEs.
- Browse and edit table data inline. Changes generate proper SQL before committing.
- SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, Oracle, MSSQL, Cassandra, and Redshift in one app.
- Saved connections with encrypted credentials.
- Schema browser — tables, views, indexes, and more.
- AI agents in the app: Claude Code, Codex, Gemini CLI, Cursor or your own API key. They can read your schema, run read-only queries, and make changes only after you approve them.
- SQL dump import/export for MySQL and PostgreSQL. Open CSV files and query them with SQL.
- Your saved connections in the terminal too: dearsql --tui to browse, --mcp for coding agents, --lsp for SQL completion in Neovim, Helix, VS Code or Emacs.
- Native C++ with Metal on macOS, OpenGL on Linux, and DirectX on Windows.

Supported Databases

SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, Oracle, MSSQL, Cassandra, Redshift.

FAQ

What databases does DearSQL support?

SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, Oracle, MSSQL, Cassandra, and Redshift — all in one native desktop app. No need to switch between tools.

Is DearSQL free?

Yes. The free tier includes all database types and core features with up to 10 saved connections and 2 workspaces. The Pro license ($35 one-time) unlocks unlimited connections and workspaces.

What platforms does DearSQL run on?

DearSQL runs natively on macOS (Metal), Linux (OpenGL), and Windows (DirectX). Built with C++ and ImGui — no Electron, no JVM, starts in under a second.

Does DearSQL support SSH tunneling?

Yes. All server-type databases support SSH tunneling through a bastion or jump host, with password or private key authentication.

Does DearSQL support TLS/SSL?

Yes. All server-type backends support TLS/SSL with configurable modes — disable, prefer, require, verify-ca, and verify-full — depending on the database.

Pricing

Freeforever

- 10 saved connections
- 2 workspaces
- all database types
- all core features

Proone-time

$35

- unlimited connections
- unlimited workspaces
- all database types
- all current & future features

buy now →