How do I limit results without a TOP clause?

Since WIQL doesn't support SELECT TOP in this context, the skill uses shell commands like 'head' to limit result sets from the command line output.

Does it support hierarchical or tree queries?

No, the Azure CLI currently only supports flat queries. You can filter by parent IDs using an IN clause, but native tree views are not supported.

Why use this instead of the official Microsoft MCP server?

This skill uses the Azure CLI (az), providing a more stable and reliable connection than the standard MCP server which can be prone to bugs.

Does it support wildcards like SQL LIKE?

No, WIQL does not support SQL-style LIKE patterns. You must use the CONTAINS operator for text searching within titles or tags.

Azure DevOps WIQL Query Builder

Name: Azure DevOps WIQL Query Builder
Author: JoshuaRamirez

byJoshuaRamirez

Collaboration Tools

Constructs and executes Work Item Query Language (WIQL) queries for Azure DevOps boards using the Azure CLI.

About

The Azure DevOps WIQL Query Builder skill provides a reliable way for Claude to interact with Azure Boards by leveraging the Azure CLI instead of the standard MCP server. It handles the nuances of WIQL syntax, including work item filtering by state, assignee, tags, and iteration paths, while accounting for specific CLI limitations like the lack of TOP clauses or SQL-style LIKE operators. This skill is essential for developers and project managers who need to find bugs, list tasks, or generate custom reports directly within their Claude Code terminal environment.

Key Features

0 GitHub stars
Build complex WIQL queries for Azure Boards work items
Bypass standard MCP server bugs by utilizing Azure CLI commands
Handle specific WIQL limitations like lack of LIKE operators and TOP clauses
Filter items by state, type, assignee, iteration, and tags
Access verified query templates for common project management tasks

Use Cases

Searching for work items containing specific keywords or tags
Finding and listing all active bugs assigned to a specific user
Retrieving work items for the current sprint or specific iteration paths

About

Key Features

0 GitHub stars
Build complex WIQL queries for Azure Boards work items
Bypass standard MCP server bugs by utilizing Azure CLI commands
Handle specific WIQL limitations like lack of LIKE operators and TOP clauses
Filter items by state, type, assignee, iteration, and tags
Access verified query templates for common project management tasks

Use Cases

Searching for work items containing specific keywords or tags
Finding and listing all active bugs assigned to a specific user
Retrieving work items for the current sprint or specific iteration paths