SettingsReference

Settings

Every setting in the app, in the order the Settings tab shows them, with its default and where to read more. Settings are saved when you click Save, not as you change them.

GeneralCustomize the app's appearance and behavior.

⌃

Theme

System preference

Light

Dark

Language Auto-detect from browser (English)

Choose your preferred interface language

Tab Behavior

Prompt for tab nameShow a dialog to name new tabs when created

Sidebar

Show data browser treeDisplay the hierarchical tree of projects, datasets, and tables in the left sidebar. When disabled, use Cmd+K to search for tables.

The Settings tab: search across every setting, categories on the left, Close and Save at the top right.

Open Settings from the gear icon in the header (also in the account menu), or ⌘K → Open settings. Some feature pages deep-link to their section. The search box at the top filters every category at once. After General, Workspace, Notifications and Privacy, the categories sit under three headings: Queries (BigQuery, Limits & Costs, Data & Results), SQL (Editor, SQL Frameworks, Code Quality) and AI (Prism AI). The desktop app adds Local BigQuery API under Queries and MCP under AI.

General

Language offers English, Japanese, German, Korean, French, Spanish and Brazilian Portuguese. Prompt for tab name is covered in Tabs; Show data browser tree in Navigating resources.

Workspace

One control. Enable Spaces (default On) groups tabs into Spaces with their own default connection and theme. See Tabs.

Notifications

Long queries (off, 10 seconds), Prism AI answers (on) and, on desktop, MCP approvals (on) show a system notification while Querylab.io is in the background. See Notifications.

Privacy

Privacy & Data StorageControl where your tabs and queries are stored

⌃

Store tabs on backend (encrypted)When enabled, your SQL queries and tab names are encrypted and stored on our backend. Your tabs will be preserved across sessions and devices. Your query results remain in your browser only.

Help improve Querylab.ioSend usage data to help us improve the app. We never collect your SQL queries, query results, or BigQuery data.

Store tabs on backend is off by default, so tabs live in this browser only. Help improve Querylab.io is on by default and always on in the playground; on the desktop app with local credentials it is a local opt-in, default off.

Three more sections appear when signed in on the web: Active Sessions (every device, with Sign out per session and Sign out of all other sessions), Google Credentials (Revoke server credentials, and on desktop Clear local credentials; see Local credentials), and Delete Account.

BigQuery

BigQuery ConnectionManage projects and billing settings

⌃

Projects

✓ ace-analyticsSchema Tree · Billing

✓ bigquery-public-dataSchema Tree

Missing a project? Project ID

Add Project

Default Billing Project ace-analytics

Can be overridden per query in the editor settings.

Setting	Default	What it does
Projects	All discovered	Per project: show in the schema tree, allow as billing project. Grant Access to Projects List appears if the app lacks the projects-list scope; see Connecting to BigQuery
Missing a project?		Project ID field and Add Project button, for projects the listing doesn’t return
Default routing	Use from project	Reservations section: Use from project, Auto, On-demand or Default reservation for new tabs; see Auto routing
Default Reservation	Use from project	The reservation new tabs and Auto routing use; see Pricing comparison

Limits & Costs

BigQuery LimitsSet single query limits and daily/weekly/monthly budget limits

⌃

Single Query Limit

Max GB billed 100 GB

Default for new tabs (does not affect existing tabs)

Budget Limits

Daily budget GB Org limit: Not Set

Leave empty for no daily limit. Cannot exceed organization limit if set.

0.00 GB / —0.0%

Budgets and limits apply only to queries run through Querylab.io

Cost DisplayCurrency and price comparison settings

⌃

Currency for displaying query costs and estimations $ USD (US Dollar)

BigQuery edition for On-Demand vs Reservation price comparisons Enterprise

Setting	Default	What it does
Max GB billed	100	Per-query limit for new tabs; see Cost limits
Daily / Weekly / Monthly budget	Empty (no limit)	GB caps per period; usage bars underneath; org limits shown as a tag
Currency	USD	USD, EUR or JPY in every cost display
Comparison edition	Enterprise	Disabled, Standard, Enterprise, Enterprise Plus; see Pricing comparison
Default LIMIT	Suggest it, 1000 rows	When a `LIMIT` would reduce the scan; see LIMIT hints

Data & Results

One control. Group nested columns (default Off) shows STRUCT columns as a tree in the grid. See Results grid.

Local BigQuery API

Desktop only. Serve the Local BigQuery API (default Off) lets bq, the Python client and other BigQuery tools on this computer run SQL on the Querylab.io Local engine. Port is 9060 unless you change it, and Connect a client has a bq command and a Python example for your port. See Local BigQuery API.

Editor

SQL EditorCustomize the SQL editor's behavior, appearance, and inline hints.

⌃

Completions

Automatic (show as you type)

Manual (Ctrl+Space only)

Chain completionsAutomatically show next completions after accepting keywords or tables (e.g., FROM → show tables, users → show columns)

Enable ghost completionsShow inline suggestions that you can accept with Tab

Enable INFORMATION_SCHEMA completionsShow INFORMATION_SCHEMA prefix and tables in completions (e.g., dataset.INFORMATION_SCHEMA.TABLES)

Enable Graph Schema CompletionsExperimental · Fetch property graph metadata from INFORMATION_SCHEMA for schema-aware GQL completions. Completions work without a reservation. Running a graph query needs an Enterprise or Enterprise Plus reservation.

Enable BigFunctionsShow community BigQuery UDFs (150+ functions) in completions

Completion style Smart (context-aware)

How keywords and functions are filtered in autocomplete suggestions

Smart Typing

Auto-close brackets (), [], {} Language defined (default)

Auto-close quotes '', "", `` Language defined (default)

Auto-surround selection Language defined (default)

Appearance

Font size 14px (default)

Tab size 2 spaces

Use spaces

Word wrap Off

Off: horizontal scrolling. On: wraps at window width. Bounded: wraps at 120 columns regardless of window size

Show minimapDisplay code overview on the right side of the editor

Inlay Hints

Show parameter namesDisplay parameter names inline for function calls (e.g., x: value, y: value)

Show return typesDisplay return types inline for expressions (e.g., : STRING)

Show variable typesDisplay inferred types for columns and variables (e.g., : INT64)

SQL Editor

Completions are explained in Auto completions, Ghost completions and Graph queries; inlay hints in Code navigation.

Setting	Default	Options
Auto-completion	Automatic	Manual = `CtrlSpace` only; a dot always triggers
Completion style	Smart (context-aware)	Permissive shows every keyword and function and lets you filter
Auto-close brackets / quotes	Language defined	Always, Language defined, Before whitespace only, Never
Auto-surround selection	Language defined	Language defined, Quotes only, Brackets only, Never
Font size	14px	12–18px
Word wrap	Off	On, or Bounded at 120 columns

SQL Formatting

Applied by ⇧⌘F. Each option is explained with examples in SQL formatting.

Setting	Default	Options
Formatting Mode	Pretty	Preserve, Pretty, Compact
Keyword Case	UPPER	UPPER, lower, preserve
Indent Size · style	2 · Spaces	2, 4, 8; Spaces or Tabs toggle
Newline After Clause	On	Each major clause (SELECT, FROM, WHERE) starts on its own line
Max Line Length	80	80, 100, 120
Trailing Comma	Off	Comma after the last item in lists
Quote Identifiers	Preserve	Preserve, Always, Never
AS Keyword	Preserve	Preserve, Always, Never
Pipe Operator Style	Standard	Standard, Left-Aligned; see Pipe syntax
Format on Type	Off	Format as you type, e.g. after `Enter`

SQL Frameworks

SQL FrameworksTemplate language support for dbt and Dataform

⌃

dbt

Enable dbt ModeAuto-detect Jinja patterns and enable dbt completions, diagnostics, and compiled view

Inlay HintsShow resolved values inline after Jinja expressions (e.g., ref, source, var)

Dataform

Enable Dataform ModeAuto-detect SQLX patterns and enable Dataform completions, diagnostics, and compiled view

Inlay HintsShow resolved values inline after SQLX expressions (e.g., ref, resolve, self)

ggsql visualization (experimental)

Enable VISUALIZE / DRAW clausesRender inline charts from ggsql syntax. Strips the clauses before sending SQL to BigQuery.

Match chart theme to app theme

Setting	Default	Read more
Enable dbt Mode · Inlay Hints	On · On	dbt support
Enable Dataform Mode · Inlay Hints	On · On	Dataform support
Enable VISUALIZE / DRAW clauses	Off (on in the playground)	Charts
Match chart theme to app theme	On	Turn off for light charts in exports

Code Quality

Two sections. Cost Optimization holds the thresholds. Diagnostic Rules lists every rule by category (Performance, Code Quality, Correctness, Semantic, Parser) with Enable All / Disable All per category and a badge counting disabled rules. Rules your organization pins show an Org policy lock. Rule descriptions are in Code quality.

Cost OptimizationControl warnings for expensive query patterns and missing filters

⌃

Query Pattern Warnings

Warn about SELECT * on tables larger than 1 GB

Warn about missing LIMIT on tables larger than 1 GB

Warn about scanning tables larger than 100 GB

Partition & Clustering

Warn about missing partition filtersAlert when querying partitioned tables without filtering the partition column (critical for BigQuery cost optimization).

Warn about missing cluster filtersAlert when querying clustered tables without filtering cluster columns (improves query performance).

Setting	Default	Options
SELECT * on tables larger than	1 GB	100 MB, 1 GB, 10 GB, Never warn
Missing LIMIT on tables larger than	1 GB	100 MB, 1 GB, 10 GB, Never warn
Scanning tables larger than	100 GB	10 GB, 100 GB, 1 TB, Never warn

Prism AI

Prism AIConfigure your AI assistant provider and settings

⌃

Enable Prism AI FeaturesMaster switch for all AI-powered features including AI tab renaming, AI chat, and context menu actions

AI Ghost CompletionsUse AI to suggest SQL completions (requires Ghost Completions in Editor Behavior and Prism AI enabled)

Auto-rename tabs after executionUse AI to generate descriptive tab names after the first successful query execution

Share Query Results Preview Ask each time

Controls whether sample data from query results can be shared with AI for analysis

AI Providers

Querylab.io CloudIncluded in your Querylab.io plan

9 / 100 monthly credits9.0%

Claude CodeNot authenticated · Install

Gemini CLINot authenticated · Install

The features behind the master switch are described in Prism AI.

Setting	Default	Options
Share Query Results Preview	Ask each time	Disabled (never share), Ask each time, Always allow
Claude Code, OpenAI Codex, Gemini CLI, GitHub Copilot CLI, Cursor CLI	Off	Desktop only: run through a CLI you already pay for, with a Workspace Folder each; see CLI integration
Use my own API key for Prism AI	Off	Desktop only: Anthropic, OpenAI or Google key kept in the macOS Keychain

MCP

Desktop only. Three sections control what connected AI tools can do through the Local MCP server:

Section	What it holds
Connection	AI tools can connect (default On), whether the server is running, and Start Querylab.io when an AI tool uses it
Connected tools	Adds Querylab.io to Claude Code, Codex, Cursor and the other AI tools on this computer
Access limits	Billing project, Maximum GB per query, Routing, Daily limit for AI tools, row limits, Write access, Write approval and Dataset rules; see Limits and access