VeloxDB

Databases, unleashed on your desktop.

Official Website · Features · Databases · Installation · Architecture · Releases

License Release Platforms

--- **VeloxDB** is a **fast, memory-efficient, developer-focused** desktop client supporting **13 database engines**: **PostgreSQL, MySQL, SQLite, DuckDB, MongoDB, Redis, ClickHouse, LibSQL, Turso, ScyllaDB, Apache Cassandra, Microsoft SQL Server, and Azure SQL**. Connect directly to your databases — no cloud, no middleware, no telemetry. Built with performance and productivity at its core. Watch the demo: **[veloxdb.dev](https://veloxdb.dev)** --- ## Why VeloxDB? - **Multi-Engine Support** — One unified client for relational SQL (PostgreSQL, MySQL, SQLite, MSSQL, Azure SQL), analytical OLAP / data warehouses (ClickHouse, DuckDB), distributed NoSQL (Cassandra, ScyllaDB), edge & cloud SQLite (LibSQL, Turso), document stores (MongoDB), and in-memory caches (Redis). - **Fast** — Native desktop application powered by Rust and Tauri 2. Direct database connections with zero latency from cloud proxies. - **Memory-Efficient** — Virtual scrolling for massive result sets. Only loads what's visible on screen so million-row queries stay fast and responsive. - **Developer-Focused** — CodeMirror 6 with dialect-specific parsers, schema-aware autocomplete, multi-tab workspace, keyboard-first design, command palette, and visual ER modeling. --- ## Supported Databases | Engine | Type | Driver / Connection | Supported Features | |--------|------|-------------------|-------------------| | **PostgreSQL** | Relational | Native `tokio-postgres`, `deadpool-postgres` | Full SQL workspace, ER Diagrams, EXPLAIN ANALYZE, SSL/TLS, SSH Tunnel, Keychain | | **MySQL** | Relational | `sqlx` (MySQL driver) | SQL workspace, ER Diagrams, SSL/TLS, SSH Tunnel, Keychain | | **SQLite** | Embedded SQL | `sqlx` (SQLite driver) | File picker, SQL workspace, ER Diagrams, Keychain | | **DuckDB** | Analytical OLAP | `duckdb` (bundled native driver) | File picker, analytical SQL workspace, query execution, Keychain | | **ClickHouse** | Columnar Warehouse | HTTP API (`FORMAT JSON`) | Analytical queries, EXPLAIN SYNTAX, schema introspection, Keychain | | **LibSQL** | Edge SQL | Hybrid local file + `/v2/pipeline` | Local file or remote LibSQL cloud endpoint, Bearer auth, Keychain | | **Turso** | Cloud SQLite | Turso HTTP pipeline | Cloud Turso endpoints, Bearer auth token, schema explorer, Keychain | | **Microsoft SQL Server** | Enterprise Relational | `tiberius` (TDS driver) + `tokio-rustls` | T-SQL workspace, `TOP` limits, `sp_rename`, schema introspection, Keychain | | **Azure SQL** | Cloud Relational | `tiberius` (TDS driver) + TLS | Cloud Azure SQL database, T-SQL workspace, SSL/TLS require, Keychain | | **Apache Cassandra** | Distributed NoSQL | `scylla` (async CQL driver) | CQL workspace, keyspace/table explorer, query execution, Keychain | | **ScyllaDB** | Distributed NoSQL | `scylla` (async CQL driver) | Ultra-fast CQL queries, keyspace introspection, Keychain | | **MongoDB** | Document | `mongodb` (native Rust driver) | Document querying, collections explorer, SRV connection strings, SSH Tunnel, Keychain | | **Redis** | Key-Value / In-Memory | `redis` (tokio async driver) | DB index selection, command execution, Redis command completions, Keychain | --- ## Features ### Multi-Tab SQL & Query Workspace - **CodeMirror 6-Powered Editor** — Syntax highlighting and native SQL dialect parsers (`MSSQL`, `Cassandra`, `SQLite`, `StandardSQL`, `PostgreSQL`, `MySQL`), MongoDB JavaScript, and Redis CLI. - **Intelligent Schema Autocomplete** — Real-time table and column suggestions derived from database schema introspection. - **Multi-Tab Workspace** — Open multiple query tabs, each independently attached to any connected database engine. - **Real-Time Linting** — Syntax validated live against your database server as you type. - **Query History & Favorites** — Per-connection query history with full-text search, filtering, and starred snippets. - **Virtual Results Grid** — Instant rendering of large result sets via virtual scrolling, inline cell editing, row insertion, and row deletion. - **EXPLAIN ANALYZE** — Run and view query execution plans inline with visual node breakdowns. - **Export Capabilities** — Export query results to CSV, JSON, PDF, or SVG. - **SQL Formatting** — One-keystroke SQL pretty-printing powered by `sql-formatter`. ### Visual ER Diagram (Model Workspace) - **Interactive Canvas** — Introspect, design, and evolve schemas visually with ReactFlow 12. - **Auto-Layout** — Grid, topological, and Dagre-based graph layout algorithms. - **Drag-and-Drop** — Drag tables directly from the schema catalog onto the diagram canvas. - **Visual Relationships** — Connect table columns visually to define foreign key relationships. - **Inline Schema Editing** — Rename tables, alter data types, and add/drop columns directly on the diagram. - **Advanced Metadata Inspector** — Manage indexes, triggers, rules, and RLS (Row-Level Security) policies. - **Migration Preview & DDL Export** — Review generated DDL scripts before executing changes against your database. - **Export Diagrams** — Save visual diagrams as high-resolution PNG or PDF files. ### Connection Management & Security - **Multi-Engine Profiles** — Configure profiles for PostgreSQL, MySQL, SQLite, DuckDB, MongoDB, Redis, ClickHouse, LibSQL, Turso, ScyllaDB, Cassandra, Microsoft SQL Server, and Azure SQL. - **Smart Connection Strings** — First-class support for connection URIs (`postgresql://`, `mysql://`, `clickhouse://`, `turso://`, `cassandra://`, `mssql://`, etc.) with real-time engine auto-detection. - **SSH Tunneling** — Connect through bastion/jump hosts with public key or password authentication. - **SSL/TLS Modes** — Configure SSL requirements (Disable, Prefer, Require) with custom CA certificates. - **OS Keychain Integration** — Credentials stored securely in native operating system keychains (macOS Keychain, Windows Credential Manager, Linux Secret Service via `secret-service`). - **Connection Health & Auto-Reconnect** — Background pings automatically detect drops and transparently reconnect. ### Developer Experience - **Command Palette** (`Cmd+P` / `Ctrl+P`) — Search and execute any command or navigate workspace views instantly. - **Keyboard-First Design** — Configurable shortcuts for running queries, formatting SQL, toggling sidebars, and switching tabs. - **Themes & Styling** — Sleek dark and light modes with automatic OS system preference matching. - **Internationalization (i18n)** — Built-in localization support via `i18next`. - **Persistent Workspace State** — Restores open tabs, query drafts, active connections, and diagram layouts on launch. --- ## Installation ### Homebrew (macOS) Install VeloxDB with the official Homebrew tap: ```bash brew trust --tap veloxbase/veloxdb brew install --cask veloxbase/veloxdb/veloxdb ``` Or tap the repository first and install: ```bash brew tap veloxbase/veloxdb brew install --cask veloxdb ``` ### Direct Download (macOS, Windows, Linux) Download pre-built installers for the latest release (**v0.4.1**) on the **[Releases Page](https://github.com/veloxbase/veloxdb/releases)**. | Platform | Package | Download Link | |----------|---------|---------------| | **macOS** | `.dmg` / `.app` | [Download macOS Release](https://github.com/veloxbase/veloxdb/releases) | | **Linux** | `.AppImage` / `.deb` | [Download Linux Release](https://github.com/veloxbase/veloxdb/releases) | | **Windows** | `.msi` / `.exe` | [Download Windows Release](https://github.com/veloxbase/veloxdb/releases) | > **macOS Note:** If installing via DMG directly and macOS displays a Gatekeeper quarantine warning, lift the quarantine flag with: > ```bash > xattr -cr /Applications/veloxdb.app > ``` > *(The Homebrew cask removes the quarantine flag automatically during postflight).* --- ## Building From Source ### Prerequisites - **Node.js 20+** and **pnpm 10+** - **Rust 1.77+** (install via [rustup](https://rustup.rs)) - **Database instances** (local, remote, or cloud instance for testing) - **sshpass** *(optional)* — required only for SSH tunneling with password authentication (`brew install sshpass` on macOS, `apt install sshpass` on Linux) ### Quick Start ```bash # 1. Clone the repository git clone https://github.com/abeni16/veloxdb.git cd veloxdb # 2. Install dependencies pnpm install # 3. Launch full desktop application (Tauri + React + Rust) pnpm tauri # 4. Or run frontend-only preview in browser (mock/web repository) pnpm dev ``` ### Local Development Database (Docker) Spin up a local PostgreSQL test instance using Docker Compose: ```bash docker compose -f docker-compose.pg.yml up -d # Connection: host=localhost, port=15432, user=velox, password=velox, db=veloxdb ``` --- ## Architecture ``` ┌─────────────────────────────────────────────────────────────────┐ │ React 19 Frontend │ │ CodeMirror 6 · ReactFlow 12 · Zustand 5 · i18next │ │ TanStack Query v5 · Tailwind CSS v4 · Radix │ ├─────────────────────────────────────────────────────────────────┤ │ Tauri 2 IPC Bridge │ ├─────────────────────────────────────────────────────────────────┤ │ Rust Backend │ │ ┌───────────────┬─────────────┬───────────┬───────┬───────┐ │ │ │ tokio-postgres│ sqlx │ tiberius │scylla │reqwest│ │ │ │ (Postgres) │(MySQL/SQLite│(MSSQL/Az) │(Cass/ │(ClickH│ │ │ │ │ │ │Scylla)│ Turso)│ │ │ └───────────────┴─────────────┴───────────┴───────┴───────┘ │ │ duckdb · mongodb · redis-rs · SSH Tunnel · deadpool │ │ OS Keychain (keyring) · Connection Pooling │ ├─────────────────────────────────────────────────────────────────┤ │ Target Databases (Local / Cloud / SSH) │ └─────────────────────────────────────────────────────────────────┘ ``` - **Local-First Architecture** — Direct connection between the desktop client and your database. Zero telemetry, zero web proxy routing. - **Repository Pattern** — Frontend data access is abstracted behind a clean transport layer (`VeloxDbRepository`), enabling seamless operation in both native desktop (Tauri IPC) and browser preview environments. - **Extensible Engine Drivers** — Rust backend employs specialized engine modules under `src-tauri/src/engines/` (`postgres`, `mysql`, `sqlite`, `duckdb`, `mongo`, `redis`, `clickhouse`, `libsql`, `mssql`, `cassandra`) for high-performance, type-safe database communication. --- ## Tech Stack | Layer | Technologies & Libraries | |-------|--------------------------| | **UI Framework** | React 19, TypeScript, Tailwind CSS v4, shadcn/ui, Radix UI, Phosphor Icons | | **Code Editor** | CodeMirror 6 (`@uiw/react-codemirror`, `@codemirror/lang-sql`) | | **Diagram Engine** | ReactFlow 12 (`@xyflow/react`), Dagre graph layout | | **State Management** | Zustand 5, TanStack Query v5 | | **Data Grid & Virtualization** | TanStack Virtual 3, TanStack Table 8 | | **Desktop Framework** | Tauri 2 | | **Backend & Drivers** | Rust, `tokio-postgres`, `sqlx`, `tiberius`, `scylla`, `duckdb`, `mongodb`, `redis`, `reqwest`, `deadpool-postgres`, `rustls` | | **Build & Bundler** | Vite 8, pnpm 10 | | **Internationalization** | i18next, react-i18next | | **Testing** | Vitest | --- ## Star History Star History Chart --- ## 💖 Sponsors Thanks to these amazing people who support VeloxDB!

Sponsor VeloxDB

--- ## Contributing Contributions are welcome! See **[CONTRIBUTING.md](CONTRIBUTING.md)** for: - Development environment setup - Project structure walkthrough - Code style and conventions - Pull request process - How to report bugs and request features --- ## License [MIT](LICENSE) © Abenezer ---

Built with Rust and TypeScript. No cloud. No tracking. Just fast database tooling on your desktop.