Summary

DbPaw is a fast, cross-platform desktop database client designed for efficient SQL editing and data exploration. Targeting developers and power users, it offers an ultra-lightweight alternative to heavier tools, enhanced with optional AI assistance for query generation and explanation.

How It Works

Leveraging Tauri v2 with a Rust backend and React/TypeScript frontend, DbPaw achieves a minimal footprint (~10MB installer, ~80MB on-disk, low idle RAM). Its architecture prioritizes common workflows, presenting a streamlined, intuitive UI distinct from traditional "cockpit" designs. An optional AI sidebar integrates with external providers for tasks like drafting SQL or explaining schemas, with security measures actively being refined.

Quick Start & Requirements

Download the latest release for macOS, Windows, or Linux from the project's Releases page. macOS users may need to manually bypass Gatekeeper security warnings. No specific non-default software prerequisites are listed for core functionality.

Highlighted Details

• Extensive database support: PostgreSQL, MySQL, MariaDB, TiDB, SQLite, SQL Server, ClickHouse (preview, read-only), DuckDB, StarRocks, Doris, Oracle, IBM Db2, Redis (Standalone/Cluster/Sentinel), Elasticsearch (experimental), MongoDB (experimental), and Cassandra (experimental).
• Robust data transfer: Export data/results to CSV, JSON, or SQL (DDL/DML); import .sql files with transactional rollback; dump entire databases.
• Visual schema management: Create and alter tables via a GUI without writing DDL manually.
• Optional AI sidebar for SQL drafting, schema explanation, and query analysis.
• Ultra-lightweight footprint: Installer ≈10 MB, on-disk ≈80 MB, very low idle memory.

Maintenance & Community

The project welcomes Pull Requests. Specific community channels or core contributor details are not detailed in the provided README snippet.

Licensing & Compatibility

Licensed under the Apache License 2.0. Includes Oracle Instant Client, subject to Oracle's OTN License Agreement (free for Oracle DB connections). Compatible with commercial use under Apache 2.0 terms.

Limitations & Caveats

Support for Elasticsearch, MongoDB, and Cassandra is experimental. ClickHouse is currently read-only. AI features are in active security refinement. macOS users may encounter Gatekeeper prompts requiring manual override.