WELCOME TO YOUR FIRST DAY AT WORK

Welcome to SQL Office Simulator

You are no longer solving abstract multiple-choice quizzes or artificial toy problems. Inside the SQL Office Simulator, you step into the role of a data analyst working for real organizations. Your coworkers and executives message you with realistic analytical questions—you query actual PostgreSQL schemas in Monaco editor and report your answers.

Account Requirement: An account (100% free) is required to access the interactive PostgreSQL database sandboxes, save your completed SQL queries, and track your career progression through the 5 levels.
Orientation Flow

How the Simulator Works

1

Sign Up & Honor Code

Create your learner profile in 30 seconds. Accept our human-first honor pledge to build genuine problem-solving skills without AI copy-pasting.

2

Choose Your Domain

Pick from 7 simulated companies including E-Commerce, Healthcare, Banking, SaaS, and Logistics. Every domain features isolated relational schemas.

3

Query Live Database

Read stakeholder tickets in your company inbox. Inspect real database tables and write queries in a Monaco SQL editor with autocomplete and schema docs.

4

Dual-Dataset Anti-Cheat

Your submitted queries are tested against both visible and hidden validation datasets to guarantee robust logic, earning XP and unlocking higher levels.

Work Environments

The 7 Simulated Organizations

Each organization features custom PostgreSQL tables matching real industry architectures.

E-Commerce

500 Qs
OmniCart Retail Group
Role: E-Commerce Growth Analyst

Customer cohort analysis, repeat buyers, basket sizes, warehouse fulfillment, regional returns

Tables

customers, orders, order_items, products, shipments, returns

Healthcare

500 Qs
St. Jude Clinical Network
Role: Clinical Informatics Analyst

Treatment protocols, ER wait times, physician load, prescription alerts, insurance claims

Tables

patients, appointments, doctors, diagnoses, prescriptions, billing

Finance & Banking

500 Qs
Apex Capital Bank
Role: Risk & Fraud Data Analyst

Debit card fraud surges, high-frequency transactions, loan defaults, AML compliance

Tables

accounts, customers, transactions, loans, cards, fraud_alerts

Human Resources

500 Qs
Vanguard Global HR
Role: People Analytics Specialist

Attrition cohorts, compensation parity, departmental tenure, promotion velocity

Tables

employees, departments, salaries, attendance, performance_reviews

Logistics & Supply

500 Qs
Atlas Freight Solutions
Role: Supply Chain Analytics Engineer

Carrier route delays, container dwell time, dock utilization, delivery bottlenecks

Tables

shipments, vehicles, drivers, routes, warehouses, delivery_events

Restaurants & Hospitality

500 Qs
Palate Group Dining
Role: Hospitality Operations Analyst

Table turnaround times, peak-hour kitchen throughput, food waste variance, server gratuity

Tables

restaurants, menu_items, orders, staff, shifts, reservations

Software (B2B SaaS)

500 Qs
CloudScale Platform
Role: SaaS Product Analyst

ARR expansion, churn cohorts, seat utilization, feature drop-off, renewal health

Tables

users, accounts, subscriptions, feature_usage, incidents, invoices

Career Trajectory

5 Career Levels: From Seed Startup to Global Giant

Every level increases schema complexity, table volume, and the seniority of your analytical answers.

L1100 Qs

The Startup

Solo Data Generalist
5–20 employees • 1K–10K rows

Fast-moving founding team. Answer leadership requests using foundational SQL (SELECT, WHERE, GROUP BY, aggregations, INNER/LEFT JOIN).

L2100 Qs

Growing Company

Junior Data Analyst
50–100 employees • ~100K rows

Multiple functional teams and expanding schemas. Write multi-table JOINs, Common Table Expressions (CTEs), CASE WHEN logic, and date math.

L3100 Qs

Scale-Up

Senior Data Analyst
200–500 employees • ~1M rows

High transaction volume and international cohorts. Master window functions (ROW_NUMBER, RANK, LAG/LEAD) and multi-step CTE analytics.

L4100 Qs

Enterprise

Lead Analytics Engineer
1,000+ employees • ~5M rows

Legacy systems and merged databases. Execute recursive queries, gap-and-island problems, deduplication algorithms, and query performance audits.

L5100 Qs

Global Corporation

Head of Data / Principal
5,000+ employees • 10M+ rows

Billion-dollar conglomerate. Formulate executive C-suite summaries, slowly changing dimensions (SCD), complex percentiles, and YoY variance.

Two Ways to Practice: Cloud Online or Local Machine

Recommended for Learners

Use the Hosted Vercel Platform

Zero installation, no Docker or Node.js required. Open your browser and immediately begin practicing SQL in WebAssembly PostgreSQL.

Launch sql-office-simulator.vercel.app →
For Developers & Contributors

Run Locally via Git

Clone the repository from GitHub, configure Supabase credentials, and contribute questions or features using Next.js 16 and TypeScript.

View Repository on GitHub →

Ready to Begin Your SQL Career?

Create your account today, review the honor policy, choose your starting company, and tackle your first assignment from leadership.