Querya Desktop is a modern, open-source database management studio engineered from the ground up for speed, safety, and developer ergonomics. Built on Flutter and Dart, Querya provides a native, hardware-accelerated desktop experience across Linux, Windows, and macOS with zero JVM overhead and zero external telemetry.

Whether you are navigating multi-million row datasets, authoring complex analytical SQL, inspecting nested NoSQL documents, or managing distributed key-value caches, Querya provides a unified, cohesive, and distraction-free interface.

• $O(1)$ Viewport Rendering: Handle large datasets smoothly at 60/120+ Hz with a strictly bounded memory footprint. Only visible cells are rendered to the screen.
• Adaptive Content-Aware Column Sizing: Automatically calculates optimal column widths based on sample data rows and header lengths.
• Header Double-Click Auto-Fit: Double-click column dividers or trigger auto-fit to resize columns instantly to fit their contents.
• Background Isolate Sorting & Filtering: Multi-type column sorting with Schwartzian transforms executed in dedicated background worker isolates, keeping the UI silky smooth.
• Streaming Exporter: Stream table data directly to CSV, JSON, or executable SQL INSERT statements.

• Safe Transactional Editing: Edit cells directly in SQL Workspace and Table Browser (Postgres, MySQL, SQLite) with real-time data type validation (integers, floats, booleans, timestamps, UUIDs, and JSON). Views and tables without a primary key stay read-only.
• Atomic DML Generation: Querya tracks modifications (UPDATE, INSERT, DELETE) in a dedicated staging buffer, generating dialect-accurate SQL statements.
• Review Before Execution: Inspect generated SQL diffs with primary-key safety checks, row counts, and single-click commit or rollback.

• Isolated Query Sessions: Open multiple SQL workspace tabs simultaneously, each maintaining its own query buffers, transactions, and execution state.
• Cancellable Async Execution: Run heavy analytical queries without freezing the client, with responsive cancellation and live execution timers.
• Universal Multi-Dialect Syntax Highlighting: Real-time token highlighting for keywords, operators, strings, comments, and identifiers across all SQL dialects.
• Searchable Query History: Quickly recall, re-run, or inspect past executions with execution durations and status codes.

• Debounced Instant Object Filter: Rapidly filter schemas, tables, views, columns, indexes, and stored procedures.
• Favorites & Pinning (⭐): Pin mission-critical tables and collections to the top of your connection tree for instant access.
• Live Connection Telemetry: View server version, active connections, uptime, memory consumption, and engine statistics.

• Structured Pretty-Printers: Inspect complex cell values in dedicated preview panes with automatic formatting and syntax validation for JSON, XML, and HTML.
• Raw Hex / Binary Viewer: Inspect BLOBs, binary hashes, and raw payloads with side-by-side hex and ASCII representations.
• MongoDB Field Save: Expand a document card, inspect a field, and Save to DB ($set) without replacing the whole document.

• Command Palette (Ctrl/Cmd+P): Fuzzy-search app commands — SQL run, grid staging, connections, preferences — from one modal.
• Quick Switcher (Ctrl/Cmd+K): Jump to tables, views, collections, and other database objects in the current connection.
• Extension Commands: Installed drivers can contribute commands via contributes.commands in their manifest.

• Hardware-Backed Credential Vaults: Connection passwords and keys are never stored in plaintext. Querya integrates directly with native OS credential stores (Freedesktop Secret Service / Keyring on Linux, Apple Keychain on macOS, and Windows DPAPI Credential Manager).
• In-Memory Secret Scrubbing: Sensitive credentials are cleansed from memory after connection handshakes.
• Air-Gapped & Zero Telemetry: Absolutely zero telemetry, zero analytics, and zero external calls. Your database credentials and queries never leave your local machine.

• Pure Native Drivers: High-performance built-in drivers for PostgreSQL, MySQL/MariaDB, SQLite, Redis, and MongoDB with no external runtime dependencies or JDBC configurations.
• JSON-RPC 2.0 Driver Sandbox: Extend Querya with custom community or proprietary database drivers via sandboxed standard I/O RPC bridges.

• OS File Associations: Native file handler integration with .sql, .db, .sqlite, and .sqlite3 files. Double-click any database or SQL script in your file manager to open it immediately.
• Comprehensive Keymap: Complete keyboard navigation for executing queries, switching tabs, focusing panels, and searching objects.
• VS Code Theme Importer: Import any .json VS Code theme or choose from bundled dark/light palettes.

Download the latest .deb, .AppImage, or .tar.gz from Releases:

# Debian / Ubuntu (.deb)
sudo dpkg -i querya-desktop-linux-amd64.deb
sudo apt-get install -f

# AppImage (Standalone executable)
chmod +x querya-desktop-*.AppImage
./querya-desktop-*.AppImage

Note: Linux builds utilize libsecret-1 for OS-level credential protection. Ensure libsecret-1-0 is installed on your system.

Download the Windows installer (.exe) or portable archive (.zip) from Releases. Run the setup to automatically register .sql and .sqlite file associations.

Download the universal .dmg from Releases, mount the disk image, and drag Querya into your Applications folder.

• Flutter SDK (Version 3.24+ / Dart 3.5+)
• C/C++ compiler toolchain (GCC / Clang on Linux, MSVC on Windows, Xcode on macOS)
• Linux development libraries (Debian/Ubuntu):

  sudo apt-get update
  sudo apt-get install -y clang cmake ninja-build pkg-config libgtk-3-dev libsecret-1-dev

# 1. Clone repository
git clone https://github.com/QueryaHub/Querya-Desktop.git
cd Querya-Desktop

# 2. Fetch dependencies
flutter pub get

# 3. Run in development mode
flutter run -d linux       # or: windows / macos

# 4. Build release bundle
flutter build linux --release
# Output: build/linux/x64/release/bundle/

┌─────────────────────────────────────────────────────────────────────────┐
│                           Querya Desktop Shell                          │
│     (bitsdojo_window, Multi-Tab Workspaces, Command Palette Ctrl+P)     │
├───────────────────────────────────┬─────────────────────────────────────┤
│        UI & Presentation          │           State & Sessions          │
│ • 2D Virtual Data Grid            │ • Connection Session Pool           │
│ • Interactive In-Place Editor     │ • Isolated Query Workspaces         │
│ • Rich Cell Inspector (JSON/Hex)  │ • DML Staging Buffer & Safety Guard │
│ • Schema Tree & Quick Search      │ • Query Execution & Audit History   │
├───────────────────────────────────┴─────────────────────────────────────┤
│                          Core & Engine Adapters                         │
│ • PostgreSQL (TLS/Pooling)        │ • SQLite FFI (File & Memory)        │
│ • MySQL / MariaDB (Native Wire)   │ • MongoDB BSON Engine               │
│ • Redis (RESP Client)             │ • Extensible JSON-RPC 2.0 Driver    │
├─────────────────────────────────────────────────────────────────────────┤
│                     Platform Abstraction & Security                     │
│ • OS Hardware Vault (Secret Service / Apple Keychain / Windows DPAPI)   │
│ • Desktop File Handlers (.sql, .db, .sqlite, .sqlite3)                  │
│ • Windowing & High-DPI Scaler Engine                                    │
└─────────────────────────────────────────────────────────────────────────┘

For detailed component documentation and sequence diagrams, refer to Architecture Guide.

Querya is engineered with complete open-source transparency, strict privacy, and air-gapped security by design:

1. Native OS Credential Stores: Credentials are never written to disk in plain text or reversible base64. They are delegated to:
   • Linux: Freedesktop Secret Service API (libsecret / GNOME Keyring / KWallet).
   • macOS: Apple Keychain Services.
   • Windows: Windows Data Protection API (DPAPI) and Windows Credential Manager.
2. In-Memory Hygiene: Sensitive strings are dereferenced and purged from memory immediately following authentication handshakes.
3. Zero Telemetry & Air-Gapped Ready: Querya emits no network telemetry, analytics pings, or telemetry metrics. It can be safely deployed within isolated VPCs, financial infrastructure, and defense networks.
4. Transport Security: Full support for TLS/SSL certificates, client keys, and certificate authorities across all network-backed drivers.

See Security Architecture Documentation for further details.

Comprehensive guides and technical documentation are available in the docs/ directory:

• Getting Started — Installation, dependencies, and connecting to your first database.
• User Guide — Navigation, workspaces, query execution, and preferences.
• Architecture — Codebase structure, data flow, and module boundaries.
• Theme System & Theme Importer — Custom themes and VS Code theme parser.
• Security Overview — Local storage, encryption, and credential lifecycle.
• Roadmap — Product roadmap and upcoming releases.

We welcome contributions from the community. Please review our Contributing Guide for:

• GitFlow branch model (issue/<id>-<slug> ➔ dev ➔ main)
• Conventional Commits specification
• Automated testing and static analysis requirements (flutter analyze, flutter test)

Querya Desktop is open-source software licensed under the MIT License. Third-party components and libraries retain their respective licenses.