Python Database

Open-source Python projects categorized as Database

Top 23 Python Database Projects

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

    Project mention: Ask HN: Local RAG with private knowledge base | news.ycombinator.com | 2024-10-29
  2. Sevalla

    Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

    Sevalla logo
  3. SQLMap

    Automatic SQL injection and database takeover tool

    Project mention: 🛡️ Examining the Database in SQL Injection Attacks | dev.to | 2025-06-14

    SQLMap Project

  4. pandas-ai

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

    Project mention: Pandas AI | news.ycombinator.com | 2025-07-18
  5. vanna

    🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

    Project mention: Supercharging Obsidian Search with AI and Ollama | dev.to | 2024-11-26

    Essentially this solution is to let the AI *formulate the search* expression and not do the search itself (similar to the concept of generating a SQL statement instead of executing it https://github.com/vanna-ai/vanna).

  6. DB-GPT

    AI Native Data App Development framework with AWEL(Agentic Workflow Expression Language) and Agents

    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)

    Project mention: EdgeDB is now Gel and Postgres is the Future | news.ycombinator.com | 2025-02-25

    [2] https://github.com/geldata/gel/issues/4228#issuecomment-1208...

  8. pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: PostgreSQL IDE in VS Code | news.ycombinator.com | 2025-05-23
  9. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  10. mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    Project mention: SQLiteStudio: Create, edit, browse SQLite databases | news.ycombinator.com | 2024-11-24

    One day I set out to resolve this, though I can not find in my notes' files what the solution was (for MySQL). It might have been to simply use MyCLI instead of the standard MySQL CLI. Have you tried it?

    https://github.com/dbcli/mycli

  11. q

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

    Project mention: XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal | news.ycombinator.com | 2025-03-27

    I used to use q for this sort of thing. Not sure if there are better choices now as it have been a few years.

    https://harelba.github.io/q/

  12. TinyDB

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

  13. ibis

    the portable Python dataframe library

    Project mention: Why Pandas feels clunky when coming from R (2024) | news.ycombinator.com | 2025-06-07

    pandas* per the style guide (nobody follows it)

    also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues

    https://ibis-project.org

  14. FinanceDatabase

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

  15. superduper

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

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

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

  19. morphik-core

    The most accurate document search and store for building AI apps

    Project mention: Show HN: Morphik – Open-source RAG that understands PDF images, runs locally | news.ycombinator.com | 2025-04-22
  20. 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: Asynchronous SQLAlchemy 2: A simple step-by-step guide to configuration, models, relationships, and migrations using Alembic | dev.to | 2025-06-03

    Go to the official PGAdmin website and download the latest version.

  21. tencent-ml-images

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

  22. arctic

    High performance datastore for time series and tick data

  23. baserow

    The official repository is hosted on https://gitlab.com/bramw/baserow. Baserow is an open source no-code database tool and Airtable alternative.

    Project mention: 8 No-Code Tools to Build a CRM(Open Source & SaaS Compared) | dev.to | 2025-08-05

    Website: https://baserow.io

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

    Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24

    PyPika: I don't know much about this one.

  25. evadb

    Database system for AI-powered apps

  26. SaaSHub

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

    SaaSHub logo
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

  • Jepsen‑style chaos CI before clustering

    1 project | news.ycombinator.com | 25 Aug 2025
  • Show HN: AgentState – Lightweight state manager for multi-agent AI workflows

    1 project | news.ycombinator.com | 22 Aug 2025
  • Updates on a project I am passionate about- Darnahi

    1 project | news.ycombinator.com | 9 Aug 2025
  • Launch HN: Gecko Security (YC F24) – AI That Finds Vulnerabilities in Code

    2 projects | news.ycombinator.com | 1 Aug 2025
  • Open Source Multimodal Semantic Search

    1 project | news.ycombinator.com | 15 Jul 2025
  • How I Built an Agentic RAG Application to Brainstorm Conference Talk Ideas

    4 projects | dev.to | 8 Jul 2025
  • Show HN: Open-Source Multimodal Semantic Search Framework

    1 project | news.ycombinator.com | 7 Jul 2025
  • A note from our sponsor - Sevalla
    sevalla.com | 1 Sep 2025
    Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more! Learn more →

Index

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

# Project Stars
1 quivr 38,352
2 SQLMap 35,147
3 pandas-ai 21,882
4 vanna 20,094
5 DB-GPT 17,215
6 gel 13,836
7 pgcli 12,612
8 mycli 11,686
9 q 10,312
10 TinyDB 7,259
11 ibis 6,065
12 FinanceDatabase 5,413
13 superduper 5,158
14 dataset 4,810
15 sqlite-web 3,819
16 dataherald 3,530
17 morphik-core 3,154
18 pgadmin4 3,118
19 tencent-ml-images 3,072
20 arctic 3,070
21 baserow 2,851
22 PyPika 2,717
23 evadb 2,687

Sponsored
Deploy and host your apps and databases, now with $50 credit!
Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
sevalla.com

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