[0] Welcome

Cut your BigQuery bill, not your queries.

A cost-aware SQL IDE for BigQuery: see the cost while you write, not on the invoice. Per-user budgets, test runs on a small sample for cents on the dollar, autocomplete that knows your schema. The editor is free, forever.

[1] Events export
-- the Console shows bytes; we show dollars
SELECT *
FROM `ace-analytics.warehouse.events`
WHERE event_date BETWEEN '2019-01-01' AND '2024-12-31'
[2] Signups per week
-- new accounts per week
SELECT DATE_TRUNC(signup_date, WEEK) AS week,
       COUNT(DISTINCT user_i) AS signups
FROM `ace-analytics.warehouse.users`
GROUP BY week
[3] Get started

Run this on your own data.

Connect with Google OAuth — no service-account keys to hand over, and results go from BigQuery straight to your browser. Want it fully local? The desktop app keeps tokens in your OS keychain. Just exploring? The Playground is the same IDE on public demo data: no account, no setup.

Free forever · no credit card · commercial use included. The desktop build is Apple Silicon; Windows is next.

Querylab.io

Cut your BigQuery bill, not your queries.

A cost-aware SQL IDE for BigQuery: see the cost while you write, not on the invoice. Per-user budgets, cheap test runs on a sample of your data, schema-aware autocomplete.

-- cost shown before you run
SELECT *
FROM `ace-analytics.warehouse.events`
-- 80 TB | ~$500 | dev mode $0.05 | -30% with reservations

Free forever · no credit card · commercial use included.

Cost control

BigQuery charges by the byte. We show it in dollars — as you type.

PREVIEW

See the cost while you write

Every query, estimated as you type: dollars, not bytes. The per-CTE breakdown points at the expensive part.

BUDGET

Budgets per user, not per project

BigQuery caps every user with the same quota. Querylab.io sets a limit per person: 10 TB a day for your senior analyst, 500 GB for the new hire. Over-budget queries stop before they bill.

SAMPLE

A fraction of the data, a fraction of the cost

Set a Tablesample percentage and every large table in the query gets sampled. Querylab.io prices both versions, so you see what you saved. Testing a heavy query shouldn't feel financially risky.

vs. the console

The Console manages your cloud. We write SQL.

Query cost
Bytes estimate, top-right of the editor.
✓Dollars as you type, per CTE.
Spend limits
Project-level quotas, same for every user.
✓Budgets per user, query or day.
Cost mistakes
No warning for a missing partition filter.
✓Underlined as you type, like a typo.
Cheap iteration
Add TABLESAMPLE to each table by hand.
✓Set one percentage — every table sampled, savings priced.
Debugging a CTE
Comment out the rest of the query and re-run.
✓Click the CTE — run or price just that part.
Slots vs on-demand
After the run: job stats → slot-ms × your rate.
✓Both prices compared before you run.
Autocomplete
Keywords and table names.
✓Schema- & scope-aware suggestions.
Focus
One tab of the full GCP Console.
✓Query, results, schema. ⌘K for the rest.
What you get

The features you'll use every day.

Per-CTE cost breakdown

See which part of a query burns bytes, before you run it.

Real-schema completions

Tables, columns and values from your actual data, scope-aware.

Budget limits

Cap spend per query, user or day. Expensive queries stop first.

On-demand vs reservations

Both pricing models priced on the same query — before you run it.

Prism AI

Write, fix and explain SQL with an agent that knows your warehouse.

Cost-aware MCP

Your agent queries BigQuery through the limits you set.

The desktop app runs an MCP server on your machine. Claude Code, Codex, Cursor, Gemini CLI, Claude Desktop and VS Code connect with one button each, and every call they make goes through your caps, dataset rules and approvals.

A cap and a budget

Maximum GB per query, plus a daily limit for AI tools alone. A query over either one is refused before BigQuery bills for it.

On-demand or slots, per query

The same query can cost several times more on one billing model than on the other. Auto routing prices both after the dry run and sends the query to the cheaper one.

Reads run, writes wait

A SELECT inside your limits runs without asking. INSERT, UPDATE, DELETE, MERGE and schema changes are off until you allow them, and then they still stop on a card that shows the statement and the table it changes.

The agent knows its own limits

get_limits reports the caps, today's usage and your dataset rules, so an agent plans a query it is allowed to run instead of finding out by being refused.

macOS today. Windows is next, and the server runs on your machine either way.

MCP docs ↗
Desktop app

Native on your desktop.

The same IDE without the browser — macOS, in beta.

Bring your own AI

Prism AI drives the agents already on your machine — Claude Code, Codex, Gemini CLI, Copilot, Cursor. Your subscriptions, your keys.

Existing gcloud auth

Already logged in with gcloud? The app picks it up automatically — no extra sign-in.

Credentials stay local

BigQuery credentials live in your OS keychain, never on our servers.

Native hotkeys

No browser shortcuts getting in the way. No tab to lose.

Download for macOS

Apple SiliconWindows next, Linux after that Use the web app instead

Free forever

The editor is free. Forever.

No credit card, no trial timer. Commercial use included.

  • The full SQL editor
  • Unlimited queries
  • Cost preview & per-CTE breakdown
  • Schema-aware completions
  • Budget limits & reservation hints
  • Prism AI
Get started

Best on the big screen.

Querylab.io is a full SQL IDE, and it shines on a laptop. Send yourself the link and open it when you're back at your desk.

Just the link, straight to your inbox. Updates stay off unless you tick the box.

or jump straight in