[Go to site: main page, start]

Python Database

Open-source Python projects categorized as Database

Top 23 Python Database Projects

  1. 30-Days-Of-Python

    The 30 Days of Python programming challenge is a step-by-step guide to learn the Python programming language in 30 days. This challenge may take more than 100 days. Follow your own pace. These videos may help too: https://www.youtube.com/channel/UC7PNRuno1rzYPb1xLa4yktw

    Project mention: Free Python Resources | dev.to | 2026-01-16

    A free, beginner‑friendly programming challenge on GitHub, 30 Days of Python breaks down the process of learning Python into daily lessons and exercises that guide you step by step from the basics to more advanced concepts.

  2. SaaSHub

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

    SaaSHub logo
  3. quivr

    Opiniated RAG for integrating GenAI in your apps 🧠 Focus on your product rather than the RAG. Easy integration in existing products with customisation! Any LLM: GPT4, Groq, Llama. Any Vectorstore: PGVector, Faiss. Any Files. Anyway you want.

  4. SQLMap

    Automatic SQL injection and database takeover tool

  5. pandas-ai

    Chat with your database or your datalake (SQL, CSV, parquet). PandasAI makes data analysis conversational using LLMs and RAG.

    Project mention: 📰 All Data and AI Weekly #231-02March2026 | dev.to | 2026-03-02

    Pandas-AI: Talk to your dataframes in natural language.

  6. DB-GPT

    open-source agentic AI data assistant for the next generation of AI + Data products.

    Project mention: Launch HN: Gecko Security (YC F24) – AI That Finds Vulnerabilities in Code | news.ycombinator.com | 2025-08-01

    Yes, that's exactly what we do. Some examples: https://github.com/eosphoros-ai/DB-GPT/pull/2650, https://github.com/dagster-io/dagster/pull/30002

    We just need to follow responsible disclosure first by notifying the maintainers, working with them on a fix, and making it public once it is resolved.

  7. gel

    Gel supercharges Postgres with a modern data model, graph queries, Auth & AI solutions, and much more. (by geldata)

  8. pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: pgxcli VS pgcli - a user suggested alternative | libhunt.com/r/pgxcli | 2026-05-01

    I primarily use psql for quick queries, but pgcli is definitely what I'd reach for when I want a richer terminal experience. The autocompletion and syntax highlighting save time. That said, pgxcli's zero-dependency approach is compelling — if you're in environments where Python setup is friction (containers, minimal systems), it's worth trying. The startup speed difference is noticeable too. Ultimately, both are solid; it comes down to whether you prefer Python's maturity or Go's simplicity.

  9. mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    Project mention: Codex for Open Source | news.ycombinator.com | 2026-06-13
  10. q

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

  11. FinanceDatabase

    This is a database of 300.000+ symbols containing Equities, ETFs, Funds, Indices, Currencies, Cryptocurrencies and Money Markets.

  12. TinyDB

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

  13. ibis

    the portable Python dataframe library

    Project mention: Ibis | news.ycombinator.com | 2026-05-22
  14. superduper

    Superduper: End-to-end framework for building custom AI applications and agents.

  15. baserow

    Build databases, automations, apps & agents with AI — no code. Open source platform available on cloud and self-hosted. GDPR, HIPAA, SOC 2 compliant. Best Airtable alternative.

    Project mention: Baserow: Build databases, automations and agents with AI, Airtable alternative | news.ycombinator.com | 2026-01-03
  16. dataset

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

  17. sqlite-web

    Web-based SQLite database browser written in Python

    Project mention: ZeQLplus: Terminal SQLite Database Browser | news.ycombinator.com | 2025-06-28

    I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file.

    [1] https://github.com/coleifer/sqlite-web

  18. 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: Best Database Clients in 2026: Top SQL GUI Tools Compared | dev.to | 2026-06-04

    pgAdmin is the classic open-source administration and development platform for PostgreSQL. It can run on desktop platforms or as a web application.

  19. dataherald

    Interact with your SQL database, Natural Language to SQL using LLMs

  20. morphik-core

    The most accurate document search and store for building AI apps

    Project mention: Bear is now source-available | news.ycombinator.com | 2025-09-01

    We use a BSL for our product (https://morphik.ai) and usually stay away from calling it anything. We'd just say "repo is public at: https://github.com/morphik-org/morphik-core". I like the term fair source, though.

    Is it correct to assume that software than eventually becomes open under something like Apache or MIT is fair source? Or is there more subtlety to it?

  21. garmin-grafana

    A Dockerized python Script to fetch Garmin health data and populate that in a InfluxDB Database, for visualization long term health trends with Grafana

    Project mention: Unlock Your Garmin Data: Visualize Every Metric with a Self-Hosted Grafana Dashboard | dev.to | 2026-02-11

    View the Project on GitHub

  22. GarminDB

    Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.

    Project mention: Volkswagen blocks Home Assistant by requiring client assertion | news.ycombinator.com | 2026-05-28

    Same here. I've been scraping the data from my Garmin watch for years with very little problems (first with https://github.com/tcgoetz/GarminDB, then https://github.com/sealbro/dotnet.garmin.connect).

    The only annoyance is that Garmin requires 2FA if you enable the ECG feature on your smart watch/fitness tracker, but I have a small program that reads the 2FA codes from my Gmail inbox and supplies them to the scraper without too much trouble.

  23. arctic

    High performance datastore for time series and tick data

  24. tencent-ml-images

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

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).

Python Database discussion

Log in or Post with

Python Database related posts

  • Lie to the Postgres planner: EXPLAIN your query at 10,000 the rows

    1 project | dev.to | 17 Jun 2026
  • Don't parse SQL to make a query runner read-only

    1 project | dev.to | 16 Jun 2026
  • chDB is an in-process OLAP SQL Engine powered by ClickHouse

    1 project | news.ycombinator.com | 12 Jun 2026
  • Ask HN: Migrated from Pandas to Polars in a CSV cleaning project, went from 200s

    1 project | news.ycombinator.com | 11 Jun 2026
  • Ibis

    1 project | news.ycombinator.com | 22 May 2026
  • 5 Best Python Vector Database Libraries

    5 projects | dev.to | 18 May 2026
  • Build a RAG Pipeline That Actually Reads the Web

    2 projects | dev.to | 14 May 2026
  • A note from our sponsor - SaaSHub
    www.saashub.com | 17 Jun 2026
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

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

# Project Stars
1 30-Days-Of-Python 64,710
2 quivr 39,155
3 SQLMap 37,651
4 pandas-ai 23,583
5 DB-GPT 18,975
6 gel 14,099
7 pgcli 13,216
8 mycli 11,924
9 q 10,352
10 FinanceDatabase 7,893
11 TinyDB 7,529
12 ibis 6,574
13 superduper 5,289
14 baserow 5,044
15 dataset 4,865
16 sqlite-web 4,107
17 pgadmin4 3,667
18 dataherald 3,629
19 morphik-core 3,614
20 garmin-grafana 3,284
21 GarminDB 3,145
22 arctic 3,091
23 tencent-ml-images 3,077

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com

Did you know that Python is
the 1st most popular programming language
based on number of references?