Show HN: Query Crypto Portfolio via Google Sheets and API with SQL (Kvatch CLI)

1 squeakycheese 0 9/10/2025, 11:28:27 AM github.com ↗

Hi HN,

I recently built [Kvatch CLI](https://github.com/kvatch-hub/kvatch-cli) — a tool that lets you query data across Google Sheets, REST APIs, and databases using *just SQL*.

In this example, I use it to: - Load my crypto holdings from a public Google Sheet - Fetch live prices from the CoinGecko API - Join them together to get total portfolio value — all in SQL

No scripts, no ETL — just a YAML plan and a federated SQL query.

Blog post with demo: https://open.substack.com/pub/squeakycheese1975/p/track-your...

Would love feedback on the idea, roadmap, or real-world use cases you’d want to see. Happy to answer any questions!

Show HN: Query Crypto Portfolio via Google Sheets and API with SQL (Kvatch CLI) (github.com)

Arkade – open-source Marketplace For Developer Tools (github.com)

Effects of Proctoring on Online Intelligence Measurement (mdpi.com)

The truth about seed oils (economist.com)

Lossless Listening Arrives on Spotify Premium (newsroom.spotify.com)

LisaGUI (lisagui.com)

Show HN: Anvil-Install your tool-chain in one command and manage configs easily (github.com)

Bootstrapping vs. Venture: Lessons from My Journey (medium.com)

Android and Braille (issuetracker.google.com)

Unbound 1.23.1 and the RFC 8767 performance regression (nox.sh)

ZynorRAT technical analysis: Reverse engineering a go-based remote access trojan (sysdig.com)

Chromium browser tries to read sensitive files: –/.ssh –/.gnupg –/.dbus /boot (bugs.debian.org)

Show HN: LLM Creative Story‑Writing Benchmark V3 (github.com)

China's investments are moving nations away from fossil fuels (nytimes.com)

uv: Cargo-like Python Tool That Replaces pipx, pyenv, and more (akrisanov.com)

Decision to Extradite Kim Dotcom Ruled Legal by NZ High Court (rnz.co.nz)

TRLC-DK1: An Open Source Dev Kit for AI-Native Robotics (robot-learning.co)

Into the Sands of Time: Exploring Egypt's White and Black Deserts (nytimes.com)

A guide for your first time in South Korea (bryanhogan.com)

How to Make a Website with Obsidian (bryanhogan.com)

NASA Open Data (nasa-open-data.fibery.io)

China Energy Transition Review 2025 – Ember (ember-energy.org)

Sui fobbed off my disclosure that nearly 40% of their validators are exposed

Vale CLI (vale.sh)

iPhones 17 and the Sugar Water Trap (stratechery.com)

You are not going to turn into Google eventually (idiallo.com)

We put a superstar engineer in charge of recruiting (twitter.com)

A $1M treasure hunt is underway in Canadian wilderness (popsci.com)

Shares in Bitcoin hoarders sink as 'crypto treasury' mania sours (ft.com)

Pixel Art and the Myth of the CRT Effect (hackaday.com)

Ask HN: Preferred Automation Tools?

Ask HN: How do you build and sustain an offline tech discussion community?

Hands-On Review of the Bluefox NX1 (techeblog.com)

Need a pee? Japan has QR code for that (techxplore.com)

A19 Pro GPU is 41% faster in Metal than A18 Pro (browser.geekbench.com)

A one-day event all about what you can do in web browsers today (webdayout.com)

Euclyd – Most Power-Efficient Exascale Token Factory for Agentic AI (euclyd.ai)

Popular NPM software packages hit in supply-chain attack (arstechnica.com)

Context Pruning in Conversational Agent (poonai.xyz)

Radar footage shows Hellfire missile fired by US Military bounce off UFO (nypost.com)

Warning: Haystack Dating (old.reddit.com)

Poland says up to four of 19 Russian drones shot down after entering airspace (bbc.com)

Humans Need Not Apply (2014) [video] (youtube.com)

Apple unveils iPhone 17 Air – the thinnest iPhone ever at 5.6 mm (investopedia.com)

Windows 10 market share rises despite end of support (heise.de)

Show HN: Average House Price Map UK 2024/2025 (davkap92.github.io)

Poland Says It Shot Down Russian Drones That Entered Its Airspace (nytimes.com)

Poland shoots down drones over its territory amid Russian attack on Ukraine (theguardian.com)

Ask HN: How do you write code with or without AI?

Open Source Sub-Micron XYZ Micromanipulator (github.com)

Show HN: Query Crypto Portfolio via Google Sheets and API with SQL (Kvatch CLI)

Comments (0)