IGTS Investigation Toolkit

A VS Code extension that brings Azurion engineering investigation skills into GitHub Copilot Chat. Query field data, look up equipment configurations, check error rates, and more — directly from the chat interface.

Prerequisites

• VS Code 1.99+
• GitHub Copilot subscription
• Python 3.10+ on PATH
• Windows Credential Manager entries for the data sources you want to use:
  • Vertica — username = CODE1 account, password = Vertica password
• SSL certificate — C:\Users\<username>\.vsql\root.crt (for Vertica access)
• Network — Philips VPN with access to vertica.prod.asp-datascience.philips.com

Usage

Option A: Explicit invocation

Type @igts-test followed by your question:

@igts-test how often does error 20SSIEC0012901 occur on Azurion 2.2?
@igts-test what is the geo configuration for equipment 80118048?
@igts-test hello

Option B: Copilot agent mode (seamless)

In Copilot agent mode, just ask naturally — the extension's chatInstructions tells Copilot when to use the IGTS tools:

how often does error 20SSIEC0012901 occur on Azurion 2.2 in the field?

Power user: reference tools directly

Type # in any Copilot Chat to see available tools:

• #igtsExecuteVertica — run a Vertica SQL query
• #igtsExplainVertica — check query cost before running
• #igtsLookupColumns — look up table column names and types
• #igtsGetSkill — load a skill's full instructions

Available Skills

First-Time Setup

On first use, the extension will:

1. Detect Python on your PATH
2. Ask permission to create a virtual environment (~10 seconds)
3. Install vertica-python and pandas from bundled wheels (no network needed)

This happens once. Subsequent launches reuse the cached environment.

Credential Setup

Add credentials via Windows Credential Manager (not command line):

1. Open Credential Manager → Windows Credentials → Add a generic credential
2. Internet address: Vertica
3. User name: your CODE1 account
4. Password: your Vertica password

Troubleshooting