PWProveWorksSign in
← All architecture templates
14CopilotsBlueprint

Data and SQL analytics copilot

Natural-language questions become governed queries, calculations, explanations, and visual results.

Runtime flow

What happens, in order.

The flow becomes the backbone of the audit trace. Every important boundary needs an input, an output, timing, and an owner.

  1. 01

    Resolve business terms against the semantic layer

  2. 02

    Generate and validate a read-only query

  3. 03

    Apply row, column, and tenant permissions

  4. 04

    Execute, verify calculations, and explain the result

Components

System inventory

  • Semantic layer
  • SQL generator
  • Policy engine
  • Read-only database
  • Result verifier

Test packs

Required coverage

  • SQL correctness
  • Data authorization
  • Calculation accuracy
  • Injection

Evidence

Capture contract

  • Semantic mapping
  • Generated SQL
  • Policy decision
  • Rows
  • Explanation