15 best Python Database libraries in 2024

share link

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

technology logo
technology logo

Guide Kit Guide Kit  

The Python database libraries are a set of packages that abstract away the complexity of database access, so you can focus on what your application requires. SQLmap is an open source tool that automates the process of finding vulnerabilities in web applications by listening on port 80 and searching for specific strings in web pages. It can be used to find any type of issue in the database and even inject commands into the application, resulting in a successful exploitation. But there are other tools like edgedb or sqlmodel that can help you automate the entire process of finding vulnerabilities in your database. Popular open source Python database libraries among developers include

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

                      fashion-mnistby zalandoresearch

                      Python doticonstar image 10843 doticonVersion:Currentdoticon
                      License: Permissive (MIT)

                      A MNIST-like fashion product database. Benchmark :point_down:

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                fashion-mnistby zalandoresearch

                                Python doticon star image 10843 doticonVersion:Currentdoticon License: Permissive (MIT)

                                A MNIST-like fashion product database. Benchmark :point_down:
                                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

                                                              edgedbby edgedb

                                                              Python doticonstar image 11190 doticonVersion:v2.12doticon
                                                              License: Permissive (Apache-2.0)

                                                              A graph-relational database with declarative schema, built-in migration system, and a next-generation query language

                                                              Support
                                                                Quality
                                                                  Security
                                                                    License
                                                                      Reuse

                                                                        edgedbby edgedb

                                                                        Python doticon star image 11190 doticonVersion:v2.12doticon License: Permissive (Apache-2.0)

                                                                        A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
                                                                        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

                                                                                                      mindsdbby mindsdb

                                                                                                      Python doticonstar image 16605 doticonVersion:v23.6.3.1doticon
                                                                                                      License: Strong Copyleft (GPL-3.0)

                                                                                                      MindsDB is a Server for Artificial Intelligence Logic. Enabling developers to ship AI powered projects to production in a fast and scalable way.

                                                                                                      Support
                                                                                                        Quality
                                                                                                          Security
                                                                                                            License
                                                                                                              Reuse

                                                                                                                mindsdbby mindsdb

                                                                                                                Python doticon star image 16605 doticonVersion:v23.6.3.1doticon License: Strong Copyleft (GPL-3.0)

                                                                                                                MindsDB is a Server for Artificial Intelligence Logic. Enabling developers to ship AI powered projects to production in a fast and scalable way.
                                                                                                                Support
                                                                                                                  Quality
                                                                                                                    Security
                                                                                                                      License
                                                                                                                        Reuse

                                                                                                                          asyncpgby MagicStack

                                                                                                                          Python doticonstar image 6034 doticonVersion:v0.27.0doticon
                                                                                                                          License: Permissive (Apache-2.0)

                                                                                                                          A fast PostgreSQL Database Client Library for Python/asyncio.

                                                                                                                          Support
                                                                                                                            Quality
                                                                                                                              Security
                                                                                                                                License
                                                                                                                                  Reuse

                                                                                                                                    asyncpgby MagicStack

                                                                                                                                    Python doticon star image 6034 doticonVersion:v0.27.0doticon License: Permissive (Apache-2.0)

                                                                                                                                    A fast PostgreSQL Database Client Library for Python/asyncio.
                                                                                                                                    Support
                                                                                                                                      Quality
                                                                                                                                        Security
                                                                                                                                          License
                                                                                                                                            Reuse

                                                                                                                                              sqlalchemyby sqlalchemy

                                                                                                                                              Python doticonstar image 7352 doticonVersion:rel_2_0_16doticon
                                                                                                                                              License: Permissive (MIT)

                                                                                                                                              The Database Toolkit for Python

                                                                                                                                              Support
                                                                                                                                                Quality
                                                                                                                                                  Security
                                                                                                                                                    License
                                                                                                                                                      Reuse

                                                                                                                                                        sqlalchemyby sqlalchemy

                                                                                                                                                        Python doticon star image 7352 doticonVersion:rel_2_0_16doticon License: Permissive (MIT)

                                                                                                                                                        The Database Toolkit for Python
                                                                                                                                                        Support
                                                                                                                                                          Quality
                                                                                                                                                            Security
                                                                                                                                                              License
                                                                                                                                                                Reuse

                                                                                                                                                                  tinydbby msiemens

                                                                                                                                                                  Python doticonstar image 5899 doticonVersion:v4.7.1doticon
                                                                                                                                                                  License: Permissive (MIT)

                                                                                                                                                                  TinyDB is a lightweight document oriented database optimized for your happiness :)

                                                                                                                                                                  Support
                                                                                                                                                                    Quality
                                                                                                                                                                      Security
                                                                                                                                                                        License
                                                                                                                                                                          Reuse

                                                                                                                                                                            tinydbby msiemens

                                                                                                                                                                            Python doticon star image 5899 doticonVersion:v4.7.1doticon License: Permissive (MIT)

                                                                                                                                                                            TinyDB is a lightweight document oriented database optimized for your happiness :)
                                                                                                                                                                            Support
                                                                                                                                                                              Quality
                                                                                                                                                                                Security
                                                                                                                                                                                  License
                                                                                                                                                                                    Reuse

                                                                                                                                                                                      bigchaindbby bigchaindb

                                                                                                                                                                                      Python doticonstar image 3974 doticonVersion:v2.2.2doticon
                                                                                                                                                                                      License: Permissive (Apache-2.0)

                                                                                                                                                                                      Meet BigchainDB. The blockchain database.

                                                                                                                                                                                      Support
                                                                                                                                                                                        Quality
                                                                                                                                                                                          Security
                                                                                                                                                                                            License
                                                                                                                                                                                              Reuse

                                                                                                                                                                                                bigchaindbby bigchaindb

                                                                                                                                                                                                Python doticon star image 3974 doticonVersion:v2.2.2doticon License: Permissive (Apache-2.0)

                                                                                                                                                                                                Meet BigchainDB. The blockchain database.
                                                                                                                                                                                                Support
                                                                                                                                                                                                  Quality
                                                                                                                                                                                                    Security
                                                                                                                                                                                                      License
                                                                                                                                                                                                        Reuse

                                                                                                                                                                                                          dj-database-urlby jacobian

                                                                                                                                                                                                          Python doticonstar image 1184 doticonVersion:Currentdoticon
                                                                                                                                                                                                          License: Permissive (BSD-2-Clause)

                                                                                                                                                                                                          Use Database URLs in your Django Application.

                                                                                                                                                                                                          Support
                                                                                                                                                                                                            Quality
                                                                                                                                                                                                              Security
                                                                                                                                                                                                                License
                                                                                                                                                                                                                  Reuse

                                                                                                                                                                                                                    dj-database-urlby jacobian

                                                                                                                                                                                                                    Python doticon star image 1184 doticonVersion:Currentdoticon License: Permissive (BSD-2-Clause)

                                                                                                                                                                                                                    Use Database URLs in your Django Application.
                                                                                                                                                                                                                    Support
                                                                                                                                                                                                                      Quality
                                                                                                                                                                                                                        Security
                                                                                                                                                                                                                          License
                                                                                                                                                                                                                            Reuse

                                                                                                                                                                                                                              safety-dbby pyupio

                                                                                                                                                                                                                              Python doticonstar image 636 doticonVersion:Currentdoticon
                                                                                                                                                                                                                              License: Others (Non-SPDX)

                                                                                                                                                                                                                              A curated database of insecure Python packages

                                                                                                                                                                                                                              Support
                                                                                                                                                                                                                                Quality
                                                                                                                                                                                                                                  Security
                                                                                                                                                                                                                                    License
                                                                                                                                                                                                                                      Reuse

                                                                                                                                                                                                                                        safety-dbby pyupio

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

                                                                                                                                                                                                                                        A curated database of insecure Python packages
                                                                                                                                                                                                                                        Support
                                                                                                                                                                                                                                          Quality
                                                                                                                                                                                                                                            Security
                                                                                                                                                                                                                                              License
                                                                                                                                                                                                                                                Reuse

                                                                                                                                                                                                                                                  django-db-mailerby LPgenerator

                                                                                                                                                                                                                                                  Python doticonstar image 241 doticonVersion:2.4.0doticon
                                                                                                                                                                                                                                                  License: Strong Copyleft (GPL-2.0)

                                                                                                                                                                                                                                                  Django module to easily send emails/sms/tts/push using django templates stored on database and managed through the Django Admin

                                                                                                                                                                                                                                                  Support
                                                                                                                                                                                                                                                    Quality
                                                                                                                                                                                                                                                      Security
                                                                                                                                                                                                                                                        License
                                                                                                                                                                                                                                                          Reuse

                                                                                                                                                                                                                                                            django-db-mailerby LPgenerator

                                                                                                                                                                                                                                                            Python doticon star image 241 doticonVersion:2.4.0doticon License: Strong Copyleft (GPL-2.0)

                                                                                                                                                                                                                                                            Django module to easily send emails/sms/tts/push using django templates stored on database and managed through the Django Admin
                                                                                                                                                                                                                                                            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

                                                                                                                                                                                                                                                                                          osrsbox-dbby osrsbox

                                                                                                                                                                                                                                                                                          Python doticonstar image 194 doticonVersion:Currentdoticon
                                                                                                                                                                                                                                                                                          License: Strong Copyleft (GPL-3.0)

                                                                                                                                                                                                                                                                                          A complete and up-to-date database of Old School Runescape (OSRS) items, monsters and prayers

                                                                                                                                                                                                                                                                                          Support
                                                                                                                                                                                                                                                                                            Quality
                                                                                                                                                                                                                                                                                              Security
                                                                                                                                                                                                                                                                                                License
                                                                                                                                                                                                                                                                                                  Reuse

                                                                                                                                                                                                                                                                                                    osrsbox-dbby osrsbox

                                                                                                                                                                                                                                                                                                    Python doticon star image 194 doticonVersion:Currentdoticon License: Strong Copyleft (GPL-3.0)

                                                                                                                                                                                                                                                                                                    A complete and up-to-date database of Old School Runescape (OSRS) items, monsters and prayers
                                                                                                                                                                                                                                                                                                    Support
                                                                                                                                                                                                                                                                                                      Quality
                                                                                                                                                                                                                                                                                                        Security
                                                                                                                                                                                                                                                                                                          License
                                                                                                                                                                                                                                                                                                            Reuse

                                                                                                                                                                                                                                                                                                              See similar Kits and Libraries