sqlrsqlr manual
Last updated: 29 October 2026.
sqlr is a desktop database client for people who query databases, maintain their structure and move data between systems. You can use relational databases, MongoDB, Elasticsearch and Redis from the same window. Saved connections keep the details you need to return to your work; drivers determine which tools each database offers.
This manual describes the application as shipped. Database permissions still apply to every action. An action that your driver does not support is hidden or disabled.
Where to start
| Your work | Start with |
|---|---|
| First time using sqlr | Get your first result, using the local demo database |
| Querying and editing data | Write and run SQL, then Work with results |
| Maintaining a database | Profiles and transactions, then Administration |
| Moving data | Import, export and backup |
| Connecting an AI client | Agents and the terminal, including connection access levels |
Connect and explore
- Getting started: install sqlr, open the demo database and run your first query.
- Connections: save connection settings, configure SSH and TLS, and reconnect.
- Import and export connections: bring saved connections from another client or export them for another setup.
- Explorer and object editors: find objects, inspect DDL and apply structure changes.
Query and change data
- SQL editor: run statements and scripts, use completion, and reuse history and snippets.
- Results and data editing: fetch, sort, copy, inspect and change rows.
- Profiles, transactions and safety: choose commit behavior and control writes.
Move and maintain
- Import, export, transfer and backup: map columns, run transfers and use native backup tools.
- Schema tools: compare structures, draw relationships, read query plans and generate test data.
- Administration: manage roles, inspect sessions and locks, and monitor operations.
- Document and key-value databases: query documents and work with Redis keys.
Configure and get help
- Drivers: install sidecar drivers and manage their versions and prerequisites.
- Settings and shortcuts: change preferences, key bindings and storage locations.
- Agents and the terminal: grant MCP access, handle approvals and use the integrated shell.
- Glossary: understand the terms used throughout the manual.
- Troubleshooting: resolve common problems and prepare a local diagnostics report.
Find your way around the window
The Explorer on the left contains your connections and database objects. The center holds editor and object tabs. Query results appear below their editor; the value panel lets you inspect a selected value in full. The toolbar shows the active connection and execution controls. The status bar reports the active session, transaction state and result timing.
Use ⌘P to find an object and ⇧⌘P to find a command. Keyboard examples use macOS notation; use Ctrl in place of ⌘ on Windows and Linux unless a page gives a platform-specific chord. You can change bindings in Preferences → Keymap.
Work that takes time appears in Operations. You can cancel an operation while continuing to work in another tab. Grid edits and schema edits wait for Apply; statements you run in the editor follow the session's commit mode instead.