Open Source Python Database Software - Page 3
Sort By:
Python Database Software
View 477 business solutionsBrowse free open source Python Database Software and projects below. Use the toggles on the left to filter open source Python Database Software by OS, license, language, programming language, and project status.
-
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
Veeam Data Platform v13.1 - Get Your Free TrialTry Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
-
1
Python module for reading and writing DBF files. Originally it was created by Jeff Kunce and later maintained by Hans Fiby.
-
2
Pigeon Planner
Organise and manage your pigeons
Pigeon Planner aims to be a simple to use pigeon database. Add, edit, remove pigeons and view their details such as name, image, sex, colour, pedigree, relatives and results in the user-friendly interface. -
3
SQLObject
SQLObject is a Python ORM.
SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.7. -
4
Database connection pool with support for lots of languages and databases.
-
Earn up to 16% annual interest with Nexo.Generate interest, access liquidity without selling, and execute trades seamlessly. All in one platform. Geographic restrictions, eligibility, and terms apply.
-
5
e4Graph is a C++ library and a Tcl binding providing persistent, reliable, cross-platform storage for graph like structures. Please visit http://e4graph.sourceforge.net for more info.
-
6
Python DB-API 2.0 module for ADO
Use Microsoft ADO to read/write most data bases.
Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources. For CPython users, this module is included as part of pywin32 (https://github.com/mhammond/pywin32), and continued support will take place there. This fork will be maintained for Iron Python users. * Documentation at http://adodbapi.sourceforge.net/quick_reference.pdf or quick_reference.odb in the .zip -
7
Aerich
A database migrations tool for TortoiseORM, ready to production
Aerich is a lightweight database migration tool built for Tortoise ORM, an async ORM for Python. It handles schema evolution through versioned migrations, enabling developers to update and rollback database changes with ease. Designed for asyncio-based applications, Aerich is ideal for fast-moving Python projects that need simple migration control without heavy dependencies. -
8
Bracket
Selfhosted tournament system
Bracket is an open-source tool that tracks and manages data access across your PostgreSQL database. It provides visibility into which parts of your codebase are accessing which tables and columns, enabling data governance, security auditing, and architectural insights. Bracket is particularly helpful for growing teams needing better observability in complex applications. -
9
Cinemagoer
Python package useful to retrieve and manage the data of IMDb
Cinemagoer (previously known as IMDbPY) is a Python package for retrieving and managing the data of the IMDb movie database about movies and people. You can use the search_movie method of the access object to search for movies with a given (or similar) title. Similarly, you can search for people and companies using the search_person and the search_company methods. Movie, person, and company objects have id attributes which -when fetched through the IMDb web server- store the IMDb id of the object. If you know the IMDb id of a movie, you can use the get_movie method to retrieve its data. It’s possible to retrieve the list of top 250 and bottom 100 movies. As on the IMDb site, each TV series and also each of a TV series’ episodes is treated as a regular title, just like a movie. The episodes of a series can be fetched using the “episodes” infoset. -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
10
ERAlchemy
Entity Relation Diagrams generation tool
ERAlchemy is a tool that generates Entity-Relationship (ER) diagrams from databases or SQLAlchemy models and vice versa. It’s useful for database documentation, reverse engineering, and understanding complex schemas. ERAlchemy can export diagrams in formats like Graphviz and Mermaid, making it easy to include in reports or markdown files. -
11
Entity relation diagrams generator
Entity Relation Diagrams generation tool
ERAlchemy generates Entity Relation (ER) diagram from databases or from SQLAlchemy models. The simplest way to install eralchemy on OSX is by using Homebrew. ERAlchemy requires GraphViz to generate the graphs and Python. Both are available for Windows, Mac and Linux. Thanks to it's modular architecture, it can be connected to other ORMs/ODMs/OGMs/O*Ms. Some tests require a local postgres database with a schema named test in a database named test all owned by a user named postgres with a password of postgres. ERAlchemy was inspired by erd, though it is able to render the ER diagram directly from the database and not just only from the ER markup language. -
12
Full Stack FastAPI and PostgreSQL
Full stack, modern web application generator
Generate a backend and frontend stack using Python, including interactive API documentation. Production ready Python web server using Uvicorn and Gunicorn. Very high performance, on par with NodeJS and Go (thanks to Starlette and Pydantic). Great editor support. Completion everywhere. Less time debugging. Designed to be easy to use and learn. Less time reading docs. Minimize code duplication. Multiple features from each parameter declaration. Get production-ready code. With automatic interactive documentation. Many other features including automatic validation, serialization, interactive documentation, authentication with OAuth2 JWT tokens, etc. Celery worker that can import and use models and code from the rest of the backend selectively. REST backend tests based on Pytest, integrated with Docker, so you can test the full API interaction, independent on the database. As it runs in Docker, it can build a new data store from scratch each time. -
13
NoSQLMap
Automated NoSQL database enumeration and web application exploitation
A security tool for detecting and exploiting vulnerabilities in NoSQL databases, similar to SQLMap for traditional databases. -
14
ODMantic
Sync and Async ODM (Object Document Mapper) for MongoDB
Odmantic is an Object-Document Mapper (ODM) for MongoDB, designed for Python applications using Pydantic models, providing a seamless integration with type safety and validation. -
15
Records
Records is a simple, but powerful, library for making raw SQL queries
Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. A command-line utility allows SQL queries and exports to be performed outside Python code. The library focuses on keeping raw SQL workflows concise and readable. -
16
SQLModel
SQL databases in Python, designed for simplicity, compatibility
SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust. SQLModel is based on Python-type annotations, and powered by Pydantic and SQLAlchemy. -
17
SuperDuperDB
Integrate, train and manage any AI models and APIs with your database
Build and manage AI applications easily without needing to move your data to complex pipelines and specialized vector databases. Integrate AI and vector search directly with your database including real-time inference and model training. Just using Python. A single scalable deployment of all your AI models and APIs which is automatically kept up-to-date as new data is processed immediately. No need to introduce an additional database and duplicate your data to use vector search and build on top of it. SuperDuperDB enables vector search in your existing database. Integrate and combine models from Sklearn, PyTorch, HuggingFace with AI APIs such as OpenAI to build even the most complex AI applications and workflows. Train models on your data in your datastore simply by querying without additional ingestion and pre-processing. -
18
WikiSQL
A large annotated semantic parsing corpus for developing NL interfaces
A large crowd-sourced dataset for developing natural language interfaces for relational databases. WikiSQL is the dataset released along with our work Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning. Regarding tokenization and Stanza, when WikiSQL was written 3-years ago, it relied on Stanza, a CoreNLP python wrapper that has since been deprecated. If you'd still like to use the tokenizer, please use the docker image. We do not anticipate switching to the current Stanza as changes to the tokenizer would render the previous results not reproducible. -
19
mssql-cli
A command-line client for SQL Server with auto-completion
mssql-cli is an interactive command line query tool for SQL Server. This open-source tool works cross-platform and is proud to be a part of the dbcli community. mssql-cli supports a rich interactive command line experience, with features such as auto-completion, fewer keystrokes needed to complete complicated queries. Syntax highlighting, highlights T-SQL keywords. Query history, easily complete an auto-suggested query that was previously executed. Configuration file support, customize the mssql-cli experience for your needs. Multi-line queries, execute multiple queries at once using the multi-line edit mode. Non-interactive support, execute a query without jumping into the interactive experience. -
20
pg_probackup
Backup and recovery manager for PostgreSQL
pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments. -
21
pgai
A suite of tools to develop RAG, semantic search, and other AI apps
pgai is a suite of PostgreSQL extensions developed by Timescale to empower developers in building AI applications directly within their databases. It integrates tools for vector storage, advanced indexing, and AI model interactions, facilitating the development of applications like semantic search and Retrieval-Augmented Generation (RAG) without leaving the SQL environment. -
22
pgsync
Postgres to Elasticsearch/OpenSearch sync
pgsync is a lightweight tool for syncing Postgres databases across environments, such as from production to staging. It allows selective table syncing, data masking, and parallel copying for fast and safe data migration. pgsync is ideal for developers who need realistic test data without exposing sensitive information. -
23
tccutil.py
Command line tool to modify OS X's accessibility database (TCC.db)
Apple has a utility in /usr/bin named tccutil, but it only supports one command, which is to reset the entire database. It has been like this for many versions of macOS. I wanted a command-line utility that would be able to add, remove, list, and take other actions. This tool needs SIP disabled in order to function. The risk of doing so is up to you. tccutil.py can be installed without any additional software. Depending how you have your $PATH variable setup, you can simply type tccutil (instead of the full path) and it will run this utility instead of Apple's. This utility needs super-user priveleges for most operations. It is important that you either run this as root or use sudo, otherwise it won't work and you will end up with “permission denied” errors. -
24
MyDBF2MySQL
Extract, transform, and load DBF into MySQL
This is an ETL software which loads data from DBF/XBase files into MySQL. This utility has command line interface, designed to work without user interaction. -
25
"Project EROS" is a collection of software which includes a web application framework for developing intranet and extranet applications (bbsengine), as well as example applications to demonstrate the available functionality.
