General

uat-reporter - Claude MCP Skill

Writes UAT test results (Pass/Fail/Blocked/Skip with color formatting) to the Google Sheet 'All Test Cases' tab. Use when: (1) Recording test results after UAT execution, (2) Writing a single test result for debugging, (3) Verifying previously written results match expected values, (4) Previewing what would be written with dry-run mode. Supports batch writes per module, single-test writes, row lookup by test ID, color-coded status cells, verification readback, and dual logging.

SEO Guide: Enhance your AI agent with the uat-reporter tool. This Model Context Protocol (MCP) server allows Claude Desktop and other LLMs to writes uat test results (pass/fail/blocked/skip with color formatting) to the google sheet 'all test... Download and configure this skill to unlock new capabilities for your AI workflow.

🌟1 stars • 0 forks
📥0 downloads

Documentation

SKILL.md
# UAT Reporter

Write UAT test results to the Google Sheet "All Test Cases" tab with color-coded status cells, row lookup by test ID, and verification readback.

Uses shared OAuth token from google-sheets skill (`~/.claude/.google/token.json`).

## Commands

### report-batch (primary)

Write all results from a module JSON file:

```bash
~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-batch --file .uat/results/dashboard.json
```

Or via stdin:
```bash
cat .uat/results/dashboard.json | ~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-batch
```

### report-single

Write one test result:

```bash
~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-single \
  --test-id DASH-NAV-001 --status Pass --notes "Dashboard loads correctly"
```

### verify

Read back written results and compare against JSON file:

```bash
~/.claude/skills/uat-reporter/scripts/uat_reporter.rb verify --file .uat/results/dashboard.json
```

### sync-summaries

Recalculate the Summary and Module Summary tabs from All Test Cases data. Run this after any test result update to keep all tabs synchronized:

```bash
~/.claude/skills/uat-reporter/scripts/uat_reporter.rb sync-summaries
```

Preview what would be written:
```bash
~/.claude/skills/uat-reporter/scripts/uat_reporter.rb sync-summaries --dry-run
```

**When to use:** After `report-batch`, `report-single`, or any manual sheet edit to keep Summary and Module Summary tabs in sync with the All Test Cases source of truth.

## Flags

All commands accept:
- `--dry-run` — Preview without modifying the sheet
- `--spreadsheet-id <id>` — Override default from `.uat/config.json`

## Configuration

- **Default spreadsheet ID**: `.uat/config.json` → `google_sheet_id`
- **OAuth token**: `~/.claude/.google/token.json` (shared with google-sheets skill)
- **Log file**: `.uat/logs/reporter.log`

## Exit Codes

0=success, 1=operation failed, 2=auth error, 3=API error, 4=invalid args

## Bundled Resources

- **`scripts/uat_reporter.rb`** — Main executable script
- **`references/color-map.json`** — Status-to-RGB color mappings (Pass=green, Fail=red, Blocked=yellow, Skip=gray)
- **`references/sample-results.json`** — Hand-crafted test results for validation

Signals

Avg rating0.0
Reviews0
Favorites0

Information

Repository
arlenagreer/claude_configuration_docs
Author
arlenagreer
Last Sync
4/7/2026
Repo Updated
3/17/2026
Created
3/9/2026

Reviews (0)

No reviews yet. Be the first to review this skill!