Everything You Need in One Workspace
rdSQL Desktop brings query editing, schema tools, diagnostics, backups, and object storage into a single native app — no plugins to assemble, no cloud account required.
Multi-Engine Connectivity
Multi-Engine Client
Connect directly to PostgreSQL, MySQL, MariaDB, SQLite, DuckDB, Cloudflare D1, CockroachDB, YugabyteDB, TiDB, and PlanetScale with zero driver middleware or remote proxies — plus native MongoDB and Redis connections in the same workspace.
MongoDB Document Store
Browse databases and collections in the same schema-tree Explorer as your SQL connections, run filter queries and aggregation pipelines, and edit documents with full BSON fidelity via MongoDB Extended JSON v2 (ObjectId, Date, Decimal128, and more).
Redis Key-Value Browser
Scan keys across all 16 logical databases with glob pattern and type filters, inspect TTL, memory, and encoding, and edit STRING, HASH, LIST, SET, and ZSET values inline.
DuckDB Analytics Engine
Run high-performance analytical queries on local DuckDB files with full type support — List, Struct, Map, Enum, Union, and rich numeric types, all introspected natively.
Query & Editing
Explorer & Schema Browser
Browse tree hierarchies of database schemas, views, columns, keys, triggers, constraints, indexes, and Cloudflare bindings.
Monaco SQL Editor
Write queries inside a full-featured code editor with SQL autocompletion, formatters, custom execution pools, and query logs.
Grid & Inline CRUD
Edit cells directly in fast, virtualized tables, filter results, view JSON contents, stage mutations, and commit edits atomically with Cmd+S.
AI Database Assistant
Schema-aware chat panel that writes, explains, and fixes SQL against your active connection. Bring your own key — OpenAI, Claude, Gemini, OpenRouter, or z.ai — with destructive statements always gated behind a confirmation dialog.
Chat with your database — generate, run, and explain SQL without leaving the editor.
Schema & Migrations
Migration Studio
Compare staging vs development databases, generate DDL schema diff files, and apply migration scripts safely.
Visual ERD Canvas
Map database schemas visually on an interactive graph with relationship edge-routing, search palettes, and SVG exports.
Visual ERD Studio — every table, column, and relationship laid out automatically.
Data Comparison
Schema Compare & Sync
Diff schemas and table data between databases, generate engine-specific DDL sync scripts with safety warnings, and apply changes with type-to-confirm protection on the target.
Row & Document Compare
Select two or more rows in a SQL grid — or two or more MongoDB documents — and compare them side by side in a dedicated modal. Differing fields are highlighted, with an "only show differences" toggle and one-click JSON copy.
Compare Rows — select two or more rows or documents and every differing field is highlighted, side by side.
Operations & Reliability
Diagnostics & Health
Run health scans, inspect system resource graphs, query activity logs, index sizes, and pinpoint bottleneck queries.
Database Health Score
Transparent 0–100 health score with per-category breakdown — every deduction links to its underlying diagnostic, so you always know exactly what to fix and why.
Automated Repair Center
Execute recommended auto-fixes like creating missing indexes, analyzing tables, and repairing foreign keys instantly.
Backup & Restore Studio
Export zipped dumps, compress backups, encrypt files, set custom target folders, and run restorations seamlessly.
Users & Privileges
Manage login roles and database access for PostgreSQL and MySQL/MariaDB — create and drop users, grant permissions, and inspect role assignments per host.
Encrypted Connections
Secure your data transfer using native SSL/TLS handshakes, SSH tunnels, and encrypted client-key credential storage.
Object Storage
S3 Object Storage Browser
Browse, upload (multipart), download, and manage objects across AWS S3, Cloudflare R2, MinIO, Backblaze B2, and DigitalOcean Spaces — with presigned URLs, ACLs, and in-app previews.
Storage Transfer Manager
Track uploads and downloads with real-time progress, smoothed transfer speed, ETA, cancellation, and batch operations — multipart uploads with bounded concurrency and automatic retry.
Browse, upload, and manage buckets across S3, R2, MinIO, and more — right next to your databases.