Skip to main content

Querylab.io User Guide

Querylab.io is an IDE for BigQuery. Write and debug queries, analyze data, and keep costs under control.

Querylab.io Main Interface

Core Philosophy​

  1. Built for BigQuery - Designed exclusively for BigQuery.
  2. Cost-Aware by Design - Set query limits, manage budgets, and get billing mode recommendations before you run
  3. Quiet by default - Completions and diagnostics surface when relevant.
  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 - Prism AI only runs when you interact with it