BerryDB Documentation

BerryDB features an intuitive macOS layout with a collapsible connection sidebar, multi-tab SQL scratchpad, split-pane result grid, and interactive AI assistant sidebar.

Figure 1: Main BerryDB Workspace with Sidebar Schema Catalog, Multi-tab Query Editor, and Inline Results Grid.

Option 1: Official DMG Release (Recommended)

Download the universal binary for macOS Sonoma (14.0+) & Sequoia:

Option 2: Build From Source with Swift SPM & Makefile

The AppKit NSTableView DataGrid delivers hardware-accelerated rendering capable of streaming millions of rows without locking the main thread. Supports inline cell editing, dynamic column sorting, and instant pagination.

Figure 2: 60fps DataGrid with inline editing, sticky column headers, and execution metric indicators.

Transform plain English prompts into optimized SQL queries for PostgreSQL, MySQL, SQLite, and DuckDB. The assistant understands your schema, foreign key relationships, and data types while ensuring zero row-data leakage.

Figure 3: AI SQL Copilot Assistant side panel generating complex multi-table JOINs and query fixes.

Configure direct connections, SSL/mTLS client certificates, and SSH Jump Hosts with RSA/Ed25519 keys to access private cloud VPC databases safely.

Figure 4: Connection Profile Manager with Host, Port, Authentication, SSL/TLS, and SSH Tunnel tabs.

Inspect and alter columns, default constraints, primary keys, and B-Tree indexes visually without writing manual ALTER TABLE statements:

Figure 5: Table Schema Designer with column types, nullability, auto-increments, and foreign key relations.

Press ⌘E to inspect the execution plan tree. Spot sequential scans, missing indexes, and expensive hash joins instantly with color-coded node cost tags:

Figure 6: Visual EXPLAIN Query Plan highlighting high-cost operations, sequential scans, and actual row counts.

Explore Redis databases (DB 0-15), search keys with wildcard patterns, inspect TTL values, and modify Strings, Hashes, Lists, Sets, and JSON data directly:

Figure 7: Redis Key-Value Browser with live key filtering, TTL tracker, and data type inspector.

Fast batch imports and exports for CSV, JSON, NDJSON, and raw SQL dumps with automatic delimiter detection and transaction isolation:

Figure 8: Import / Export Wizard with format selections, header mapping, and chunked batch writes.

Review past SQL statements with precise execution duration timestamps, rows affected, and one-click query replay:

Figure 9: Query History and Execution Log with execution timing, status badges, and replay actions.

• PostgreSQL 12-16+: Citus, Timescale, CockroachDB, JSONB operators, real socket cancellation (pg_cancel_backend).
• MySQL 8.4+ & MariaDB: Full support for caching_sha2_password and mysql_native_password.
• SQLite 3: Native C libsqlite3 binding, Write-Ahead Logging (WAL), and zero setup file loading.
• Microsoft SQL Server: T-SQL execution, table alteration, and stored procedure support.
• Redis: Key-value cache, TTL management, and JSON manipulation.
• DuckDB & ClickHouse: High-speed columnar OLAP queries on Parquet / Arrow files.

Need assistance, have questions about database drivers, or want to contribute? Connect directly with the Berry Apps team: