ts-mysql-analyzer

A TypeScript MySQL query analyzer that detects syntax errors, validates table/column names against a provided schema, performs type checking, and offers optimization suggestions like missing indexes. Currently at version 0.3.0, it uses the companion package ts-mysql-schema to extract schema information from a live MySQL database. Supports custom parser options (e.g., MySQL version, character sets) and multiple statements. Differentiates itself from generic SQL parsers by providing actionable feedback tied to an actual database schema, making it useful for development and CI environments to catch SQL issues early.