13 best Python SQL Database libraries in 2024

share link

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

technology logo
technology logo

Guide Kit Guide Kit  

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code. The language provides constructs intended to enable clear programs on both a small and large scale. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive standard library. A database is an organized collection of data that's stored on a computer so that it can be accessed easily. Databases are used for many different purposes, but they're often used to store large amounts of information and retrieve it quickly when needed. Many developers depend on the following Python SQL Database open source libraries: sqlmap - Automatic SQL injection and database takeover tool; q - q Run SQL directly on CSV or TSV files; sqlmodel - SQL databases in Python, designed for simplicity, compatibility, and robustness.

sqlmapby sqlmapproject

Python doticonstar image 27305 doticonVersion:1.7doticon
License: Others (Non-SPDX)

Automatic SQL injection and database takeover tool

Support
    Quality
      Security
        License
          Reuse

            sqlmapby sqlmapproject

            Python doticon star image 27305 doticonVersion:1.7doticon License: Others (Non-SPDX)

            Automatic SQL injection and database takeover tool
            Support
              Quality
                Security
                  License
                    Reuse

                      qby harelba

                      Python doticonstar image 9880 doticonVersion:latestdoticon
                      License: Strong Copyleft (GPL-3.0)

                      q - Run SQL directly on delimited files and multi-file sqlite databases

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                qby harelba

                                Python doticon star image 9880 doticonVersion:latestdoticon License: Strong Copyleft (GPL-3.0)

                                q - Run SQL directly on delimited files and multi-file sqlite databases
                                Support
                                  Quality
                                    Security
                                      License
                                        Reuse

                                          sqlmodelby tiangolo

                                          Python doticonstar image 10021 doticonVersion:0.0.8doticon
                                          License: Permissive (MIT)

                                          SQL databases in Python, designed for simplicity, compatibility, and robustness.

                                          Support
                                            Quality
                                              Security
                                                License
                                                  Reuse

                                                    sqlmodelby tiangolo

                                                    Python doticon star image 10021 doticonVersion:0.0.8doticon License: Permissive (MIT)

                                                    SQL databases in Python, designed for simplicity, compatibility, and robustness.
                                                    Support
                                                      Quality
                                                        Security
                                                          License
                                                            Reuse

                                                              bayesliteby probcomp

                                                              Python doticonstar image 882 doticonVersion:Currentdoticon
                                                              License: Permissive (Apache-2.0)

                                                              BayesDB on SQLite. A Bayesian database table for querying the probable implications of data as easily as SQL databases query the data itself.

                                                              Support
                                                                Quality
                                                                  Security
                                                                    License
                                                                      Reuse

                                                                        bayesliteby probcomp

                                                                        Python doticon star image 882 doticonVersion:Currentdoticon License: Permissive (Apache-2.0)

                                                                        BayesDB on SQLite. A Bayesian database table for querying the probable implications of data as easily as SQL databases query the data itself.
                                                                        Support
                                                                          Quality
                                                                            Security
                                                                              License
                                                                                Reuse
                                                                                  Python doticonstar image 745 doticonVersion:Currentdoticon
                                                                                  License: Others (Non-SPDX)

                                                                                  Azure SQL Database Samples and Reference Implementation Repository

                                                                                  Support
                                                                                    Quality
                                                                                      Security
                                                                                        License
                                                                                          Reuse

                                                                                            azure-sql-database-samplesby Azure

                                                                                            Python doticon star image 745 doticonVersion:Currentdoticon License: Others (Non-SPDX)

                                                                                            Azure SQL Database Samples and Reference Implementation Repository
                                                                                            Support
                                                                                              Quality
                                                                                                Security
                                                                                                  License
                                                                                                    Reuse

                                                                                                      etlalchemyby seanharr11

                                                                                                      Python doticonstar image 467 doticonVersion:1.1.1doticon
                                                                                                      License: Permissive (MIT)

                                                                                                      Extract, Transform, Load: Any SQL Database in 4 lines of Code.

                                                                                                      Support
                                                                                                        Quality
                                                                                                          Security
                                                                                                            License
                                                                                                              Reuse

                                                                                                                etlalchemyby seanharr11

                                                                                                                Python doticon star image 467 doticonVersion:1.1.1doticon License: Permissive (MIT)

                                                                                                                Extract, Transform, Load: Any SQL Database in 4 lines of Code.
                                                                                                                Support
                                                                                                                  Quality
                                                                                                                    Security
                                                                                                                      License
                                                                                                                        Reuse

                                                                                                                          hueby cloudera

                                                                                                                          JavaScript doticonstar image 878 doticonVersion:release-4.11.0doticon
                                                                                                                          License: Permissive (Apache-2.0)

                                                                                                                          Open source SQL Query Assistant service for Databases/Warehouses

                                                                                                                          Support
                                                                                                                            Quality
                                                                                                                              Security
                                                                                                                                License
                                                                                                                                  Reuse

                                                                                                                                    hueby cloudera

                                                                                                                                    JavaScript doticon star image 878 doticonVersion:release-4.11.0doticon License: Permissive (Apache-2.0)

                                                                                                                                    Open source SQL Query Assistant service for Databases/Warehouses
                                                                                                                                    Support
                                                                                                                                      Quality
                                                                                                                                        Security
                                                                                                                                          License
                                                                                                                                            Reuse

                                                                                                                                              GodMode2by vas3k

                                                                                                                                              CSS doticonstar image 261 doticonVersion:Currentdoticon
                                                                                                                                              License: Permissive (WTFPL)

                                                                                                                                              Semi-automatic admin site generator for any SQL database

                                                                                                                                              Support
                                                                                                                                                Quality
                                                                                                                                                  Security
                                                                                                                                                    License
                                                                                                                                                      Reuse

                                                                                                                                                        GodMode2by vas3k

                                                                                                                                                        CSS doticon star image 261 doticonVersion:Currentdoticon License: Permissive (WTFPL)

                                                                                                                                                        Semi-automatic admin site generator for any SQL database
                                                                                                                                                        Support
                                                                                                                                                          Quality
                                                                                                                                                            Security
                                                                                                                                                              License
                                                                                                                                                                Reuse

                                                                                                                                                                  db-to-sqliteby simonw

                                                                                                                                                                  Python doticonstar image 292 doticonVersion:1.5doticon
                                                                                                                                                                  License: Permissive (Apache-2.0)

                                                                                                                                                                  CLI tool for exporting tables or queries from any SQL database to a SQLite file

                                                                                                                                                                  Support
                                                                                                                                                                    Quality
                                                                                                                                                                      Security
                                                                                                                                                                        License
                                                                                                                                                                          Reuse

                                                                                                                                                                            db-to-sqliteby simonw

                                                                                                                                                                            Python doticon star image 292 doticonVersion:1.5doticon License: Permissive (Apache-2.0)

                                                                                                                                                                            CLI tool for exporting tables or queries from any SQL database to a SQLite file
                                                                                                                                                                            Support
                                                                                                                                                                              Quality
                                                                                                                                                                                Security
                                                                                                                                                                                  License
                                                                                                                                                                                    Reuse

                                                                                                                                                                                      pythonqlby pythonql

                                                                                                                                                                                      Python doticonstar image 205 doticonVersion:v2-0.9.51doticon
                                                                                                                                                                                      License: Others (Non-SPDX)

                                                                                                                                                                                      A Query Language extension for Python: Query files, objects, SQL and NoSQL databases with a built-in query language

                                                                                                                                                                                      Support
                                                                                                                                                                                        Quality
                                                                                                                                                                                          Security
                                                                                                                                                                                            License
                                                                                                                                                                                              Reuse

                                                                                                                                                                                                pythonqlby pythonql

                                                                                                                                                                                                Python doticon star image 205 doticonVersion:v2-0.9.51doticon License: Others (Non-SPDX)

                                                                                                                                                                                                A Query Language extension for Python: Query files, objects, SQL and NoSQL databases with a built-in query language
                                                                                                                                                                                                Support
                                                                                                                                                                                                  Quality
                                                                                                                                                                                                    Security
                                                                                                                                                                                                      License
                                                                                                                                                                                                        Reuse

                                                                                                                                                                                                          queryby boydgreenfield

                                                                                                                                                                                                          Python doticonstar image 175 doticonVersion:v0.1.3doticon
                                                                                                                                                                                                          License: Permissive (MIT)

                                                                                                                                                                                                          Interactive SQL database exploration in Python

                                                                                                                                                                                                          Support
                                                                                                                                                                                                            Quality
                                                                                                                                                                                                              Security
                                                                                                                                                                                                                License
                                                                                                                                                                                                                  Reuse

                                                                                                                                                                                                                    queryby boydgreenfield

                                                                                                                                                                                                                    Python doticon star image 175 doticonVersion:v0.1.3doticon License: Permissive (MIT)

                                                                                                                                                                                                                    Interactive SQL database exploration in Python
                                                                                                                                                                                                                    Support
                                                                                                                                                                                                                      Quality
                                                                                                                                                                                                                        Security
                                                                                                                                                                                                                          License
                                                                                                                                                                                                                            Reuse

                                                                                                                                                                                                                              CueObserveby cuebook

                                                                                                                                                                                                                              Python doticonstar image 144 doticonVersion:v0.3.2doticon
                                                                                                                                                                                                                              License: Permissive (Apache-2.0)

                                                                                                                                                                                                                              Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases

                                                                                                                                                                                                                              Support
                                                                                                                                                                                                                                Quality
                                                                                                                                                                                                                                  Security
                                                                                                                                                                                                                                    License
                                                                                                                                                                                                                                      Reuse

                                                                                                                                                                                                                                        CueObserveby cuebook

                                                                                                                                                                                                                                        Python doticon star image 144 doticonVersion:v0.3.2doticon License: Permissive (Apache-2.0)

                                                                                                                                                                                                                                        Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases
                                                                                                                                                                                                                                        Support
                                                                                                                                                                                                                                          Quality
                                                                                                                                                                                                                                            Security
                                                                                                                                                                                                                                              License
                                                                                                                                                                                                                                                Reuse

                                                                                                                                                                                                                                                  dbt-ml-preprocessingby omnata-labs

                                                                                                                                                                                                                                                  Python doticonstar image 162 doticonVersion:1.1.0doticon
                                                                                                                                                                                                                                                  License: Permissive (MIT)

                                                                                                                                                                                                                                                  A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.

                                                                                                                                                                                                                                                  Support
                                                                                                                                                                                                                                                    Quality
                                                                                                                                                                                                                                                      Security
                                                                                                                                                                                                                                                        License
                                                                                                                                                                                                                                                          Reuse

                                                                                                                                                                                                                                                            dbt-ml-preprocessingby omnata-labs

                                                                                                                                                                                                                                                            Python doticon star image 162 doticonVersion:1.1.0doticon License: Permissive (MIT)

                                                                                                                                                                                                                                                            A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.
                                                                                                                                                                                                                                                            Support
                                                                                                                                                                                                                                                              Quality
                                                                                                                                                                                                                                                                Security
                                                                                                                                                                                                                                                                  License
                                                                                                                                                                                                                                                                    Reuse

                                                                                                                                                                                                                                                                      See similar Kits and Libraries