SettingsReference
Settings
Every setting in the app, in the order the Settings tab shows them — what each control is called, 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.
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; below 600px the sidebar becomes a row of chips.
General
| Setting | Default | What it does |
|---|---|---|
| Theme | System preference | Light, Dark, or follow the OS |
| Language | Auto-detect from browser | English, Japanese, German, Korean, French, Spanish, Brazilian Portuguese |
| Prompt for tab name | Off | Ask for a name when a tab is created — see Tabs |
| Show data browser tree | On | Hide the schema tree and rely on ⌘K search — see Navigating resources |
Subscription shows your plan, status and valid-until date, with Upgrade to Teams, Subscribe Now, Manage Subscription or Extend Trial (30 days) depending on where you are. Web sign-in only.
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 cloud-platform scope — see Connecting to BigQuery |
| Missing a project? | — | Project ID field and Add Project button, for projects the listing API doesn’t return |
| Default Billing Project | First billing-enabled project | Where new tabs run; the status bar overrides per tab |
| Default Reservation | Use from project | Reservations section: pick a slot reservation for new tabs — 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. Teams plan |
| Currency | USD | USD, EUR or JPY in every cost display |
| Comparison edition | Enterprise | Disabled, Standard, Enterprise, Enterprise Plus — see Pricing comparison |
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. Requires BigQuery Enterprise edition.
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
| Setting | Default | What it does |
|---|---|---|
| Auto-completion | Automatic | Manual = CtrlSpace only; a dot always triggers — see Auto completions |
| Chain completions | Off | Reopen the list after accepting a keyword or table |
| Enable ghost completions | On | Ghost completions |
| Enable INFORMATION_SCHEMA completions | On | Offer INFORMATION_SCHEMA views after a dataset |
| Enable Graph Schema Completions | Off | Experimental — Graph queries |
| Enable BigFunctions | Off | Community UDFs from the BigFunctions project in the list |
| 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 |
| Tab size · Use spaces | 2 · On | |
| Word wrap | Off | On, or Bounded at 120 columns |
| Show minimap | On | |
| Show parameter names · return types · variable types | On · On · Off | Inlay hints — see Code navigation |
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 | |
| Max Line Length | 80 | 80, 100, 120 |
| Trailing Comma | Off | |
| 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 |
| Missing partition / cluster filters | On · On | |
| Diagnostic rules | All enabled | Per-rule toggles |
Data & Results
One control. Group nested columns (default Off) shows STRUCT columns as a tree in the grid — see Results grid.
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.
| Setting | Default | What it does |
|---|---|---|
| Store tabs on backend (encrypted) | Off | Off = tabs live in this browser only |
| Help improve Querylab.io | On | Product analytics; always on in the playground. On the desktop app with local credentials this 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.
AI Features
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
| Setting | Default | What it does |
|---|---|---|
| Enable Prism AI Features | On | Master switch — Prism AI |
| AI Ghost Completions | Off | Model-generated inline suggestions; needs ghost completions on |
| Auto-rename tabs after execution | Off | Names the tab after its first successful run |
| Share Query Results Preview | Ask each time | Disabled (never share), Ask each time, Always allow |
| Querylab.io Cloud | On | Managed provider; the meter shows monthly credits |
| 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 OS keychain |
Workspace
One control. Enable Spaces (default On) groups tabs into Spaces with their own default connection and theme — see Tabs.