We've all been there. You need to join customer data from Postgres with sales figures in a CSV and pricing from a Google Sheet. The usual process?

Export from Postgres (15 minutes)
Download the CSV (2 minutes)
Export from Google Sheets (5 minutes)
Import everything into Excel or a Python script
Write janky join logic
Fix encoding issues
Realize you exported the wrong columns
Start over

Total time: 3 hours. Total frustration: Immeasurable.

Introducing Kvatch CLI

Today, we're excited to release Kvatch CLI v1.0.0-beta — a tool that lets you query multiple data sources as if they were a single SQL database.

# Install
brew tap kvatch-hub/tap
brew install kvatch

# Or download from GitHub releases
curl -L https://github.com/kvatch-hub/kvatch-cli/releases/latest/download/kvatch-cli_1.0.0-beta_darwin_arm64.tar.gz

How It Works

Define your data sources in a simple YAML file:

connectors:
  - name: customers_db
    type: postgres
    connection: postgres://localhost/sales

  - name: pricing
    type: csv
    connection: ./prices.csv

  - name: targets
    type: googlesheet
    connection: spreadsheet_id_here

datasets:
  - name: enriched_sales
    type: sql
    query: |
      SELECT
        c.customer_name,
        c.region,
        t.monthly_target,
        p.current_price
      FROM customers_db.customers c
      LEFT JOIN pricing p ON c.product_id = p.id
      LEFT JOIN targets t ON c.region = t.region

Then run:

kvatch query --plan sales-analysis.yaml

That's it. Kvatch handles the rest.

What Makes It Different

Free & Local-First

All processing happens on your machine. No cloud required. No data leaves your computer.

Real Federation

Not just ETL. Query across sources in real-time with standard SQL.

Plan-Based

Configuration as code. Version control your data pipelines.

Zero Dependencies

Single binary. Works on macOS, Linux, and Windows.

What's Included in Beta

Multiple connector types (Postgres, MySQL, SQLite, CSV, JSON, Google Sheets, Git repos, APIs)
SQL joins across any combination of sources
Deduplication and data transformation
Beautiful CLI output formatting
13+ working examples to get started

Why Beta?

We're calling this a beta because we want your feedback before v1.0. The core engine is solid — we've tested it extensively with real-world data. But there are polish features we're still working on:

kvatch doctor for environment diagnostics
Enhanced logging and verbosity controls
Homebrew tap automation
More connector types

Your feedback will shape v1.0.

Try It Today

Quick Start:

# Initialize workspace
kvatch init

# Run the quickstart example
kvatch query --plan examples/quickstart/plan.yaml

Resources:

What's Next

We're building toward a paid "remote mode" for teams — shared plans, scheduled queries, web UI, and collaboration features. But local mode will always be free, forever.

Get Involved

We can't wait to see what you build with Kvatch.

— The Kvatch Team

Announcing Kvatch CLI v1.0.0-beta: Query Multiple Data Sources as One