The latest updates on your projects. Learn more about Vercel for GitHub.

Project	Deployment	Review	Updated (UTC)
docs	Ready	Preview, Comment	Dec 20, 2025 5:47am

Greptile Summary

This PR adds workspaceId directly to execution logs and creates composite indexes to optimize query performance.

Key Changes:

• Added workspace_id column to workflow_execution_logs table with a safe 6-step migration (nullable → backfill → delete orphans → NOT NULL → foreign key → indexes)
• Created composite index workspace_id + started_at on execution logs to eliminate expensive joins (previously: logs → workflows → workspaces)
• Added performance indexes: api_key(workspace_id, type), api_key(user_id, type), verification(expires_at), workflow_blocks(type)
• Propagated workspaceId through all execution entry points (API routes, webhooks, schedules, chat)
• Changed workspaceId from optional to required throughout logging infrastructure
• Updated all log queries to filter directly on workflowExecutionLogs.workspaceId instead of joining through workflow table
• Added validation to ensure workspaceId exists before execution, failing fast with clear error messages

Confidence Score: 5/5

• This PR is safe to merge - well-structured database migration with performance improvements and no logical issues
• The migration follows best practices with a safe 6-step approach. The workspaceId propagation is systematic and includes proper validation at all entry points. Query optimizations are sound and will significantly improve performance by eliminating joins. All changes maintain data integrity with foreign key constraints.
• No files require special attention

Important Files Changed

Sequence Diagram

sequenceDiagram
    participant Client
    participant Route as API Route<br/>(execute/webhook/schedule)
    participant Preprocess as Preprocessing
    participant LogSession as LoggingSession
    participant Logger as ExecutionLogger
    participant DB as Database<br/>(workflow_execution_logs)
    
    Client->>Route: Trigger workflow execution
    Route->>Preprocess: Validate workflow access
    Preprocess->>DB: Fetch workflow record
    DB-->>Preprocess: workflow (with workspaceId)
    Preprocess-->>Route: workflowRecord
    
    Route->>Route: Validate workspaceId exists
    alt workspaceId is null
        Route-->>Client: Error: No workspace
    end
    
    Route->>LogSession: safeStart({ workspaceId, userId })
    LogSession->>Logger: startWorkflowExecution({ workspaceId, workflowId, executionId })
    Logger->>DB: INSERT INTO workflow_execution_logs<br/>(workspace_id, workflow_id, execution_id)
    DB-->>Logger: Log entry created
    Logger-->>LogSession: Log started
    LogSession-->>Route: Session ready
    
    Route->>Route: Execute workflow
    Route-->>Client: Execution result
    
    Note over DB: New composite index:<br/>workspace_id + started_at<br/>enables fast queries