{"uid":"cap_Yq7jeAv8GYNWXBXufgxVr","slug":"hubvibe-bigquery-sql-query-executor-d0be6f20","name":"HubVibe BigQuery SQL Query Executor","description":"BigQuery SQL: run a read-only SQL query, including against Google's public datasets (Wikipedia, GitHub, blockchains, weather, census and more), and get columns and rows back as JSON with the bytes processed. Every query is dry-run first and refused above the scan ceiling, so cost is bounded before it runs. Input: sql; optional max_scan_gib. Ask in plain English instead: data.question.","url":"https://hubvibe-io.com/work/data/query?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"sql":{"type":"string"},"language":{"type":"string","pattern":"^[A-Za-z]{2,3}(-[A-Za-z0-9]{2,8})*$","maxLength":35},"max_scan_gib":{"type":"number"}}},"responseSchema":{"type":"json","example":{"result":{"sql":"SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5","rows":[{"n":4942431,"name":"James"}],"columns":["name","n"],"cache_hit":false,"row_count":5,"truncated":false,"total_rows":5,"gib_processed":0.012},"status":"ok","worker":"data.query","price_usd":0.5,"provenance":{"steps":[{"ms":312,"ok":true,"step":"quote","reason":"provider_timeout","provider":"coinbase-advanced-trade-public"}],"attempts":1,"elapsed_ms":340,"providers_used":["coinbase-advanced-trade-public"]},"receipt_id":"rcpt_9f1c2b3a4d5e6f70","attribution":[{"url":"https://translate.google.com","text":"Translated by Google"}],"receipt_url":"/work/receipts/rcpt_9f1c2b3a4d5e6f70"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.5","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.5/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.5","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.5","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_MMarTukRNldfW8jOEJCm1","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.5","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Executes a read-only BigQuery SQL SELECT query (including against Google public datasets) with a cost-bounding dry-run gate, returning results as JSON rows.","exampleAgentPrompt":"Run this BigQuery SQL for me: SELECT corpus, COUNT(*) as word_count FROM `bigquery-public-data.samples.shakespeare` GROUP BY corpus ORDER BY word_count DESC LIMIT 10 — keep the scan ceiling at 1 GiB so it doesn't get expensive.","exampleUseCases":[{"title":"Explore public Wikipedia traffic data","prompt":"Query the BigQuery public dataset for Wikipedia pageviews and give me the top 20 most-viewed articles from last month — write me a SQL SELECT for it and keep the scan under 2 GiB."},{"title":"Analyze GitHub commit activity","prompt":"I want to know which GitHub repositories had the most commits in 2023 using the BigQuery public GitHub dataset — run a read-only SQL query and return the top 10 repos with their commit counts."},{"title":"Ad-hoc business data lookup","prompt":"Run this SQL against our internal BigQuery table `my-project.sales.transactions`: SELECT region, SUM(revenue) as total FROM sales.transactions WHERE date >= '2024-01-01' GROUP BY region — cap the scan at 5 GiB and give me the results as JSON."}],"resultDescription":"A JSON array of rows returned by the SQL query. Each row reflects the columns selected in the query. The response is bounded by the scan ceiling enforced via a dry-run preflight check — if the query would exceed the byte limit, it is refused before execution.","failureModes":["Query exceeds max_scan_gib ceiling — refused before execution with a cost-limit error","SQL syntax errors or invalid table references return a query parse/execution error","Non-SELECT or mutating SQL (INSERT, UPDATE, DELETE) is rejected as not read-only","Table or dataset does not exist or requester lacks access — permission denied error","Network timeout if result set is extremely large","Missing required `sql` field returns a validation error"],"whenToPreferThis":"Choose this endpoint when you need to run an ad-hoc or programmatic read-only SQL query against BigQuery — especially against Google's public datasets — and want automatic cost-bounding via a dry-run gate before any bytes are scanned. Prefer it over direct BigQuery API calls when you want a simple HTTP interface that returns JSON rows without managing GCP credentials yourself.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-02T01:40:40.502Z","isFirstParty":false,"canonicalSlug":"hubvibe-bigquery-sql-query-executor-d0be6f20"}