← Back to Projects

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 product owner and engineer.

Outcomes

  • Contributing an estimated $250K in annual business impact
  • 185 unit tests + 168 E2E tests (350+ total)
  • Concurrent multi-environment query execution