← atlas·database-indexes

create-index

User initiates index creation via the database indexes surface. The journey covers index-type selection, column selection, and post-creation feedback including performance impact (Sara's query-plan reveal, Nate's micro-progress).

default path · what bare Studio does

  1. 01
    route/project/[ref]/database/indexesactionopen-index-creationuiopen-modal
  2. 02
    route/project/[ref]/database/indexesactionselect-table
  3. 03
    route/project/[ref]/database/indexesactionselect-columns
  4. 04
    route/project/[ref]/database/indexesactionselect-index-type
  5. 05
    route/project/[ref]/database/indexesactionconfirm-create-indexside-effectexecute-ddl
  6. 06
    route/project/[ref]/database/indexesactionserver-ackuiindex-creation-toast

per-profile overrides · vehicle × route

Three vehicles, three routes

Connector · Battleship

Monica

sea route

“Bring the team into the workflow.”

deltas

  • ›Enter: recent-activity-feed
  • ›prelude · CollabRail
  • ›on save · TeamSaveAck

slot fillers wired

  • preright-rail · CollabRail
  • on savesave-confirmation · TeamSaveAckIndex shared with 3 team members who use this query

cognitive justification

HSP + Connector → team context normalizes performance optimization. The collab rail surfaces who benefits from the index; the save-ack transfers the optimization to collective wins (GABA −22 reduces performance-anxiety).

Try Monica's route →

Explorer · Tractor

Nate

field route

“Show me what I don't already know.”

deltas

  • ›Enter: schema-map-tile
  • ›prelude · AdvanceNoticeStrip
  • ›trailing · MicroProgress
  • ›chunk · 4

slot fillers wired

  • preadvance-notice · AdvanceNoticeStrip
  • trailingmain-postlude · MicroProgress

cognitive justification

ASD prediction-error + ADHD DA-seeking → micro-progress bar provides step-by-step feedback during index creation. Advance-notice strip surfaces trade-offs (write-cost / read-cost) in literal terms. Zero motion respects HSP sensory flood.

Try Nate's route →

Analyst · Airplane

Sara

air route

“Numbers first. Then we talk.”

deltas

  • ›Enter: kpi-drill
  • ›prelude · KpiBand
  • ›on save · SaveLedger

slot fillers wired

  • premain-prelude · KpiBand
  • on savemain-postlude · SaveLedger✓ index created · execution cost {{before}}ms → {{after}}ms ({{pct_saved}}% faster)

cognitive justification

CORT +19 + Analyst (A 0.000) → SaveLedger's "execution cost delta" satisfies DA-seeking with concrete performance gains. KpiBand provides pre-index context. The numeric format ("2000ms → 150ms") provides immediate reassurance that the optimization was worth the write-cost trade-off.

Try Sara's route →