DearSQL

A simple, cross-platform database client built with Dear ImGui.

Download

Features

• SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis and more
• Cross-platform: macOS (Metal), Linux (GTK4 + OpenGL), Windows (DirectX 11)
• Database browser: Sidebar for exploring schemas, tables, and structure
• Native file dialogs for SQLite files
• Native alert/confirm dialogs per platform
• Saves and restores previous database connections
• Run SQL queries with formatted results display
• Query history

Command line

The same binary runs in the terminal (docs):

dearsql --tui [connection]   # browse and query in the terminal
dearsql --mcp                # database tools for coding agents (MCP)
dearsql --lsp                # SQL completion and hover for editors

A connection is a saved name, a URL, or a SQLite/DuckDB/CSV file. For agents:

claude mcp add dearsql -- dearsql --mcp

Installation

Download the latest release for macOS, Linux, and Windows from GitHub Releases, or on macOS/Linux:

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

Arch Linux (AUR)

yay -S dearsql
# or
paru -S dearsql

Build instructions

./scripts/build
# or
claude "build this project"

Built With

• Dear ImGui - Immediate mode GUI
• Native File Dialog - File pickers
• IconFontCppHeaders - Icon fonts
• vcpkg.json - Full dependency list