13 best Python SQL Database libraries in 2024
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)