What problem does it solve?
This skill solves the challenge of accurately parsing SQL into a Concrete Syntax Tree (CST) that preserves every detail, including comments, whitespace, and formatting, which standard AST parsers often discard.
Core Features & Use Cases
- DDL Metadata Extraction: Automatically extract table, column, and index definitions from schema files for documentation or migration planning.
- SQL Analysis & Linting: Build custom SQL linters, formatters, or static analysis tools that require full fidelity to the original source code.
- Use Case: When you need to refactor a large legacy database schema, use this skill to parse the DDL, identify all foreign key constraints, and generate a dependency graph without needing a live database connection.
Quick Start
Use the sql-parser-cst skill to parse the provided schema.sql file and extract all table names and their corresponding column definitions.