SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Java SQL Projects
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
In the meantime, other query engine support is on the roadmap, including Apache Spark, Apache Flink, and others.
-
shardingsphere
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Project mention: Apache ShardingSphere: Effortless Database Scaling and Beyond! | dev.to | 2025-02-21View the Project on GitHub
-
-
Project mention: Data Warehouses and Data Lakes: Understanding Modern Data Storage Paradigms 📦 | dev.to | 2025-04-25
Follow Presto at Official Website, Linkedin, Youtube, and Slack channel to join the community.
-
-
Gravitino supports different query engines to access the metadata. Currently, it supports Trino, users can use Trino to query the metadata and data without needing to change the existing SQL dialects.
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
starrocks
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
-
Flyway is a Java-based migration tool that’s widely used in enterprise settings. While not Go-native, you can integrate it into Go projects using its CLI or by calling its Java library. Flyway is great for teams needing robust versioning and audit-ready migration history.
-
Use distributed data processing frameworks like Apache Beam or Apache Spark.
-
Project mention: How to Make Websites That Will Require Lots of Your Time and Energy | news.ycombinator.com | 2025-07-28
at the very least, if you are really writing lots of INSERTs by hand I bet you are either not quoting properly or you are writing queries with 15 placeholders and someday you'll put one in the wrong place.
ORMs and related toolkits have come a long way since they were called the "Vietnam of Computer Science". I am a big fan of JooQ in Java
https://www.jooq.org/
and SQLAlchemy in Python
https://www.sqlalchemy.org/
Note both of these support both an object <-> SQL mapper (usually with generated objects) that covers the case of my code sample above, and a DSL for SQL inside the host language which is delightful if you want to do code generation to make query builders and stuff like that. I work on a very complex search interface which builds out joins, subqueries, recursive CTEs, you name it, and the code is pretty easy to maintain.
-
Project mention: Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications | dev.to | 2025-07-30
Performance optimization in Spring Boot applications often requires deep visibility into database interactions. While traditional logging provides basic SQL query information, it frequently lacks the crucial context of where these queries originate in your codebase. This is especially important with lazy loading of Hibernate entities, where queries can be triggered unexpectedly throughout the application lifecycle. This article demonstrates how to implement a sophisticated logging solution that captures SQL execution stack traces, enabling developers to quickly identify and resolve performance bottlenecks.
-
JSqlParser
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
-
-
-
Project mention: Automating Serialization/Deserialization Tests with Orkes Conductor and LLMs | dev.to | 2025-05-29
Run Spotless to auto-format the code for style consistency.
-
Apache Ignite — Free and open-source, Apache Ignite is a horizontally scalable key-value cache store system with a robust multi-model database that powers APIs to compute distributed data. Ignite provides a security system that can authenticate users' credentials on the server. It can also be used for system workload acceleration, real-time data processing, analytics, and as a graph-centric programming model.
-
Calcite also has a relatively-unknown web tool for plan visualization that lets you step through execution.
It's a method from "RuleMatchVisualizer":
https://github.com/apache/calcite/blob/36f6dddd894b8b79edeb5...
Here's a screenshot of what the webpage looks like, for anyone curious:
https://github.com/GavinRay97/GraphQLCalcite/blob/92b18a850d...
-
OrientDB
OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries.
-
esProc
esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine.
Project mention: SPL Lightweight Multisource Mixed Computation Practices | news.ycombinator.com | 2025-08-20 -
-
Crate
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
-
linkis
Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Java SQL discussion
Java SQL related posts
-
A simplified definition of an ORM
-
SPL Lightweight Multisource Mixed Computation Practices
-
Gravitino - the unified metadata lake
-
A Lightweight Solution to Speed Up Queries by Dumping Data to Files
-
Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications
-
Cross-datasource union and comparison：SPL Lightweight Multisource Mixed Computation Practices #5
-
How to Make Websites That Will Require Lots of Your Time and Energy
-
A note from our sponsor - SaaSHub
www.saashub.com | 1 Sep 2025
Index
What are some of the best open-source SQL projects in Java? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | dbeaver | 45,039 |
| 2 | Apache Flink | 25,190 |
| 3 | shardingsphere | 20,434 |
| 4 | MyBatis | 20,214 |
| 5 | Presto | 16,475 |
| 6 | QuestDB | 16,023 |
| 7 | Trino | 11,811 |
| 8 | starrocks | 10,552 |
| 9 | Flyway | 9,053 |
| 10 | beam | 8,278 |
| 11 | jOOQ | 6,508 |
| 12 | Hibernate | 6,225 |
| 13 | JSqlParser | 5,790 |
| 14 | Apache Hive | 5,776 |
| 15 | liquibase | 5,198 |
| 16 | spotless | 5,044 |
| 17 | Apache Ignite | 4,978 |
| 18 | Apache Calcite | 4,925 |
| 19 | OrientDB | 4,862 |
| 20 | esProc | 4,662 |
| 21 | H2 | 4,431 |
| 22 | Crate | 4,288 |
| 23 | linkis | 3,387 |
Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com