Quarry

Professional database manager for macOS — native, fast, and encrypted-database ready

Sunpebble cream, ink, and sun with Quarry's workbench calm: dense tables, crisp borders, and restrained accent use.

🚀 A native macOS database manager built with SwiftUI. Supports SQLite (including SQLCipher-encrypted databases), PostgreSQL, and MySQL — with schema/data comparison, diff-previewed editing, SSH tunnels, and full English/Chinese localization.

✨ Features

🗄️ Database Management

• SQLite & SQLCipher — open encrypted databases; passwords live in the macOS Keychain
• PostgreSQL & MySQL — direct connections or through an SSH tunnel
• Multiple sessions — several databases open side by side
• Connection profiles — saved connections with one-click reconnect

✏️ Data Operations

• Inline editing with pending-changes review before anything is written
• Bulk edit / delete across selected rows
• CSV / JSON import, CSV / JSON / SQL export
• Mock data generator and demo database
• Column statistics — top-value distribution for any column

📝 Query Tools

• SQL editor with query plan (EXPLAIN) view
• Query library — history and saved queries, searchable
• SQL log — every executed statement with timing
• Full-database search across all tables

🔍 Comparison

• Schema compare between any two open sessions, with migration SQL
• Data compare by primary key, with generated sync SQL (INSERT/UPDATE/DELETE)
• Schema snapshots for point-in-time comparison

🖼️ Visualization & UX

• ER diagram of tables and foreign-key relationships
• Maintenance tools — integrity check, optimize, vacuum, backup/restore
• English & Chinese localization; native menus and keyboard shortcuts

📦 Installation

Download the latest Quarry-*.zip from Releases (Apple Silicon, notarized), unzip, and drop Quarry.app into /Applications.

Build from Source

Requirements: macOS 14+, Xcode command line tools, Homebrew.

git clone https://github.com/sunpebble/quarry.git
cd quarry
brew install sqlcipher postgresql@16 mysql

swift run --package-path apps/swiftui   # development
swift test --package-path apps/swiftui  # tests

🛠️ Development

Project Structure

├── apps/
│   ├── swiftui/            # Native macOS app (SwiftPM)
│   │   ├── Sources/QuarryCore/     # Engines & pure logic (unit-tested)
│   │   ├── Sources/QuarrySwiftUI/  # SwiftUI interface
│   │   └── Tests/
│   └── video/              # Remotion promo video
├── packages/
│   ├── docs/               # VitePress documentation
│   ├── cloudflare/         # Cloudflare Workers backend
│   ├── license-api/        # Pro license API (Stripe)
│   └── tsconfig/           # Shared TypeScript configs
└── pnpm-workspace.yaml     # pnpm workspace configuration

Available Scripts

pnpm dev          # swift run (the macOS app)
pnpm build        # swift build
pnpm test         # swift test
pnpm lint         # eslint (workers & docs code)
pnpm typecheck    # cloudflare + license-api
pnpm docs:dev     # docs site

🤝 Contributing

Please read CONTRIBUTING.md for guidelines on code style, testing, commit format, and the PR process.

📄 License

This project is licensed under the MIT License — see the LICENSE file for details.

🔒 Security

Found a vulnerability? Please see our Security Policy for responsible disclosure guidelines.

---

Built with ❤️ by the Quarry team
Documentation • Issues • Discussions • Releases