Python Database

Open-source Python projects categorized as Database

Top 23 Python Database Projects

  • SQLMap

    Automatic SQL injection and database takeover tool

    Project mention: Are these good projects to have? (appsec) | /r/cybersecurity | 2023-06-04

    Sounds good, why not try making a simple vulnerability scanner for APIs too? Maybe something similar to SQLMap

  • edgedb

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

    Project mention: DuckDB 0.8.0 | | 2023-05-17

    >relational no-sql

    Do you mean something like edgeDB?[0]

    Or do you mean some non-declarative language completely? I don't see the latter making much sense. The issue with SQL for me is the "natural language" which quickly loses all intended readabilty when you have SELECT col1, col2 FROM (SELECT * FROM ... WHERE 1=0 AND ... which is what edgeDB is trying to solve.


  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

  • mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    Project mention: Does anyone prefer the CLI over the shell, or other way around? If so, why? | /r/mysql | 2023-04-23

    Also, check out MyCLI. "Terminal Client for MySQL with AutoCompletion and Syntax Highlighting"

  • q

    q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

    Project mention: I wrote this iCalendar (.ics) command-line utility to turn common calendar exports into more broadly compatible CSV files. | /r/commandline | 2023-03-24

    CSV utilities (still haven't pick a favorite one...):

  • TinyDB

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

    Project mention: How to make a GUI translator app with Python Tkinter | | 2023-02-16

    Here, we save app settings with Python tinydb and you can also use another simple database options. It is included because Python is used here.

  • dataset

    Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.

    Project mention: What's the best process for scraping w/ the process of: Webpage -> List of Items -> Scrape Each Item Page | /r/webscraping | 2023-01-31

    I use the package 'dataset' (, which lets you write a list of dictionaries as a database table. Easy peasy. :)

  • Sonar

    Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • DB-GPT

    Interact your data and environment using the local GPT, no data leaks, 100% privately, 100% security

    Project mention: (2/2) May 2023 | /r/dailyainews | 2023-06-02

    Interact your data and environment using the local GPT (

  • tencent-ml-images

    Largest multi-label image database; ResNet-101 model; 80.73% top-1 acc on ImageNet

  • arctic

    High performance datastore for time series and tick data

    Project mention: arctic: NEW Data - star count:2864.0 | /r/algoprojects | 2023-01-14
  • flask-base

    A simple Flask boilerplate app with SQLAlchemy, Redis, User Authentication, and more.

  • ibis

    The flexibility of Python with the scale and performance of modern SQL.

    Project mention: Thoughts About Snowpark? | /r/dataengineering | 2023-05-16

    Use Ibis and you won't have to worry about migrating to a vendor-specific python framework anymore. It connects to Snowflake, Spark, and many other engines you may want to interact with.

  • pyodbc

    Python ODBC bridge

    Project mention: Trying to deploy a windows based Python & Flask web app | /r/flask | 2023-04-26
  • data-diff

    Compare tables within or across databases

    Project mention: Oops, I wrote yet another SQLAlchemy alternative (looking for contributors!) | /r/pythoncoding | 2023-05-08

    First, let me introduce myself. My name is Erez. You may know some of the Python libraries I wrote in the past: Lark, Preql and Data-diff.

  • Flask-Migrate

    SQLAlchemy database migrations for Flask applications using Alembic

    Project mention: flask + postgres + sqlalchemy migrations dockerized intro | | 2022-08-31

    Flask-Migrate ( is the package that will help us do our migrations

  • PyPika

    PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

  • sandman2

    Automatically generate a RESTful API service for your legacy database. No code required!

    Project mention: Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs | | 2022-10-04 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.

  • CloudFail

    Utilize misconfigured DNS and old database records to find hidden IP's behind the CloudFlare network

  • sqlite-web

    Web-based SQLite database browser written in Python

    Project mention: WAL Mode in LiteFS | | 2023-01-04
  • codechecker

    CodeChecker is an analyzer tooling, defect database and viewer extension for the Clang Static Analyzer and Clang Tidy

    Project mention: A Python Script to connect to GitHub and Fetches Search Results | | 2023-02-10

    python3 docker-php-extension-installer: codechecker: SingleFileZ: china-dictatorship: vscode-docker: flask-bones: ProjectFib: S3Mock: home: docker-php: dockbix-xxl: wind-layer: powerstrip: selenium-jupiter: gnome-shell-extension-docker: hacktoberfest-2022: azure-docker-extension: pgrocks-fdw: docker-php-yii2: docker-community-extensions: alpine-php-fpm: autoview-tradingview-chrome-docker-bot: .config: docker-phpfpm: coc-docker: china-dictatorhsip-6: testcontainers-spock: Dockery: docker-extension: volumes-backup-extension: [email protected] chatgpt % vi [email protected] chatgpt % python3 .config: Dockery: docker-extension: ransomware: jfrog-docker-desktop-extension: dd-extension-lgtm: openshift-dd-ext: k9s-dd-extension: pgadmin4-docker-extension: trivy-docker-extension: drone-ci-docker-extension: docker-extension: swagger-editor-docker-extension: wasm-docker-extension: microcks-docker-desktop-extension: docker-extension-golang-playground: diveintoansible-extension: docker-desktop-extension: docker-extension-rabbitmq: docker-storj-extension: github-registry-docker-desktop-extension: docker-desktop-extension-issues: sdw-docker-extension: vcluster-dd-extension: extension-docker-desktop: asyncapi-studio-docker-extension: gefyra-docker-desktop-extension: oraclexe-docker-extension: docker-extensions-101: step-ca-docker-extension:

  • baserow

    Baserow is an open source no-code database tool and Airtable alternative. This is a mirrored repository, the official one is hosted on

    Project mention: I want to create sheets that work like Airtable ( and use it in my django application any suggestions on how it can be done. | /r/django | 2023-06-03

    And their code is open source: Link

  • pgadmin4

    pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

    Project mention: Is it worth learning sql on windows or should I try to get linux? | /r/SQL | 2023-05-05

    No need to use Linux to learn SQL. Download Postgres + Pgadmin on Windows - there is no difference with Linux or Macos, except for the file structure. Pgadmin is the GUI to handle the database, which is essentially a web service, and the GUI you see is nothing but a browser.

  • Orator

    The Orator ORM provides a simple yet beautiful ActiveRecord implementation.

    Project mention: Im writing a telegram bot that simulates the Uber apps. I would have to store the orders that receives so I can fulfill them. What’s the best way to store them so I can process them? | /r/TelegramBots | 2023-04-16

    If you write in Python, I recommend using the Orator-ORM library, a very handy thing for quickly and safely working with MySQL.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-06-04.

Python Database related posts


What are some of the best open-source Database projects in Python? This list will help you:

Project Stars
1 SQLMap 27,234
2 edgedb 11,153
3 pgcli 11,101
4 mycli 10,920
5 q 9,876
6 TinyDB 5,901
7 dataset 4,550
8 DB-GPT 3,551
9 tencent-ml-images 3,017
10 arctic 2,977
11 flask-base 2,887
12 ibis 2,774
13 pyodbc 2,677
14 data-diff 2,351
15 Flask-Migrate 2,205
16 PyPika 2,030
17 sandman2 1,947
18 CloudFail 1,886
19 sqlite-web 1,855
20 codechecker 1,835
21 baserow 1,567
22 pgadmin4 1,428
23 Orator 1,399
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives