Show HN: KvatchCLI – Query Multiple Data Sources with SQL(Postgres,CSV,APIs)

3 points

4 months ago

Hi HN! I'm launching Kvatch CLI v1.0.0-beta today — a tool that lets you query multiple data sources (Postgres, CSV, Google Sheets, APIs, etc.) as if they were a single SQL database.

Demo: https://github.com/kvatch-hub/kvatch-cli Download: https://github.com/kvatch-hub/kvatch-cli/releases/tag/v1.0.0...

## Why I Built This

As a data engineer, I got tired of the "export-download-import-wrangle" dance every time I needed to join data from different sources. The usual workflow:

1. Export from Postgres 2. Download CSV from somewhere 3. Grab data from Google Sheets 4. Spend 3 hours in Python/Excel joining everything 5. Fix encoding issues 6. Realize you exported wrong columns 7. Repeat

It's 2026. This shouldn't be so hard.

## What It Does

Define data sources in YAML and query across them with standard SQL:

```yaml connectors: - name: prod_db type: postgres connection: postgres://localhost/production

  - name: sales_data
    type: csv
    connection: ./sales.csv

datasets: - name: analysis query: | SELECT u.name, s.revenue FROM prod_db.users u LEFT JOIN sales_data s ON u.id = s.user_id ```

Run: `kvatch query --plan analysis.yaml`

Kvatch executes the query across sources and returns results — no exports, no intermediate files.

## Technical Approach

- Written in Go (single binary, ~12MB) - Uses SQL federation (not ETL — queries sources directly) - Local SQLite for caching/intermediate results - Pluggable connector architecture - Supports Postgres, MySQL, SQLite, CSV, JSON, Google Sheets, Git repos, REST APIs

Everything runs locally. Your data never leaves your machine.

## Current Status

Core engine is production-ready (tested with real datasets), but calling it "beta" because I want feedback before v1.0. Some UX polish still needed (diagnostics commands, better logging, etc.).

Supported platforms: macOS (Intel + Apple Silicon), Linux (x86_64 + ARM64), Windows.

## What's Next

Building a paid "remote mode" for teams: shared plans, scheduled queries, web UI, access control. Local mode will stay free forever.

## Try It

```bash brew tap kvatch-hub/tap brew install kvatch

# Or download: https://github.com/kvatch-hub/kvatch-cli/releases

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

Examples: https://github.com/kvatch-hub/kvatch-cli/tree/main/examples

Happy to answer questions! Feedback very welcome.