Azure DevOps Reports

Use this skill for secure, read-focused Azure DevOps reporting.

Configuration

Load credentials from a local .env file stored in this skill directory.

Required variables:

• - INLINECODE1
• INLINECODE2

Optional defaults:

• - INLINECODE3
• INLINECODE4
• INLINECODE5
• INLINECODE6

If required values are missing, ask the user to create or update .env in this skill directory.

Runtime requirements

This skill requires:

• - Node.js
• Python 3
• INLINECODE8
• Python package: INLINECODE9

Install Python dependency once:

CODEBLOCK0

Safety guarantees

• - Read-only Azure DevOps access only
• No create, update, or delete operations for Azure DevOps work items
• No secret logging
• No Authorization header logging
• No arbitrary shell execution from user input
• Output restricted to local report files under the skill directory
• INLINECODE10 must resolve inside the skill directory
• Prefer least-privilege PAT scopes: vso.project and INLINECODE12

Workflow

1. 1. Load config from the skill-local .env file.
2. Resolve project, team, and query id from explicit arguments or configured defaults.
3. Decide whether the request is project-scoped, team-scoped, team-member scoped, saved-query, sprint-scoped, or custom-WIQL.
4. Fetch work item ids via WIQL when filtering is needed.
5. Fetch detailed work item fields.
6. Normalize records for reporting.
7. Default to the configured saved query when no explicit command or query id is provided.
8. Export to JSON or CSV data bundles.
9. Build summary tables for state, assignee, and work item type.
10. Build Excel charts from exported JSON when the user asks for workbook generation.
11. Use project listing, team listing, team-member listing, sprint listing, and saved-query reporting when the user asks in plain language.

Scripts

• - scripts/projects.js — list projects
• INLINECODE15 — list teams in a project and team members
• INLINECODE16 — list team iterations / current sprint
• INLINECODE17 — list saved queries and inspect a query definition
• INLINECODE18 — run work item queries and normalize results
• INLINECODE19 — export JSON/CSV data bundles
• INLINECODE20 — generate Excel workbooks with charts from exported JSON

Exact script usage

Run all commands from the skill directory:

CODEBLOCK1

1) List projects

CODEBLOCK2

2) List teams in a project

CODEBLOCK3

3) List members in a team

CODEBLOCK4

4) List current sprint

CODEBLOCK5

5) List all iterations / sprints

CODEBLOCK6

6) List saved queries in a project

CODEBLOCK7

7) Get a saved query definition by id

CODEBLOCK8

8) Fetch work items using saved query id

Explicit:

CODEBLOCK9

With defaults from .env:

CODEBLOCK10

9) List work items closed in the last 7 days

Using the default project from .env:

CODEBLOCK11

With an explicit project:

CODEBLOCK12

10) Export report data as JSON

Default saved-query export using .env defaults:

CODEBLOCK13

Explicit saved-query export:

CODEBLOCK14

Explicit sprint summary export:

CODEBLOCK15

11) Build Excel workbook from exported JSON

CODEBLOCK16

Ask ClawBot in plain English

These requests should map to the skill without manual script execution:

• - INLINECODE24
• INLINECODE25
• INLINECODE26
• INLINECODE27
• INLINECODE28
• INLINECODE29
• INLINECODE30
• INLINECODE31
• INLINECODE32
• INLINECODE33

References

Read these only if needed:

• - references/field-mapping.md for normalized field choices
• INLINECODE35 for report presets and chart ideas
• INLINECODE36 for endpoint notes and PAT scope guidance