Telemetry
For web teams connecting Core Web Vitals to routes and releases

Frontend Performance Monitoring with SQL

Track typed LCP, INP, and CLS samples by stable route and release, then use SQL to find frontend regressions without collecting raw URLs or page content.

Reviewed by the Telemetry product team on . Event contract, recommended analysis, and privacy boundaries. Editorial ownership

Get an API keyCopy the prompt
Why this works
  • Preserve each web vital and its unit instead of collapsing experience into one opaque score.
  • Tie performance changes to stable route templates, release identifiers, and sufficient sample counts.
  • Keep query strings, raw URLs, page contents, and unrestricted user identifiers out of the event contract.

Agent prompt

Paste this into your coding agent

Replace YOUR_API_KEY after signup, then ask the agent to run the product flow and verify the first events.

agent prompt

Frontend Performance Monitoring with SQL setup prompt

text
Instrument frontend performance with Telemetry.

Use /skill.md and this Telemetry API key: YOUR_API_KEY

Add typed frontend_vital_measured events with route_template, release, metric_name, metric_value, metric_unit, threshold_version, passed, device_class, and environment.

Create SQL and a dashboard for sample count, LCP, INP, CLS, and passing-sample rate by route and release. Require a reviewed minimum sample count before comparing releases or enabling an alert.

Use route templates, bounded device classes, and versioned thresholds. Do not log raw URLs, query strings, DOM content, form values, cookies, auth tokens, or unrestricted user identifiers.

Setup steps

  1. 1Choose the product routes and supported performance metrics that matter.
  2. 2Emit typed browser measurements with route, release, threshold version, and environment.
  3. 3Send synthetic passing and failing samples from a test release.
  4. 4Review route-level samples and thresholds before enabling release guardrails.

Events to capture

frontend_vital_measuredfrontend_navigation_completedfrontend_resource_failedfrontend_release_observed

Questions unlocked

  • Which routes have the weakest passing-sample rate?
  • Did the latest frontend release change LCP, INP, or CLS?
  • Is a regression broad or limited to a reviewed device class?

Related SQL recipes

Answer the next question with SQL

Run the query against the structured fields from this workflow, inspect the example result, and turn a useful answer into a dashboard or alert.

Browse all recipes
Frontend reliabilityIntermediate

Compare Core Web Vitals by Route and Release

Which route and release has the weakest frontend performance?

Open recipe
Frontend reliabilityBeginner

Rank JavaScript Errors by Route and Release

Which route and frontend release produces the broadest JavaScript error impact?

Open recipe
Frontend reliabilityIntermediate

Measure SPA Navigation Latency by Route

Which destination routes have the slowest client-side navigation?

Open recipe
Frontend reliabilityIntermediate

Calculate Browser Long-Task Rate by Route

Which routes and releases spend the most time in browser long tasks?

Open recipe
Frontend reliabilityBeginner

Find Slow Frontend Resources by Host

Which resource hosts and types are slowing or failing page loads?

Open recipe

Next step

Create the API key your agent will use

The free plan is enough to run the prompt, send test events, and review the first dashboard.

Prompt packStart free

Related pages