playwright: Skill for Claude Code

Playwright Test Results (DuckDB)

A single DuckDB file holds recent Playwright CI test results, so you can answer questions about failures, flakiness, and slow tests with plain SQL. It is refreshed every few hours.

Get the database

Download the latest snapshot and top it up with the newest runs:

npm ci                       # first time only, from the repo root
GITHUB_TOKEN=$(gh auth token) node utils/test-results-db/cli.ts update --lookback-days 3

update downloads the snapshot first when there is no local database, then ingests only the artifacts the snapshot lacks. Never delete the database to rebuild it: every artifact costs one GitHub API request, the budget is shared by every workflow in the repository, and a rebuild of a few days exhausts it. To only refresh the snapshot without ingesting, run download.

Query it through the bundled @duckdb/node-api binding — no separate DuckDB install needed, it ships in node_modules after npm ci:

node --input-type=module -e '
import { DuckDBInstance } from "@duckdb/node-api";
const conn = await (await DuckDBInstance.create("utils/test-results-db/test-results.duckdb")).connect();
console.table((await conn.runAndReadAll(process.argv[1])).getRowObjectsJson());
' "SELECT count(*) FROM test_results"

Integer columns come back as strings (JSON-safe), so do ranking and filtering in SQL, not in JS.

Schema

Single table test_results, one row per test result (one row per retry). The columns are inferred from the parquet the reporter emits (tests/config/parquetReporter.ts), plus two trailing columns this CLI adds:

Column	Meaning
run_id, run_attempt	GitHub Actions run identity
run_started_at	when the run started
workflow_name	e.g. tests 1 / tests 2 / tests others / MCP
event	push / pull_request
head_sha, head_branch, pr_number	what was tested
bot_name	e.g. chromium-ubuntu-22.04-node20, webkit-macos-15-large — the CI bot. OS and arch are encoded here; there is no separate os column.
project_name	CI project = browser + suite, e.g. chromium-page, webkit-library, playwright-test
test_title	title path within the file, joined by › (describe › test)
file, line, column_number	source location (file is relative to repo root)
expected_status	passed / skipped / ...
status	actual result: passed / failed / timedOut / skipped / interrupted
retry	0 = first attempt
result_started_at	when this attempt started
duration_ms	result duration
error_message	all errors joined, ANSI-stripped (NULL when none)
tags	list of strings, e.g. ['@slow', '@flaky'] (use list functions / list_contains)
annotations	list of {type, description} structs, e.g. [{'type': 'skip', 'description': 'flaky on CI'}] (empty list when none)
artifact_id	the GitHub artifact this row came from (dedupe key)
ingested_at	debug only — when this row was imported