SQLSigma

Settings

Customize your workspace

ESC to close

Account

Workspace

Data

SQLSigma v1.0.0

Profile

Manage your account credentials

—

— 0%

Authenticated through Google Cloud

Linked

Your account is linked to Google Cloud Platform. Email and password are managed through your Google account.

Signed in as:

Email Address

Current Email

New Email

Password to confirm

Password

Current Password

New Password

Confirm Password

Security

Manage your account security and active sessions

Current Session

Your active login session

This device Current

Active now

Two-Factor Authentication

Add an extra layer of security to your account

Disabled

Protect your account by requiring a verification code sent to your phone number when signing in.

Two-factor authentication is enabled

Your account is protected with SMS verification

Enter your password to continue setting up two-factor authentication.

Password

Enter your phone number to receive verification codes via SMS.

Phone Number

Select your country and enter phone number without leading zero

Enter the 6-digit code sent to your phone.

Enter your password to disable two-factor authentication.

Password

Enter the 6-digit code sent to your phone to confirm disabling 2FA.

Session Management

Control your login sessions across all devices

Danger Zone

Permanently delete your account and all associated data. This action cannot be undone.

Appearance

Customize how SQLSigma looks and feels

Theme

Choose your preferred color scheme

Accent Color

Personalize your interface with a signature color

Editor

Configure the SQL code editor behavior and appearance

preview.sql

-- Get top users by order count
SELECT
user_id,
email,
COUNT(*) AS total_orders
FROM users
JOIN orders ON users.id = orders.user_id
WHERE created_at > '2024-01-01'
GROUP BY user_id, email
HAVING COUNT(*) > 10
ORDER BY total_orders DESC;

Font

Font Size

Size of text in the editor

14px

Font Family

Monospace font for code

Behavior

Tab Size

Number of spaces per tab

Word Wrap

Wrap long lines to fit the viewport

Auto-close Brackets

Automatically insert closing brackets

Format on Save

Automatically format SQL when saving

Display

Line Numbers

Show line numbers in the gutter

Minimap

Show code overview on the right side

Bracket Pair Colorization

Color matching brackets for easier reading

Highlight Active Line

Highlight the line containing the cursor

Scroll Beyond Last Line

Allow scrolling past the last line

SQL Highlighting

Customize how SQL syntax is colored in the editor

Keywords

SELECT, FROM, WHERE

Functions

COUNT, SUM, AVG

Strings

'text values'

Numbers

123, 45.67

Comments

-- comments

Operators

=, >, <, AND

Tables

Table & column names

Rules

Enable or disable individual SQL optimization rules for analysis

0 of 0 enabled

Toggle rules to customize analysis

Schema Source

Choose how to load BigQuery table schemas for SQL analysis

Schema Mode

Google Cloud Connection

Connected

Schemas sync automatically from BigQuery

Loaded Schemas

No schemas loaded yet. Select a project in the explorer.

JSON Schema Import

Imported Schemas

No schemas imported

View expected JSON format

{
  "schemas": [
    {
      "projectId": "my-project",
      "datasetId": "my_dataset",
      "tableId": "users",
      "columns": [
        { "name": "id", "type": "INT64", "description": "Primary key" },
        { "name": "email", "type": "STRING", "description": "User email" },
        { "name": "created_at", "type": "TIMESTAMP" }
      ]
    }
  ]
}

Supported types: STRING, INT64, FLOAT64, BOOL, TIMESTAMP, DATE, DATETIME, TIME, BYTES, NUMERIC, BIGNUMERIC, GEOGRAPHY, ARRAY, STRUCT, JSON

Schema mode affects analysis & autocomplete

Loaded schemas are used for SQL optimization rules (sqlglot) and editor autocomplete. Without schemas, some optimizations may not be detected.

Permissions

What you can do on each Google Cloud project — derived from your live BigQuery IAM permissions.

Static SQL analysis works on every project — these capabilities only apply to features that hit BigQuery.

No permissions probed yet. Click Re-check permissions to scan your accessible projects. We test project-level IAM, then fall back to a small sample of dataset-level checks to catch dataset-scoped grants.

Project	Status	Browse	Estimate	Actual run	Jobs

What each capability needs

Browse — list datasets and tables in the explorer. Needs bigquery.tables.list.
Cost estimate — dry-run a query to see bytes processed before paying. Needs bigquery.jobs.create.
True optimization — execute the original and optimized query for real wall-time / slot-ms / bytes-billed metrics. Needs bigquery.jobs.create + bigquery.tables.getData.
Job history — show recent BigQuery jobs in the explorer. Needs bigquery.jobs.list.

How we probe. jobs.* are project-scoped and probed at the project. tables.* are dataset-scoped — when a project-level probe doesn't show them granted, we fall back to per-dataset testIamPermissions on a sample of your accessible datasets and union the results. If you only have access to specific datasets that weren't sampled, the matrix may understate your access.

Data & Privacy

Manage your data, privacy settings, and export options

Data Usage

Local Storage Used Calculating...

Query history, settings, cached data of 5 MB limit

Query History

0 queries in history

Clear All Local Data

This will remove all locally stored data including settings, query history, and cached data. This action cannot be undone.

Free Trial Active

Cancellation scheduled. Your subscription will end on --. You'll keep full access until then; after that you'll drop back to the Free tier.

Period -- – --

Resets --

0 / 10 optimizations

Optimizations this period

No limit

Choose a subscription

Pick the plan that fits your team. Upgrades credit your remaining balance toward the new plan.

Upgrade credit applied. You'll see your existing purchase deducted at checkout.

Secure payment via Stripe Credits expire by tier

Add Optimizations

Top up your balance at your tier's per-optimization rate. Charged immediately to your saved card.

Quantity

Rate $1.00 / optimization

Total $50.00

Loading team info...

Teams

Upgrade to a Pro or Unlimited plan to create a team
and track aggregated cost savings across members.

Create a Team

Collaborate with your team and track aggregated cost savings.

Error

Team

0 members

Invite Member

Error

Invite sent!

Members

Pending Invites

Don't show this again

Optimization Limit Reached

You've used all your optimizations.

Explorer

No jobs available

Last refreshed: --

Optimizations 0/10

Editor

Ready

-- saved

Analysis 0

No issues detected

History

Delete Session

Are you sure you want to delete this session? This cannot be undone.

Rename Session

Timeline

Tab Name · Active

0 versions · 0 B saved

Optimization History 0

No optimizations

Run "Apply All" to create

Current Saved

No saved query

Click "Save Tab" to save

Cost Savings

BigQuery on-demand pricing: $6.25/TB

Est. Cost Saved

Optimize queries to see savings

Bytes Processed

Avg. Reduction

Queries Optimized

No optimization data yet

Analyze a query and click "Apply All" to start tracking savings.
Connect a GCP project for automatic dry-run byte estimates.

Team Savings

Aggregated cost savings across your team

AI Assistant

Ask me to write SQL, explain queries, or help optimize your BigQuery usage.

Notifications 0

All caught up