Skip to main content

Querylab.io User Guide

The complete BigQuery toolkit. Querylab.io is a powerful IDE for writing and debugging queries, analyzing data, and keeping costs under control.

Get Started​

Core Philosophy​

  1. Built for BigQuery - Designed exclusively for BigQuery, embracing its full power and unique capabilities
  2. Cost-Aware by Design - Set query limits, manage budgets, and get billing mode recommendations before you run
  3. Smart, Not Noisy - Intelligent completions and diagnostics that help when needed, stay quiet when not
  4. Privacy First - AI is opt-in, queries stay in your browser, and your data never touches our servers

Key Features​

Intelligent SQL Editing​

  • Context-aware completions that understand your schema, CTEs, and query context
  • Hierarchical navigation: project.dataset.table.column
  • Ghost completions (inline suggestions, Tab to accept)
  • Real-time diagnostics for errors, performance issues, and cost problems

Cost Optimization​

  • Pre-execution cost estimates
  • Per-CTE cost breakdown to identify expensive parts
  • On-demand vs slot-based pricing comparison
  • Development mode with TABLESAMPLE for 90-99% cost savings

Productivity​

  • Multi-tab workflow
  • Split view for side-by-side comparison
  • Query history
  • Command Palette (Cmd/Ctrl+K)
  • Prism AI for query optimization and debugging

Privacy & Security​

  • Browser-first processing - SQL parsing and completions run locally
  • Your data stays private - Queries execute directly against your BigQuery project
  • Secure authentication - Industry-standard OAuth 2.0
  • AI is opt-in - Disabled by default, requires explicit activation

More​