🚀 Kvatch CLI

The Problem

Ever spent hours exporting data from Postgres, downloading a CSV from Google Sheets, converting JSON from an API, just to join them in Excel? That's the pain Kvatch eliminates.

Introducing

Kvatch CLI lets you query multiple data sources — databases, files, and APIs — as if they were a single SQL database.
Run it locally for free, or sign up for early access to the upcoming remote mode for team collaboration and orchestration.

---

Example: Join CSV and JSON data

kvatch query --plan examples/quickstart/plan.yaml

✨ Features

• 🔄 Query anything with SQL — CSV, JSON, SQLite, Postgres, APIs, and more
• 🧱 Plan-based architecture — Define everything in a single YAML or JSON file
• 💻 Local mode (Free) — All processing happens locally, no cloud required
• 🌐 Remote mode (Coming Soon) — Share, schedule, and orchestrate data jobs with your team
• ⚙️ Simple CLI — One binary, zero external dependencies

---

📦 Installation

Option 1: Install via Homebrew (Recommended)

brew tap kvatch-hub/tap
brew install kvatch

Verify installation:

kvatch --version

⚠️ If kvatch isn’t found:

Ensure Homebrew’s bin directory is on your PATH.

Apple Silicon (M1/M2/M3) Macs:

echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> ~/.zprofile
eval "$(/opt/homebrew/bin/brew shellenv)"

Intel Macs / Linuxbrew:

echo 'eval "$(/usr/local/bin/brew shellenv)"' >> ~/.zprofile
eval "$(/usr/local/bin/brew shellenv)"

---

Option 2: Download the Latest Release Manually

Grab the latest binary from the Releases page.

---

macOS First Run (Unsigned Binary)

macOS may block unsigned binaries. To fix:

xattr -d com.apple.quarantine kvatch
./kvatch --help

Or manually:

1. Run the binary (you’ll see a warning)
2. Open System Settings → Privacy & Security
3. Click Allow Anyway
4. Re-run ./kvatch

---

Verify Installation

kvatch help

(Optional) Add to your PATH:

sudo mv kvatch /usr/local/bin/

Then test shell completion:

kvatch completion [bash|zsh|fish|powershell]

---

🔧 Initialize Workspace

# Sets up local workspace at ~/.kvatch
kvatch init

---

🧪 Try It Out

Start with a built-in example — see the examples directory for ready-to-run plans:

• CSV / JSON ingestion
• SQLite and Postgres queries
• Deduplication and joins across sources
• Advanced federation scenarios

---

🧩 How It Works

Kvatch uses a single plan.yaml or plan.json file to:

• Define data sources (CSV, SQLite, Postgres, etc.)
• Configure datasets with SQL queries and plugins
• Enable joins, deduplication, and storage options

---

🧠 Learn More

• 📄 Plan file format (coming soon)
• 📚 Documentation
• 🧪 Examples

---

💡 Licensing

Kvatch CLI is:

• ✅ Free for personal and commercial use in local mode
• 🔐 Paid for advanced remote mode features

Local Mode (Free)

• Runs entirely on your machine
• No internet connection required
• Unlimited connectors, datasets, and joins
• Ideal for analysts, engineers, and builders

Remote Mode (Paid, Coming Soon)

• Team-wide shared plans and storage
• Scheduled runs and background jobs
• Web UI, access control, audit logs

📝 Join the waitlist for early access.