DBcooper is a cross-platform database client designed for PostgreSQL, SQLite, Redis, and ClickHouse. Built with a modern tech stack including Tauri, React, and TypeScript, it offers developers and power users a unified interface for managing diverse database systems, enhanced by AI-powered SQL generation.

How It Works

The application employs a frontend built with React, TypeScript, and Vite, leveraging shadcn/ui components for the user interface. The backend is powered by Rust and Tauri v2, enabling native application packaging. It utilizes SQLite for local storage of settings and connects to external databases like PostgreSQL. A key feature is its AI SQL generation, which uses GPT-4.1 and accesses the connected database's schema to translate natural language prompts into SQL queries in real-time.

Quick Start & Requirements

• Installation: Download the latest .dmg from the Releases page. For macOS users, bypass Gatekeeper before the first launch by running xattr -cr /Applications/DBcooper.app.
• Development Prerequisites: Bun (JavaScript runtime/package manager) and Rust are required for development.
• Development Commands: Install dependencies with bun install, then run bun run tauri dev.
• Build Command: bun run tauri build.
• Documentation: Full feature lists and FAQs are available on the documentation site.

Highlighted Details

• Supports PostgreSQL, SQLite, Redis, and ClickHouse.
• AI SQL generation powered by GPT-4.1, with schema awareness for accurate query construction.
• Built using Tauri v2, React, TypeScript, and Rust.
• Automated release process managed via GitHub Actions.

Maintenance & Community

Releases are automated through GitHub Actions upon merging PRs to the main branch. No specific community channels (like Discord or Slack) are listed in the README.

Licensing & Compatibility

The project is released under the MIT License, generally permitting commercial use and modification.

Limitations & Caveats

macOS users must manually bypass Gatekeeper security due to the application not being notarized. The build process is primarily configured for macOS ARM (Apple Silicon). AI SQL generation requires users to provide their OpenAI API key and optionally a custom endpoint.