JSQLParser/JSqlParser

Health v2 · maintenance only

Adoption not part of the score

5956 stars · 1429 forks observed · 2026-08-28

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

JSqlParser is a Java library that parses SQL statements into a traversable hierarchy of Java classes (an AST) that can be navigated via the Visitor Pattern and serialized back to SQL. It supports many dialects including Oracle, SQL Server, MySQL, and PostgreSQL without native extensions.

Use cases

• parse sql statements into an ast in java
• rewrite or transform sql queries programmatically
• validate sql syntax before execution
• extract table and column names from sql queries
• build a sql query builder on top of a parser
• translate sql between database dialects

When to choose

• you need to parse, analyze, or rewrite SQL on the JVM
• you need multi-dialect SQL support including Oracle, MySQL, PostgreSQL, and SQL Server specifics
• you want a pure-Java parser with no native dependencies

When to avoid

• you need a full SQL execution engine rather than parsing
• you work outside the JVM ecosystem
• you need complete support for every proprietary SQL extension of a single vendor

Facets

library · maturity active

parser serialization developer-tools databases parsers developer-tools jvm cross-platform sql-parser ast visitor-pattern javacc sql-dialects query-rewriting

Member repositories

For agents

markdown · JSON · MCP: product_card(name="JSQLParser/JSqlParser")