13 best Java SQL Database libraries in 2024

share link

by marketing.admin@openweaver.com dot icon Updated: Feb 10, 2023

technology logo
technology logo

Guide Kit Guide Kit  

Java is a programming language that is used to create applications for various platforms, including Windows, Mac OS, UNIX and Linux. SQL databases are the most common data storage systems for modern web applications. They are the backbone of any web application. Java SQL Database is a language-independent, vendor-neutral, technology-neutral specification intended to standardize the interaction between a database management system and a programming language. Java Database Connectivity (JDBC) API provides the ability to interact with databases that support the SQL standard. Java-JDBC is a pure Java package that provides both a JDBC driver and a rich set of classes for building and manipulating SQL statements, as well as for accessing data from relational database management systems. There are several popular Java SQL Database open source libraries available for developers: dbeaver - Free universal database tool and SQL client; questdb - open source SQL database designed to process time series data; zeppelin - Webbased notebook that enables datadriven.

dbeaverby dbeaver

Java doticonstar image 32395 doticonVersion:23.1.0doticon
License: Permissive (Apache-2.0)

Free universal database tool and SQL client

Support
    Quality
      Security
        License
          Reuse

            dbeaverby dbeaver

            Java doticon star image 32395 doticonVersion:23.1.0doticon License: Permissive (Apache-2.0)

            Free universal database tool and SQL client
            Support
              Quality
                Security
                  License
                    Reuse

                      questdbby questdb

                      Java doticonstar image 11579 doticonVersion:7.2doticon
                      License: Permissive (Apache-2.0)

                      An open source time-series database for fast ingest and SQL queries

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                questdbby questdb

                                Java doticon star image 11579 doticonVersion:7.2doticon License: Permissive (Apache-2.0)

                                An open source time-series database for fast ingest and SQL queries
                                Support
                                  Quality
                                    Security
                                      License
                                        Reuse

                                          zeppelinby apache

                                          Java doticonstar image 6070 doticonVersion:Currentdoticon
                                          License: Permissive (Apache-2.0)

                                          Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.

                                          Support
                                            Quality
                                              Security
                                                License
                                                  Reuse

                                                    zeppelinby apache

                                                    Java doticon star image 6070 doticonVersion:Currentdoticon License: Permissive (Apache-2.0)

                                                    Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.
                                                    Support
                                                      Quality
                                                        Security
                                                          License
                                                            Reuse

                                                              jOOQby jOOQ

                                                              Java doticonstar image 5459 doticonVersion:Currentdoticon
                                                              License: Others (Non-SPDX)

                                                              jOOQ is the best way to write SQL in Java

                                                              Support
                                                                Quality
                                                                  Security
                                                                    License
                                                                      Reuse

                                                                        jOOQby jOOQ

                                                                        Java doticon star image 5459 doticonVersion:Currentdoticon License: Others (Non-SPDX)

                                                                        jOOQ is the best way to write SQL in Java
                                                                        Support
                                                                          Quality
                                                                            Security
                                                                              License
                                                                                Reuse

                                                                                  orientdbby orientechnologies

                                                                                  Java doticonstar image 4608 doticonVersion:3.2.19doticon
                                                                                  License: Permissive (Apache-2.0)

                                                                                  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.

                                                                                  Support
                                                                                    Quality
                                                                                      Security
                                                                                        License
                                                                                          Reuse

                                                                                            orientdbby orientechnologies

                                                                                            Java doticon star image 4608 doticonVersion:3.2.19doticon License: Permissive (Apache-2.0)

                                                                                            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.
                                                                                            Support
                                                                                              Quality
                                                                                                Security
                                                                                                  License
                                                                                                    Reuse

                                                                                                      crateby crate

                                                                                                      Java doticonstar image 3692 doticonVersion:5.3.2doticon
                                                                                                      License: Permissive (Apache-2.0)

                                                                                                      CrateDB is a distributed SQL database for storing and analyzing massive amounts of data in real-time. Built on top of Lucene.

                                                                                                      Support
                                                                                                        Quality
                                                                                                          Security
                                                                                                            License
                                                                                                              Reuse

                                                                                                                crateby crate

                                                                                                                Java doticon star image 3692 doticonVersion:5.3.2doticon License: Permissive (Apache-2.0)

                                                                                                                CrateDB is a distributed SQL database for storing and analyzing massive amounts of data in real-time. Built on top of Lucene.
                                                                                                                Support
                                                                                                                  Quality
                                                                                                                    Security
                                                                                                                      License
                                                                                                                        Reuse

                                                                                                                          galaxysqlby ApsaraDB

                                                                                                                          Java doticonstar image 989 doticonVersion:galaxysql-5.4.13doticon
                                                                                                                          License: Permissive (Apache-2.0)

                                                                                                                          PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.

                                                                                                                          Support
                                                                                                                            Quality
                                                                                                                              Security
                                                                                                                                License
                                                                                                                                  Reuse

                                                                                                                                    galaxysqlby ApsaraDB

                                                                                                                                    Java doticon star image 989 doticonVersion:galaxysql-5.4.13doticon License: Permissive (Apache-2.0)

                                                                                                                                    PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
                                                                                                                                    Support
                                                                                                                                      Quality
                                                                                                                                        Security
                                                                                                                                          License
                                                                                                                                            Reuse

                                                                                                                                              mssql-jdbcby microsoft

                                                                                                                                              Java doticonstar image 960 doticonVersion:v12.3.1doticon
                                                                                                                                              License: Permissive (MIT)

                                                                                                                                              The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs).

                                                                                                                                              Support
                                                                                                                                                Quality
                                                                                                                                                  Security
                                                                                                                                                    License
                                                                                                                                                      Reuse

                                                                                                                                                        mssql-jdbcby microsoft

                                                                                                                                                        Java doticon star image 960 doticonVersion:v12.3.1doticon License: Permissive (MIT)

                                                                                                                                                        The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs).
                                                                                                                                                        Support
                                                                                                                                                          Quality
                                                                                                                                                            Security
                                                                                                                                                              License
                                                                                                                                                                Reuse

                                                                                                                                                                  sqllineby julianhyde

                                                                                                                                                                  Java doticonstar image 568 doticonVersion:sqlline-1.12.0doticon
                                                                                                                                                                  License: Permissive (BSD-3-Clause)

                                                                                                                                                                  Shell for issuing SQL to relational databases via JDBC

                                                                                                                                                                  Support
                                                                                                                                                                    Quality
                                                                                                                                                                      Security
                                                                                                                                                                        License
                                                                                                                                                                          Reuse

                                                                                                                                                                            sqllineby julianhyde

                                                                                                                                                                            Java doticon star image 568 doticonVersion:sqlline-1.12.0doticon License: Permissive (BSD-3-Clause)

                                                                                                                                                                            Shell for issuing SQL to relational databases via JDBC
                                                                                                                                                                            Support
                                                                                                                                                                              Quality
                                                                                                                                                                                Security
                                                                                                                                                                                  License
                                                                                                                                                                                    Reuse
                                                                                                                                                                                      Java doticonstar image 248 doticonVersion:v1.5.2doticon
                                                                                                                                                                                      License: Permissive (Apache-2.0)

                                                                                                                                                                                      Flume Source to import data from SQL Databases

                                                                                                                                                                                      Support
                                                                                                                                                                                        Quality
                                                                                                                                                                                          Security
                                                                                                                                                                                            License
                                                                                                                                                                                              Reuse

                                                                                                                                                                                                flume-ng-sql-sourceby keedio

                                                                                                                                                                                                Java doticon star image 248 doticonVersion:v1.5.2doticon License: Permissive (Apache-2.0)

                                                                                                                                                                                                Flume Source to import data from SQL Databases
                                                                                                                                                                                                Support
                                                                                                                                                                                                  Quality
                                                                                                                                                                                                    Security
                                                                                                                                                                                                      License
                                                                                                                                                                                                        Reuse

                                                                                                                                                                                                          SQLite-sync.comby sqlite-sync

                                                                                                                                                                                                          Java doticonstar image 229 doticonVersion:Currentdoticon
                                                                                                                                                                                                          License: Permissive (BSD-3-Clause)

                                                                                                                                                                                                          AMPLI-SYNC is a framework for synchronizing data between a Sqlite database and an MS SQL/MySQL/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated Bidirectional Synchronization when an internet connection becomes available.

                                                                                                                                                                                                          Support
                                                                                                                                                                                                            Quality
                                                                                                                                                                                                              Security
                                                                                                                                                                                                                License
                                                                                                                                                                                                                  Reuse

                                                                                                                                                                                                                    SQLite-sync.comby sqlite-sync

                                                                                                                                                                                                                    Java doticon star image 229 doticonVersion:Currentdoticon License: Permissive (BSD-3-Clause)

                                                                                                                                                                                                                    AMPLI-SYNC is a framework for synchronizing data between a Sqlite database and an MS SQL/MySQL/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated Bidirectional Synchronization when an internet connection becomes available.
                                                                                                                                                                                                                    Support
                                                                                                                                                                                                                      Quality
                                                                                                                                                                                                                        Security
                                                                                                                                                                                                                          License
                                                                                                                                                                                                                            Reuse

                                                                                                                                                                                                                              sqlautoreviewby taobao

                                                                                                                                                                                                                              Java doticonstar image 199 doticonVersion:Currentdoticon
                                                                                                                                                                                                                              License: Strong Copyleft (GPL-2.0)

                                                                                                                                                                                                                              automatic review database dml sql(select,insert,update,delete),build create index script for every SQL statment,and merge all create index script with exist indexes on these tables.

                                                                                                                                                                                                                              Support
                                                                                                                                                                                                                                Quality
                                                                                                                                                                                                                                  Security
                                                                                                                                                                                                                                    License
                                                                                                                                                                                                                                      Reuse

                                                                                                                                                                                                                                        sqlautoreviewby taobao

                                                                                                                                                                                                                                        Java doticon star image 199 doticonVersion:Currentdoticon License: Strong Copyleft (GPL-2.0)

                                                                                                                                                                                                                                        automatic review database dml sql(select,insert,update,delete),build create index script for every SQL statment,and merge all create index script with exist indexes on these tables.
                                                                                                                                                                                                                                        Support
                                                                                                                                                                                                                                          Quality
                                                                                                                                                                                                                                            Security
                                                                                                                                                                                                                                              License
                                                                                                                                                                                                                                                Reuse

                                                                                                                                                                                                                                                  filiby yahoo

                                                                                                                                                                                                                                                  Java doticonstar image 169 doticonVersion:Currentdoticon
                                                                                                                                                                                                                                                  License: Permissive (Apache-2.0)

                                                                                                                                                                                                                                                  Easily make RESTful web services for time series reporting with Big Data analytics engines like Druid and SQL Databases.

                                                                                                                                                                                                                                                  Support
                                                                                                                                                                                                                                                    Quality
                                                                                                                                                                                                                                                      Security
                                                                                                                                                                                                                                                        License
                                                                                                                                                                                                                                                          Reuse

                                                                                                                                                                                                                                                            filiby yahoo

                                                                                                                                                                                                                                                            Java doticon star image 169 doticonVersion:Currentdoticon License: Permissive (Apache-2.0)

                                                                                                                                                                                                                                                            Easily make RESTful web services for time series reporting with Big Data analytics engines like Druid and SQL Databases.
                                                                                                                                                                                                                                                            Support
                                                                                                                                                                                                                                                              Quality
                                                                                                                                                                                                                                                                Security
                                                                                                                                                                                                                                                                  License
                                                                                                                                                                                                                                                                    Reuse

                                                                                                                                                                                                                                                                      See similar Kits and Libraries