Documentation

Getting started with Darang

Everything you need to go from download to your first query.

Installation

Darang ships as a signed desktop app for Windows, macOS, and Linux. Head to the download page — it detects your operating system and offers the right build.

  • Windows: run the .exe installer (64-bit).
  • macOS: open the .dmg and drag Darang to Applications. Pick the Apple Silicon build for M-series Macs, Intel for older models.
  • Linux: make the .AppImage executable and run it, or install the .deb on Debian / Ubuntu or the .rpm on Fedora / RHEL.

Once installed, Darang shows an Update badge at the right of the status bar when a new release is out. Click it to download, watch the progress, and restart when you're ready. Nothing downloads without your click.

Connecting to a database

Open New Connection from the menu (the hamburger at the left of the title bar) or the sidebar. Darang connects directly to your database with the native driver — no agent or middleware.

  1. Choose a type, or paste a connection string (or an ssh user@host command) into the box at the top and Darang fills the form for you. SSH hosts can also be imported from ~/.ssh/config.
  2. Name it, tag the environment (DEV, STG or PROD) and pick a colour. The sections on the left hold Security (TLS), an SSH tunnel, which databases to show, and advanced options.
  3. Press Test. Darang checks in three steps that the server is reachable, that login works and that the database opens, and shows the server version and latency.
  4. Save to keep it, or Save and connect to open it right away. Tick Ask for the password every time if you don't want it stored.

The types you can add:

  • PostgreSQL — host, port, database, user, password. Optional SSL/TLS mode and SSH tunnel. Schema and search-path aware.
  • MySQL & MariaDB — standard host/port credentials, TLS, and SSH tunnel support.
  • SQLite — pick a database file. Zero configuration; schema discovery is instant.
  • Cloudflare D1 — account ID, database ID, and an API token. Darang talks to the D1 HTTP API.
  • Elasticsearch — a node URL (the port is optional) and your credentials. Query in SQL mode, DSL mode or ES|QL.
  • SSH host — address, user and a password, key or agent. SSH hosts are a connection kind of their own, not a database, and can also serve as the tunnel for a database connection.

A connection to this computer stays on this device and isn't synced. Credentials are encrypted locally the moment you save — see how your credentials are stored.

A quick tour of the workspace

  • Navigator (left) — every connection you have open, with its databases, schemas, tables, views, routines and triggers in a searchable tree. A status ball on each connection shows whether it is connected, reconnecting or in error, and a right-click menu offers New Query, Refresh, Edit Connection and Disconnect.
  • Vertical tabs — queries, notebooks, ERDs, table editors and dashboards open as tabs grouped under their connection, so editors stay organised by server and database. The layout is restored when you reopen the app.
  • Editor / notebook (centre) — a Monaco-powered SQL editor with dialect-aware autocomplete, or a notebook that interleaves Markdown and runnable SQL cells.
  • Results grid (bottom) — a virtualized table that scrolls through hundreds of thousands of rows, with inline editing and one-click charts.
  • Launcher — press Alt + L (Cmd + L on macOS) to search commands, switch databases, or open the Schema, Explorer and Settings apps. Notebooks, dashboards and folders get New, Rename and Delete actions in the tree, the Explorer and the launcher.

You can stay connected to several databases and SSH hosts at once. Each keeps its own tabs and draft queries.

Long-running queries execute in an isolated worker process, so the interface never freezes — you can keep browsing schema or cancel the query at any time.

The SSH workspace

Save an SSH host the same way you save a database, then open it from the sidebar. Each host gets its own workspace:

  • Terminal — an interactive session with copy, paste and scrollback.
  • SFTP — browse the remote file system and move files.
  • Monitor — live CPU and memory charts for the host.
  • Tunnels — chain jump hosts, forward local or remote ports, or pick a host as the tunnel for a database connection.

SSH passwords, keys and passphrases are encrypted locally like every other credential.

SQL notebooks

A notebook is a document of alternating Markdown and SQL cells. Run a cell on its own or run the whole notebook top to bottom. Each cell records its execution time, and outputs are cached locally so they're still there when you reopen the file. Notebooks are ideal for data investigations, runbooks, and shareable analysis.

The ERD studio

Open an ERD tab to see your schema as an interactive diagram. Darang reads foreign keys, constraints, column types and indexes, then lays the tables out automatically with a hierarchical graph engine. Drag nodes to refine the layout, inspect a table inline, and export the diagram to SVG or PNG.

The visual schema builder

Right-click a table (or use Add Column in a new table editor) to change structure without hand-writing DDL. Each object gets a tabbed editor — columns, indexes, foreign keys, checks, exclusions, partitions, and row-level security on PostgreSQL. The SQL Code tab shows the exact statements Darang will run; nothing is applied until you hit Save Changes. Views, triggers, functions and scheduled events have their own editors too.

Results, export & charts

  • Scroll large result sets smoothly with the virtualized grid.
  • Edit cells inline where the result set maps back to a single table.
  • Export results to CSV, JSON, or SQL INSERT statements.
  • Turn a result into a bar, line, pie, scatter or gauge chart, and pin charts onto a dashboard.

A separate Database Insights view charts connection counts, index vs sequential reads, and operation throughput in real time.

The AI assistant

The assistant is optional and runs on your model. In settings, connect Anthropic, Google Gemini or DeepSeek with your own API key, or point Darang at a local Ollama / LM Studio server (or any OpenAI-compatible endpoint).

  • Ask it to write or explain SQL against your connected schema.
  • Let it build notebooks, dashboards and schema changes — each as a proposed action you approve.
  • Under AI Tools, toggle exactly which surfaces it may touch (query editor, connections, schema builder, export, and more).
  • Autonomous data look-ups are limited to a single row-capped read-only SELECT; anything that writes always waits for you.
The Darang AI assistant panel explaining query results next to a SQL editor The Darang AI assistant panel explaining query results next to a SQL editor

How your credentials are stored

Passwords, SSH keys and SSL certificates are encrypted on your machine with AES-256-GCM before they touch disk. The key that unlocks them is stored in your operating system's credential vault (macOS Keychain, Windows Credential Manager, Linux libsecret), not in a Darang file. Full details are on the security page.

Cloud sync

Cloud sync is opt-in. When enabled, your projects, documents and connection metadata sync across devices in the background. The connection secrets that sync are the already-encrypted payloads — the server can't read them. Everything keeps working offline; changes reconcile when you're back online.

Keyboard shortcuts

Open the launcher Alt + L (Cmd + L on macOS)
Launcher actions Alt + K (Cmd + K on macOS)
Run query F5
Run selected statement Ctrl / Cmd + Enter
Stop running query Ctrl / Cmd + .
Format SQL Ctrl / Cmd + Shift + F
New dashboard Ctrl / Cmd + Shift + D

The full keymap, including editor commands, is in the app's Help menu.

Ready to try it? Download Darang — it's free and takes about a minute to set up.