Duckpad

DuckDB is an in-process SQL OLAP database management system for analytical workloads. It uses a PostgreSQL-inspired SQL dialect, can run from edge devices to servers, and reads and writes formats including CSV, JSON, Parquet, Iceberg, and Vortex both locally and in object storage. Extensions add functions and format support, while native clients provide APIs for Python, Go, Java, Node.js, C, C++, R, Rust, and ODBC. DuckDB is open source and MIT-licensed, with governance by the independent DuckDB Foundation.

Helix Foundry is a local-first data workspace built on HelixDB and DuckDB. It connects databases, SaaS tools, REST APIs, object storage, and uploaded files, then proposes an ontology that links matching customers and records across those sources. The workspace stores immutable, versioned Parquet snapshots, profiles schemas and reviews schema drift, and queries the snapshots through isolated DuckDB processes. Its Home and Analyst views provide metrics and answer questions with the SQL executed and citations to the relevant snapshot. AI runs locally by default through Ollama, with Claude and OpenAI also supported; AI-proposed changes require review. The application runs on the user's computer without accounts or hosted infrastructure, and provides an OpenAPI interface, TypeScript SDK, scoped API tokens, and backup and restore scripts. It is distributed under the Apache License 2.0.

Tusk is a native, keyboard-driven database client for macOS, Windows, and Linux, written in Rust with the GPUI framework. It connects to databases including PostgreSQL, MySQL, SQLite, SQL Server, Oracle, ClickHouse, Snowflake, BigQuery, Redis, MongoDB, Cassandra, and DynamoDB, and provides a virtualized GPU-rendered data grid, editable tables, schema and DDL tools, SQL editing with language-server completions, query history, exports, backups, SSH tunnels, and connection imports. Its AI assistant reads the relevant table schema, writes a SQL query into a new tab, and explains its assumptions; it does not execute SQL on its own. Tusk can connect the assistant to local agents such as Claude, Codex, or Gemini CLI through the Agent Client Protocol, while its built-in MCP server gives those agents access to an open connection. The application stores credentials in the operating system's credential store and states that it has no account requirement or telemetry. Tusk is free and open source. It is distributed through signed macOS releases and Homebrew, Windows archives, and Linux packages, with source builds available through Cargo. The repository specifies macOS 14 or later on Apple Silicon, Windows 10 or 11, and Linux on a Wayland desktop, with Xwayland supported as a fallback.

PandaCode is a free, open-source desktop workspace for running coding-agent CLIs alongside projects, Git, a terminal, and a browser in one window. It supports harnesses including Claude Code, Codex, Kimi Code, OpenCode, GitHub Copilot CLI, Cline, Kilo Code, Pi, Devin CLI, and others, with per-task harness, model, and reasoning selection. The app provides task boards, parallel agent teams, project worktrees, diffs and approvals, bot access through Telegram, Slack, Discord, WhatsApp, or a local web chat, cloud and local sandbox runs, deployment tasks, GitHub issue and pull-request workflows, and simulator integrations. It communicates with providers through their coding CLIs or documented protocols, including ACP, Pi RPC, and Muse's MSP, while storing projects, conversations, and settings locally in SQLite. PandaCode is built with Tauri 2, Rust, SQLite, and plain TypeScript, using the operating system's webview rather than bundled Chromium or an embedded editor engine. The repository states that it has no account requirement, telemetry, or analytics; provider prompts and credentials are sent only to services selected by the user. It distributes builds for macOS, Windows, and Linux and is licensed under the PandaCode License, an MIT license with an attribution requirement for public or commercial forks.

DBX is an open-source, cross-platform database client developed in the t8y2/dbx project. It provides desktop, web, Docker, and CLI distributions for connecting to more than 100 databases and related systems, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, message queues, and service registries. The desktop application uses Tauri, Vue, TypeScript, and Rust and is distributed as a small native binary without a bundled Java runtime, Python environment, or Chromium. Its query editor uses CodeMirror 6 with SQL completion, formatting, diagnostics, history, saved snippets, and file execution. Schema and data tools include object browsing, table editing, ER diagrams, schema comparison, explain plans, field lineage, imports, database transfers, exports, data comparison, and previews of Parquet, CSV, and JSON files through DuckDB. Specialized interfaces support Redis and MongoDB, while consoles cover Kafka, RocketMQ, RabbitMQ, Pulsar, MQTT, Nacos, Consul, ZooKeeper, and etcd. DBX includes an AI SQL assistant that converts natural-language requests into SQL, explains and optimizes queries, fixes errors, and checks generated SQL before execution. It supports Claude, OpenAI, local Ollama models, and OpenAI-compatible endpoints. A separately distributed Rust MCP server lets compatible coding agents such as Claude Code, Cursor, and Windsurf list connections, browse tables, execute SQL, and open tables in DBX; access can be restricted to read-only, safe-write, or high-risk-write modes. The project also provides a CLI for terminal and agent workflows, a signed and sandboxed plugin system with Go and TypeScript SDKs, encrypted credential storage, SSH tunnels, and Docker-based self-hosting. It is licensed under Apache-2.0.