Query Google Sheet data using PostgreSQL clients
Query Google Sheet data using PostgreSQL clients launched on May 31, 2022 with 122 votes, #231 of 2,942 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 4 years on.
In plain words
This tool lets users query Google Sheets data using PostgreSQL clients. Launched in May 2022, it bridges spreadsheet data with standard database querying, enabling anyone familiar with PostgreSQL to access and analyze Google Sheets without converting to traditional databases. It's useful for data analysts, developers, and spreadsheet users who need structured query capabilities on cloud-stored data.
written from the facts on this page · September 2026
From the sources
tables: - name: "table_name" uri: "https://docs.google.com/spreadsheets/d/1-lc4oij04aXzFSRMwVBLjU76s-K0-s6UPc2biOvtuuU#gid=0" option: format: "google_spreadsheet" application_secret_path: "path/to/service_account_key.json" # sheet_title is optional if `#gid` is specified in uri sheet_title: "sheet_name_within_google_spreadsheet" ROAPI only invokes Google Sheets API during the initial data load, subsequent query requests are served using in memory data. Here is what it looks like to serve this public google spreadsheet with ROAPI. $ roapi -c local.yaml [2022-05-31T01:07:55Z INFO roapi::context] loading…from roapi.github.io
Does a similar job
all alternatives →
Query Your Sheets with SheetSQL2024 · sheetsql.io · ▲128Hello HN! I've developed a tool named SheetSQL that allows you to query, join, export, and schedule your queries to Google Sheets through a straightforward SQL interface in the browser. This tool is a simple, first iteration of the idea, so I'm eager to receive feedback on it. You can contact me at taras [at] sheetsql.io :D. I'd love to find out if it could be useful for folks out there! As someone working in fintech, I constantly deal with sheets and often find it challenging to perform seemingly simple tasks like JOINs natively. However, I'm familiar with SQL, which inspired the creation…
- SASpreadsheetDB – A database that you can query with spreadsheets2017 · spreadsheetdb.io · ▲144
Stein – Use Google Sheets as a No-Setup Database2019 · steinhq.com · ▲296Use Google Sheets as your no-setup data store. Build fast and get a familiar interface for managing the data, with the open source Stein. What
Use Google Spreadsheet as a Database2017 · github.com · ▲34Sheetsu Web Client. Contribute to sheetdb/sheetsu-web-client development by creating an account on GitHub.
Turn a Google Spreadsheet into an API2015 · sheetsu.com · ▲357Use your Google Sheets as a JSON API. Connect Google Spreadsheets with your CRM or any other tool using JSON API and RESTful requests.
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 21h ago · permit.petercai.com
- IV
Life & fun · 13d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 14d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 8d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 12d ago · carrierexplode.com
Life & fun · 22d ago · space.bl2.net
Source: Show HN post ↗
Launched alongside, May 2022
the whole month →
Peerlist▲1,049A professional network w/ robust work profiles at its core
Life & fun · 2022 · peerlist.io
Switchboard▲768Hey HN this is Daniel, I'm excited to share Airtop with the community! Airtop enables AI agents to seamlessly browse and automate any website — even ones with complex authentication like MFA or OAuth. Whether you need to scrape, interact with dynamic content, or automate tasks across multiple browsers, Airtop's cloud-based infrastructure makes it scalable and accessible. Why Airtop? — AI-Driven Web Automation: Automate interactions with any site through natural language commands even if they include human-in-the-loop scenarios. — Authentication Ready: Airtop handles websites requiring…
Work · 2022 · airtop.ai
Automagically reverse-engineer REST APIs via capturing traffic - alufers/mitmproxy2swagger
Growth · 2022 · github.com
