# DearSQL

> A native desktop SQL client for SQLite, DuckDB, PostgreSQL, MySQL, MariaDB, MongoDB, Redis, SQL Server, Oracle, Cassandra and Redshift, on macOS, Linux and Windows. The same `dearsql` binary also runs in a terminal: `--tui` (terminal client), `--mcp` (database tools for coding agents) and `--lsp` (SQL completion for editors).

Install on macOS (Apple silicon) or Linux, non-interactively: `curl -fsSL https://dearsql.dev/install.sh | sh`. Then register the agent tools with `claude mcp add dearsql -- dearsql --mcp`. Every page below is plain markdown; all of them in one file: https://dearsql.dev/llms-full.txt

## Getting started

- [Connections](https://dearsql.dev/docs/connections.md): Connect to SQLite, DuckDB, PostgreSQL, MySQL, MongoDB, Redis and more, over SSL or an SSH tunnel.
- [Browsing data](https://dearsql.dev/docs/browsing-data.md): The sidebar tree, the table viewer, filtering, inline editing and the inspector panel.
- [SQL editor](https://dearsql.dev/docs/sql-editor.md): Run queries, read multi-statement results, and keep scripts around.
- [Command line](https://dearsql.dev/docs/command-line.md): Run DearSQL from a terminal: open the app, browse in a terminal UI, give your coding agent database tools, or get SQL completion in your editor.

## AI assistant

- [AI assistant](https://dearsql.dev/docs/ai-assistant.md): Open a chat on a connection, pick a coding agent or an API key, and pick up earlier chats.
- [Context and commands](https://dearsql.dev/docs/ai-context.md): Pin tables with @, run commands with /, and see what actually gets sent.
- [Database tools](https://dearsql.dev/docs/ai-database-tools.md): Let the agent search your schema, run queries, make changes you approve, and open or add connections.

## Data

- [Import and export](https://dearsql.dev/docs/import-export.md): SQL dumps for MySQL and PostgreSQL, plus CSV files.

## Pricing

Free: every database and feature, up to 10 saved connections and 2 workspaces. Pro: a one-time purchase that removes both limits.

## Optional

- [Changelog](https://dearsql.dev/changelog)
- [Compare with other SQL clients](https://dearsql.dev/compare)