skills.rest
danielraffel
danielraffelCOMMUNITY
Explore all skills by this author →
GitHub

trace-sql

Query and analyze Pulp Perfetto trace data using SQL syntax.

1|Updated Jul 11, 2026
Search Tags:#sql#perfetto#trace analysis#performance diagnostics#pulp
One-click install
npx skills add https://github.com/danielraffel/burl --skill trace-sql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: trace-sql
Source: https://github.com/danielraffel/burl/tree/main/.agents/skills/trace-sql
Command: npx skills add https://github.com/danielraffel/burl --skill trace-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a structured SQL discipline for querying and analyzing Pulp Perfetto traces, enabling users to quickly understand and interpret trace data.

Core Features & Use Cases

  • Structured SQL Queries: Leverage the power of SQL to query Pulp Perfetto traces.
  • Automated Analysis: Automates the analysis of traces for common scenarios such as slowest frames, xruns, and layout issues.
  • Use Case: When troubleshooting performance issues in Pulp, use this Skill to query trace data for insights on slow operations or xruns.

Quick Start

To query slowest frames in the Pulp trace, run: SELECT name, dur FROM pulp_slowest_frames ORDER BY dur DESC LIMIT 20

Frequently Asked Questions about trace-sql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Perfetto trace data to diagnose performance issues in Pulp applications?▼

To query Perfetto trace data for Pulp performance diagnostics, you can run SQL statements against the trace files using the trace_processor utility. This allows you to analyze trace data for insights on slow operations or xruns.

Can I use SQL to find the slowest frames in a Perfetto trace?▼

Yes, you can use SQL to find the slowest frames in a Perfetto trace by executing a query like `SELECT name, dur FROM pulp_slowest_frames ORDER BY dur DESC LIMIT 20` to retrieve and sort frame durations.

What do I need to analyze Pulp Perfetto traces with SQL?▼

To analyze Pulp Perfetto traces with SQL, you need access to Pulp Perfetto trace files and the trace_processor utility. These components allow you to execute structured SQL queries for trace analysis.

What kind of performance diagnostics can I automate using SQL on Perfetto traces?▼

Using SQL on Perfetto traces, you can automate the analysis of common performance diagnostic scenarios such as identifying the slowest frames, detecting xruns, and investigating layout issues within Pulp applications.

Does using SQL for Perfetto trace analysis require manual query construction for every issue?▼

No, using SQL for Perfetto trace analysis does not always require manual construction. The approach provides a structured SQL discipline that automates trace analysis for common scenarios, helping you quickly interpret trace data.

Related Skills

Explore More Software Engineering Skills→
Generous-CorpGenerous-Corp
13

trace-sql

Analyze Pulp Perfetto .pftrace files with SQL to identify performance bottlenecks.

Official
Advanced
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate
inehemiasminehemiasm

perfetto-sql

Translate natural language performance questions into validated Perfetto SQL queries.

Community
Advanced
Kaito-DogiKaito-Dogi

perfetto-sql

Execute SQL queries on Android Perfetto trace files to extract performance data.

Community
Advanced