Docs
How to use DearSQL, one feature at a time.
Getting started
- Connections
Connect to SQLite, DuckDB, PostgreSQL, MySQL, MongoDB, Redis and more, over SSL or an SSH tunnel.
- Browsing data
The sidebar tree, the table viewer, filtering, inline editing and the inspector panel.
- SQL editor
Run queries, read multi-statement results, and keep scripts around.
- Command line
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
Open a chat on a connection, pick a coding agent or an API key, and pick up earlier chats.
- Context and commands
Pin tables with @, run commands with /, and see what actually gets sent.
- Database tools
Let the agent search your schema, run read-only queries, and open connections itself.
Data
- Import and export
SQL dumps for MySQL and PostgreSQL, plus CSV files.