taozhi8833998/node-sql-parser

Health v2 · maintenance only

Adoption not part of the score

1038 stars · 242 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A Node.js and browser library that parses SQL statements into an abstract syntax tree (AST) and converts ASTs back to SQL. It supports multiple database dialects (MySQL, PostgreSQL, TransactSQL, BigQuery, Hive, and more) and reports visited table and column lists with corresponding authorities.

Use cases

• parse sql queries into an ast in nodejs
• convert an sql ast back into a sql string
• extract tables and columns referenced by a sql query
• validate or lint sql statements for multiple database dialects
• analyze sql permissions by checking visited tables and columns
• parse sql in the browser with a lightweight umd bundle

When to choose

• you need to parse or generate SQL for multiple database engines in JavaScript
• you want to inspect which tables and columns a query touches, e.g. for access control
• you need a parser that runs in both Node.js and the browser

When to avoid

• you need a full-fidelity parser for complex or vendor-specific SQL beyond simple statements
• you are not working in the JavaScript ecosystem
• you need query execution rather than parsing and analysis

Facets

library · maturity active

parser developer-tools databases parsers developer-tools browser sql-parser ast sql-generation pegjs multiple-dialects nodejs javascript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="taozhi8833998/node-sql-parser")