DearSQL

A cross-platform native database client built with Dear ImGui, covering MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and more from one binary that also runs as a terminal client, a language server, and an MCP server for coding agents.


About

DearSQL ships a schema browser, an editable data grid, a SQL editor with completion and syntax checks, charts, and a JSON view, running natively on macOS (Metal), Linux (GTK4 + OpenGL), and Windows (DirectX 11). Its query-plan analysis (EXPLAIN/ANALYZE) flags full scans, repeated scans, large sorts, and bad estimates, and the same binary doubles as a terminal client (--tui), an MCP server (--mcp) for tools like Claude Code and Codex, and a language server (--lsp) for SQL completion and hover in editors.

For coding agents, DearSQL exposes saved connections as read-only-by-default tools — schema search, table description, query execution with paging, index review, and schema diffing — with any write requiring explicit approval. It’s released under the Functional Source License 1.1 (Apache 2.0 Future License), a source-available license under which each release converts to Apache 2.0 two years after publication.

Category Software & Tools
Subcategory Database Management & GUI, AI & Ecosystem Skills
✎ Suggest an update

Community feedback

This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.