Problem

Writing raw SQL queries inside PHP code is error-prone and lacks autocomplete, field type hints, and real-time schema validation.

Solution

A language tool leveraging regex pattern matching, custom lexical parsing, AST construction via node-sql-parser, and schema caching for sub-millisecond autocomplete and diagnostics inside VS Code.

Responsibilities

• Engineered SQL string extraction pipeline supporting static method calls, heredoc, and nowdoc blocks in PHP.
• Implemented AST query parsing using node-sql-parser for table and column alias resolution.
• Built schema metadata fetching and in-memory caching for instant completions and field hovers.
• Integrated query execution webview with secure credential storage via VS Code SecretStorage.

Achievements

• Over 5,000+ active installations on the VS Code Marketplace.
• Eliminated SQL syntax and column name errors before code deployment.
• Delivered sub-millisecond autocomplete and hovering performance.

Technologies

• TypeScript
• VS Code API
• MySQL
• PHP Parsing
• AST
• node-sql-parser