JSqlParser 0,1 travis-ci

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern


Build Status Coverage Status

PayPal donate button


Look here for more information and examples: https://github.com/JSQLParser/JSqlParser/wiki.


JSqlParser is dual licensed under LGPL V2.1 and Apache Software License, Version 2.0.


  • Version 0.9.6 released.
  • Version 0.9.5 released.
  • Please test the actual 0.9.5-SNAPSHOT. It includes some grammar refactorings which eventually results in parse tree changes.
  • Version 0.9.4 released.
  • Please test the actual SNAPSHOT, if there are problems using the extended identifier token.
  • Version 0.9.3 released.

More news can be found here: https://github.com/JSQLParser/JSqlParser/wiki/News.


JSqlParser is a SQL statement parser. It translates SQLs in a traversable hierarchy of Java classes. JSqlParser is not limited to one database but provides support for a lot of specials of Oracle, SqlServer, MySQL, PostgreSQL ... To name some, it has support for Oracles join syntax using (+), PostgreSQLs cast syntax using ::, relational operators like != and so on.


If you need help using JSqlParser feel free to file an issue or contact me.


To help JSqlParsers development you are encouraged to provide

  • feedback
  • bugreports
  • pull requests for new features
  • improvement requests
  • fund new features

Also I would like to know about needed examples or documentation stuff.

Extensions in the latest SNAPSHOT version 0.9.7

  • improved Postgresql JSON - support
  • integrated some Postgresql create table contraints

Extensions of JSqlParser releases

BUILDING from the sources

As the project is a Maven project, building is rather simple by running:

mvn package

This will produce the jsqlparser-VERSION.jar file in the target/ directory.

Maven Repository

JSQLParser is deployed at sonatypes open source maven repository. Starting from now I will deploy there. The first snapshot version there will be 0.8.5-SNAPSHOT. To use it this is the repository configuration:


This repositories releases will be synched to maven central. Snapshots remain at sonatype.

And this is the dependency declaration in your pom:


Related Repositories



Mybatis通用分页插件 ...



A wrapper to replicate Android's SQLiteDatabase with restoring capability ...



Stream MySQL binary logs and consume them with Scala actors (RabbitMQ, Kafka). ...



Cassandra JDBC driver that works with 2.x and above. It intends to provide bette ...



通过sql来查询hbase上的数据 ...

Top Contributors

wumpz CeeKayGit cbockermann georgekankava LionelNirva valdasraps wrobstory skomlaebri davelindquist-egistix bgaborg chiastic-security matthiasblaesing Rodac rotty3000 nhanitvn schweighart shuyangzhou gtss weiznich ig0774 IamJeffG luksrn meganwoods iceflying aalmiray audrium emopers ftaras pabloa packageOk


-   jsqlparser-0.9.6 zip tar
-   jsqlparser-0.9.5 zip tar
-   jsqlparser-0.9.4 zip tar
-   jsqlparser-0.9.3 zip tar
-   jsqlparser-0.9.2 zip tar
-   jsqlparser-0.9.1 zip tar
-   jsqlparser-0.9 zip tar
-   jsqlparser-0.8.9 zip tar
-   jsqlparser-0.8.8 zip tar
-   jsqlparser-0.8.6 zip tar
-   jsqlparser-0.8.5 zip tar
-   jsqlparser-0.8.4 zip tar