13 best Python SQL Database libraries in 2025
by marketing.admin@openweaver.com Updated: Feb 11, 2023
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
Automatic SQL injection and database takeover tool
sqlmapby sqlmapproject
Python
27305
Version:1.7
License: Others (Non-SPDX)
qby harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
qby harelba
Python
9880
Version:latest
License: Strong Copyleft (GPL-3.0)
sqlmodelby tiangolo
SQL databases in Python, designed for simplicity, compatibility, and robustness.
sqlmodelby tiangolo
Python
10021
Version:0.0.8
License: Permissive (MIT)
bayesliteby probcomp
BayesDB on SQLite. A Bayesian database table for querying the probable implications of data as easily as SQL databases query the data itself.
bayesliteby probcomp
Python
882
Version:Current
License: Permissive (Apache-2.0)
azure-sql-database-samplesby Azure
Azure SQL Database Samples and Reference Implementation Repository
azure-sql-database-samplesby Azure
Python
745
Version:Current
License: Others (Non-SPDX)
etlalchemyby seanharr11
Extract, Transform, Load: Any SQL Database in 4 lines of Code.
etlalchemyby seanharr11
Python
467
Version:1.1.1
License: Permissive (MIT)
hueby cloudera
Open source SQL Query Assistant service for Databases/Warehouses
hueby cloudera
JavaScript
878
Version:release-4.11.0
License: Permissive (Apache-2.0)
GodMode2by vas3k
Semi-automatic admin site generator for any SQL database
GodMode2by vas3k
CSS
261
Version:Current
License: Permissive (WTFPL)
db-to-sqliteby simonw
CLI tool for exporting tables or queries from any SQL database to a SQLite file
db-to-sqliteby simonw
Python
292
Version:1.5
License: Permissive (Apache-2.0)
pythonqlby pythonql
A Query Language extension for Python: Query files, objects, SQL and NoSQL databases with a built-in query language
pythonqlby pythonql
Python
205
Version:v2-0.9.51
License: Others (Non-SPDX)
queryby boydgreenfield
Interactive SQL database exploration in Python
queryby boydgreenfield
Python
175
Version:v0.1.3
License: Permissive (MIT)
CueObserveby cuebook
Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases
CueObserveby cuebook
Python
144
Version:v0.3.2
License: Permissive (Apache-2.0)
dbt-ml-preprocessingby omnata-labs
A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.
dbt-ml-preprocessingby omnata-labs
Python
162
Version:1.1.0
License: Permissive (MIT)