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. 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
  3. SQLMap

    Automatic SQL injection and database takeover tool

    Project mention: How to Install and Use SQLmap on Android Termux | dev.to | 2025-04-25

    git clone https://github.com/sqlmapproject/sqlmap.git

  4. pandas-ai

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

    Project mention: PandaAI: Talk to Your Data, Not to Your Code! | dev.to | 2025-05-06

    View the Project on GitHub

  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

  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: What I Wish Someone Told Me About Postgres | news.ycombinator.com | 2024-11-12
  9. SaaSHub

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

    SaaSHub 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: Coding as Craft: Going Back to the Old Gym | news.ycombinator.com | 2025-04-22

    I felt the same - have to relearn/lookup everything every time I went back to a project or wanted to do some operations that are simple to describe in SQL but I couldn't wrap my mind around e.g. using multi-indexed dataframes & aggregations properly. These days, I always jump to Polars instead of Pandas - much more intuitive and consistent API. Tons of props to Pandas for all that they did (and continue to do) in the data space, but their API did not evolve very well IMO.

    I've also been wanting to play with Ibis[1] recently, but Polars has been sufficient for me.

    [1] https://ibis-project.org/

  14. superduper

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

    Project mention: Build fully portable AI applications on top of Snowflake with SuperDuperDB | dev.to | 2024-06-26

    Customize how AI and databases work together. Scale your AI projects to handle more data and users. Move AI projects between different environments easily. Extend the system with new AI features and database functionality. Check it out: Blog: https://blog.superduperdb.com/version-02 Github: https://github.com/SuperDuperDB/superduperdb (leave us a star ⭐️🥳)

  15. FinanceDatabase

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

  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

  18. dataherald

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

    Project mention: AIM Weekly 27 May 2024 | dev.to | 2024-05-28
  19. tencent-ml-images

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

  20. arctic

    High performance datastore for time series and tick data

  21. 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: From CSV to SQL: Importing CSV Real World Data into PostgreSQL. | dev.to | 2025-05-03

    Depending on your tools and environment, there are several options for importing data, from using a graphical tool like pgAdmin to a direct SQL query. For my case, I was using a locally hosted PostgreSQL, and found the command line to be convenient.

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

  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: Baserow 1.32: Dashboards, enhanced Airtable import, SSO for Application Builder, and more - Open Source Airtable Alternative | dev.to | 2025-03-19

    Try out Baserow 1.32: https://baserow.io

  24. evadb

    Database system for AI-powered apps

  25. 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: GarminDB | news.ycombinator.com | 2025-02-02
  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

  • Bidirectional Enhancement of Graph and Agent

    1 project | news.ycombinator.com | 4 May 2025
  • Chat2Graph: Graph Native Agentic System

    1 project | dev.to | 4 May 2025
  • From CSV to SQL: Importing CSV Real World Data into PostgreSQL.

    1 project | dev.to | 3 May 2025
  • Show HN: Morphik – Open-source MCP server for technical document search

    1 project | news.ycombinator.com | 6 Apr 2025
  • Ask HN: What RAG evaluations do you care about?

    1 project | news.ycombinator.com | 4 Apr 2025
  • Show HN: I built an open-source NotebookLM alternative using Morphik

    2 projects | news.ycombinator.com | 30 Mar 2025
  • XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal

    6 projects | news.ycombinator.com | 27 Mar 2025
  • A note from our sponsor - SaaSHub
    www.saashub.com | 21 May 2025
    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 quivr 37,875
2 SQLMap 34,136
3 pandas-ai 20,204
4 vanna 17,655
5 DB-GPT 16,512
6 gel 13,655
7 pgcli 12,438
8 mycli 11,636
9 q 10,282
10 TinyDB 7,114
11 ibis 5,759
12 superduper 5,058
13 FinanceDatabase 4,920
14 dataset 4,798
15 sqlite-web 3,698
16 dataherald 3,495
17 tencent-ml-images 3,067
18 arctic 3,065
19 pgadmin4 2,927
20 PyPika 2,673
21 baserow 2,672
22 evadb 2,670
23 GarminDB 2,430

Sponsored
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.
www.influxdata.com

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