Open Source Databases using Python

A curated collection of the best free and open source databases and the tools around them, covering relational, document, vector and time series engines plus the clients to work with them using Python.

Elasticsearch

Distributed search and analytics engine and vector database for full text search, logs, metrics, security data and retrieval augmented generation.

Alternative to:

Splunk

The leading distributed search and analytics engine

Stars
78,421
Forks
26,146
Last commit
18 hours ago

Milvus

Distributed vector database for AI applications, built to search billions of embeddings with metadata filtering, hybrid queries and hardware acceleration.

Alternative to:

Pinecone

High-performance vector database for GenAI applications

Stars
46,508

Qdrant

Alternative to:

Pinecone

Fast, scalable vector database for AI applications

Stars
35,287

Chroma

An embeddings database for AI applications, with an API of four functions and an in-memory mode that needs no server.

Alternative to:

Pinecone

Open-source vector database for AI search and retrieval

Stars
29,595

InfluxDB

Time series database for real-time events and monitoring, built on Apache Arrow, DataFusion and Parquet for quick queries.

Alternative to:

Amazon Timestream

Purpose-built time series database for real-time systems

Stars
31,786

Turso

In-process SQL database written in Rust, compatible with SQLite and now carrying a Postgres frontend, for embedded workloads.

SQLite-compatible database for scalable multi-tenant applications

Stars
25,071
Forks
1,506
Last commit
16 hours ago

Beekeeper Studio

Cross-platform SQL editor and database manager for Linux, Mac and Windows, aimed at developers who want a fast, uncluttered client.

Alternative to:

DataGrip

Modern and intuitive SQL client for multiple databases

Stars
23,803

TimescaleDb

PostgreSQL extension for real-time analytics on time-series and event data, for teams that want speed without leaving Postgres.

Alternative to:

Amazon Timestream

Time-series database built on top of PostgreSQL

Stars
23,766

Instant

A realtime database you query from the client, giving app developers auth, permissions, storage, presence and offline caching out of the box.

Alternative to:

Firebase

Realtime client-side database for collaborative apps

Stars
10,561

Grist

A relational spreadsheet that combines spreadsheet flexibility with database structure, for teams organizing data that outgrew a plain sheet.

Alternative to:

Airtable

Flexible spreadsheets with database power

Stars
12,002

FalkorDB

A multi-tenant property graph database for teams building knowledge graphs, agent memory and retrieval on Cypher queries.

Alternative to:

Amazon Neptune

Graph database built on sparse matrices for knowledge graphs and GenAI

Stars
10,497

Databend

Rust data warehouse combining analytics, vector search and full-text search for enterprise teams running agents on their own data.

Alternative to:

Amazon Redshift

Cloud-native data warehouse for lightning-fast analytics

Stars
9,485

Activeloop

Database for AI that stores raw data and vectors together, aimed at teams building LLM apps and training deep learning models.

Alternative to:

Pinecone

The tensor database for AI data

Stars
9,260

HelixDB

A graph and vector database written in Rust, for developers building AI memory, knowledge graphs and retrieval without stitching several stores together.

Alternative to:

Pinecone

Unify vector search and graph traversals in one database

Stars
6,239

GreptimeDB

A columnar database storing metrics, logs and traces on one engine, for teams running Prometheus, Loki and Elasticsearch side by side.

Alternative to:

Datadog

Unified observability database for metrics, logs, and traces

Stars
6,768

Tabularis

A desktop SQL workspace for PostgreSQL, MySQL and SQLite whose built-in MCP server lets AI agents read schemas and run queries.

Alternative to:

DataGrip

Desktop SQL client with built-in MCP for AI agent access

Stars
5,313

Mathesar

Spreadsheet-like web interface for PostgreSQL that lets users of any skill level view, edit, query and collaborate on data directly.

Alternative to:

Airtable

Spreadsheet-like interface for PostgreSQL databases

Stars
5,166

Apache Cloudberry

A massively parallel PostgreSQL-based data warehouse from the original Greenplum developers, built for large-scale analytics and AI workloads.

Alternative to:

Amazon Redshift

Unlock Data's Potential with Open Source Power

Stars
1,436

Stars
Forks
Last commit

Stars
Forks
Last commit

Stars
Forks
Last commit

Stars
Forks
Last commit

Stars
Forks
Last commit

Stars
Forks
Last commit

Open Source Databases using Python

A curated collection of the best free and open source databases and the tools around them, covering relational, document, vector and time series engines plus the clients to work with them using Python.

Elasticsearch

Milvus

Qdrant

Chroma

InfluxDB

Turso

Beekeeper Studio

TimescaleDb

Instant

Grist

FalkorDB

Databend

Activeloop

HelixDB

GreptimeDB

Tabularis

Mathesar

Apache Cloudberry

Elasticsearch

Milvus

Qdrant

Chroma

InfluxDB

Turso

Beekeeper Studio

TimescaleDb

Instant

Grist

FalkorDB

Databend

Activeloop

HelixDB

GreptimeDB

Tabularis

Mathesar

Apache Cloudberry

Spacedrive