Azure DevOps

Azure DevOps is Microsoft's comprehensive cloud-based platform for software development lifecycle management, providing integrated services for version control, continuous integration and continuous deployment (CI/CD), project management, testing, and collaboration. This platform enables development teams to plan work, collaborate on code development, and build and deploy applications across multiple environments.

Category	Source control & CI/CD
Direction	Query source
Sign-in	Personal Access Token
Query languages	SQLite
Tables	13
Query templates	60
Website	http://azure.com

Before you start

Huntbase signs in to Azure DevOps with Personal Access Token. Create the credential in Azure DevOps first, then keep it to hand for the Connect step.

1. Sign in to your organization at https://dev.azure.com/{organization}.
2. Open User settings and select Personal access tokens, then select + New Token.
3. Enter a name, select one organization, and set an expiration date.
4. Select only the scopes you need. For querying, that means read scopes only.
5. Select Create and copy the token. It isn't shown again.

Watch out for

• A token has the same permissions as the user who created it, and it can't grant more than that user has.
• Azure DevOps is retiring global tokens (valid for all organizations), and they stop working on December 1, 2026. Create a token scoped to one organization.
• Your organization's administrators might restrict token creation, scopes, or lifetimes.

For the vendor's own instructions, see Azure DevOps personal access token documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Azure DevOps

1. Go to Connections and click New connection, or click New connection on the Azure DevOps product page.
2. On Product, pick Azure DevOps and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Settings

Where your Azure DevOps lives:

Field	Required	Notes
Organization URL	Yes	Your organization URL, such as https://dev.azure.com/acme.

Credentials

The only Method is Personal Access Token. Enter a Credential label (for example Production), then fill in:

Field	Required	Notes
Personal Access Token	Yes	Secret — not shown again after you save it.

Query it

Once connected, Azure DevOps can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 13 tables listed below, alongside every other connected source.

Example: SQLite

Azure DevOps Projects - Show Capabilities — Retrieve the capabilities of Azure DevOps projects, including version control and process template settings.

select
  id,
  name,
  capabilities as version_control,
  capabilities as process_template
from
  azuredevops_project;

Azure DevOps ships with 60 query templates. Find them in Library › Queries — see Query templates.

What syncs automatically

Azure DevOps comes with a content pack. These queries run on a schedule on each new connection so the entities they find appear in the Activity Feed without you asking. You can turn syncing off from the connection's Synchronisation Settings card.

Query	Finds
Sync users	user
Sync projects	organization
Sync groups	group
Sync service endpoints	resource

Tables

Azure DevOps adds 13 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 13 tables

Table	Contains
azuredevops_build	Retrieve information about your builds.
azuredevops_build_definition	Retrieve information about your build definitions.
azuredevops_dashboard	Retrieve information about your dashboards.
azuredevops_git_repository	Retrieve information about your repositories.
azuredevops_git_repository_branch	Retrieve information about your repository branches.
azuredevops_group	Retrieve information about your groups.
azuredevops_pipeline	Retrieve information about your pipelines.
azuredevops_project	Retrieve information about your projects.
azuredevops_release	Retrieve information about your releases.
azuredevops_serviceendpoint	Retrieve information about your service endpoints.
azuredevops_team	Retrieve information about your teams.
azuredevops_team_member	Retrieve information about your team members.
azuredevops_user	Retrieve information about your users.

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog