Kvatch is a federated SQL engine that lets you query APIs, CSVs, Google Sheets, and databases as one source [1]. It's open-source, written in Go, and still early—the author is seeking feedback on data sources and features [1].
What Kvatch brings to SQL tooling
- A single SQL surface across REST APIs, CSV files, Google Sheets, and databases like Postgres / SQLite lets you join live data as if it lived in one place, across cross-source fields [1].
Use cases include joining GitHub issues with commits from a repo and building dashboards that mix API, CSV, and DB data, all through plain SQL [1].
Docs and examples live in the kvatch-cli repository on GitHub, making it easy to try samples and tweak queries [1].
- Kvatch is open-source and can be explored via the website kvatch.com and blog kvatch.com/blog, with a growing community around its CLI and docs [1].
Why this matters for data tooling
In practice, Kvatch shows how SQL tooling can incorporate live API data without leaving the familiar query interface [1]. It sits among Show HN projects that push federation ideas into real-world workflows [1].
Closing thought: keep an eye on Kvatch as it matures and expands its SQL surface.
References
Show HN: Kvatch – query APIs, CSVs, Google Sheets, and databases as one source
Federates APIs, files, and databases into one SQL queryable source with examples and open-source tooling, and feedback from developers worldwide.
View source