Enterprise IDE Extension

Product · Dev Tools · VS Code · TypeScript

Analysts worked against a large enterprise data platform (2,000+ tables) with no IDE-native tooling, and any AI assistance had to respect data-loss-prevention and governance rules. Working with the team, I prioritized the backlog and shaped the governance guardrails for AI suggestions, then built the extension that puts querying, exploration, and safe AI help in one place.

Problem

Working with a 2,000+ table enterprise platform without IDE-native tooling was slow, and introducing AI assistance raised real governance and data-protection concerns.

Solution

A VS Code extension: extension host plus Svelte 5 webview panels over an enterprise REST API — NL2SQL, IntelliSense across 2,000+ tables, concurrent multi-environment query execution, dependency-graph visualization, and AI suggestions via the Copilot Language Model API with DLP filtering.

My Contribution

I prioritized the backlog and shaped the DLP/governance requirements for AI-generated prompts with the team, then built the extension — contributing as lead business analyst and engineer.

Outcomes

Delivered 30% developer time savings across key engineering workflows
Built comprehensive CI/CD test automation across unit & E2E pipelines
Enabled concurrent multi-environment query execution