Codebase Understanding & Onboarding
Compatible with Cursor, Claude Code, Cline, Roo Code, Antigravity

End-to-End Request Flow & Data Pipeline Tracer

Trace user requests from UI actions or API ingress through middleware, services, queues, and database tables.

TracingArchitectureData FlowDebuggingCodebase
Skill Objective

Trace the exact execution path of a specific feature or API route across frontend components, network calls, backend middleware, business logic, queues, and database records.

Execution Workflow Procedure

Ordered steps the coding agent executes when performing this skill.

1

Identify Ingress Point

Locate the UI event handler, HTTP route handler, or webhook receiver initiating the flow.

2

Trace Middleware & Interceptors

Map authentication, validation, rate limiting, and transaction boundaries applied to the request.

3

Trace Service Logic & Side Effects

Follow the execution through domain services, third-party API calls, event publishing, and database mutations.

4

Generate Sequence Diagram

Deliver a Mermaid sequence diagram visualizing the end-to-end flow with exact file paths.

Agent Safety Guardrails & Anti-Hallucination Rules

  • DO NOT omit error or rollback branches when tracing transactional flows.
  • DO NOT skip async queue processing boundaries.

Expected Output Format

Step-by-step trace with Mermaid sequence diagram.

📊 Mermaid Sequence Diagram: Visual flow diagram with component labels.
📝 Execution Trace Walkthrough: File-by-file walkthrough with line references.

Domain Verification Checks

Complete Sequence Trace: Maps all touchpoints from UI to DB.
Side-Effect Inventory: Lists emails, analytics, and event emissions.
Mermaid Visualization: Provides a visual sequence diagram.

Example Agent Invocations

"Trace the end-to-end checkout request flow from the Pay button click to order database insertion."
"Map out how authentication tokens are validated and renewed across our frontend and API gateway."

Install / Configure This Skill

# Place in .cursorrules or create .cursor/rules/end-to-end-request-flow-tracer.mdc
# Trigger: Whenever you perform end-to-end request flow & data pipeline tracer

---
name: end-to-end-request-flow-tracer
description: Trace execution paths from UI clicks through middleware, domain services, database tables, and external APIs.
version: 1.0.0
compatibility: [Cursor, Claude Code, Cline, Roo Code, Antigravity]
---

# End-to-End Request Flow & Data Pipeline Tracer

## Objective
Trace complex feature execution flows across the full stack and deliver Mermaid sequence diagrams with exact file references.

## Workflow
1. **Ingress Identification**: Find the initiating UI handler or API route.
2. **Middleware & Services Trace**: Map authentication, validation, and domain logic.
3. **Side Effects & Persistence**: Track database mutations, message queue events, and external API calls.
4. **Mermaid Diagram**: Deliver a clear visual sequence diagram.
Complementary Agent Prompt

Need a quick one-time prompt for chat?

Try the Multi-File Codebase Exploration & Architectural Onboarding — a lightweight version designed for 1-click copying directly into Claude, ChatGPT, or Cursor chat.

View Prompt

SprintKit Workflow Integrations

Complementary tools and checklists to pair with this agent workflow.

Related Agent Skills

Explore related procedural workflows in this discipline.

All Skills

Multi-File Codebase Architectural Onboarding & Dependency Map

Prompt an agent to analyze an unfamiliar codebase and deliver an architectural breakdown, data flows, and gotchas.

OnboardingArchitectureAI Agents+2
3 workflow stepsView skill

Safe Pre-Change Impact & Blast-Radius Assessment

Evaluate the downstream risks, broken callers, and database implications before making complex code changes.

RefactoringImpact AnalysisRisk Assessment+1
3 workflow stepsView skill

Backward-Compatible RESTful API Design & OpenAPI Spec

Design or review RESTful API contracts for idempotency, pagination, error models, and non-breaking versioning.

APIRESTOpenAPI+2
4 workflow stepsView skill