1
sqlalchemy
Relational Databases
373,185,114
12,134
2026-09-04
Relational Databases
ORM
Database & Storage
→
The Python SQL Toolkit and Object Relational Mapper.
2
cachetools
Database & Storage
276,562,825
2,775
2026-08-31
Caching
Database & Storage
→
Extensible memoizing collections and decorators.
3
msgpack
Database & Storage
236,875,571
2,101
2026-09-02
Serialization
Database & Storage
→
MessagePack serializer implementation for Python.
4
redis
NoSQL Databases
228,305,087
13,626
2026-09-03
NoSQL Databases
Database Drivers
Database & Storage
→
The Python client for Redis.
5
orjson
Database & Storage
207,789,544
8,220
2026-08-14
Serialization
Database & Storage
→
Fast, correct JSON library.
6
psycopg
PostgreSQL
126,527,034
2,483
2026-08-31
PostgreSQL
Database Drivers
Database & Storage
→
The most popular PostgreSQL adapter for Python.
7
asyncpg
PostgreSQL
110,179,722
8,081
2026-02-27
PostgreSQL
Database Drivers
Database & Storage
→
A fast PostgreSQL Database Client Library for Python/asyncio.
8
marshmallow
Database & Storage
105,340,649
7,238
2026-09-01
Serialization
Database & Storage
→
A lightweight library for converting complex objects to and from simple Python datatypes.
9
pymongo
NoSQL Databases
87,412,244
4,355
2026-09-04
NoSQL Databases
Database Drivers
Database & Storage
→
The official Python client for MongoDB.
10
pymysql
MySQL
87,168,427
7,844
2026-08-18
MySQL
Database Drivers
Database & Storage
→
A pure Python MySQL driver compatible to mysql-python.
11
duckdb
Analytical
60,680,077
41,018
2026-09-04
Analytical
Database
Database & Storage
→
An in-process SQL OLAP database management system; optimized for analytics and fast queries, similar to SQLite but for analytical workloads.
12
peewee
Relational Databases
45,230,741
11,984
2026-09-05
Relational Databases
ORM
Database & Storage
→
A small, expressive ORM.
13
elasticsearch
Database & Storage
44,688,318
4,385
2026-08-31
Search
Database & Storage
→
The official low-level Python client for
Elasticsearch .
14
opensearch-py
Database & Storage
44,499,442
469
2026-09-03
Search
Database & Storage
→
The official low-level Python client for
OpenSearch .
15
msgspec
Database & Storage
34,857,641
4,086
2026-09-05
Serialization
Database & Storage
→
A fast serialization and validation library with built-in support for JSON, MessagePack, YAML, and TOML.
16
pyodbc
Other Relational Databases
34,847,669
3,081
2026-06-06
Other Relational Databases
Database Drivers
Database & Storage
→
An ODBC bridge for connecting to SQL Server and any other ODBC-accessible database.
17
diskcache
Database & Storage
29,636,233
2,904
2024-03-03
Caching
Database & Storage
→
SQLite and file backed cache backend with faster lookups than memcached and redis.
18
clickhouse-connect
ClickHouse
29,158,694
519
2026-09-05
ClickHouse
Database Drivers
Database & Storage
→
The official ClickHouse client, with SQLAlchemy and Superset connectors.
19
oracledb
Other Relational Databases
22,752,045
450
2026-08-31
Other Relational Databases
Database Drivers
Database & Storage
→
The official Python driver for Oracle Database, successor to cx_Oracle.
20
sqlmodel
Relational Databases
21,832,654
18,306
2026-09-01
Relational Databases
ORM
Database & Storage
→
SQLModel is based on Python type annotations, and powered by Pydantic and SQLAlchemy.
21
mysqlclient
MySQL
17,601,470
2,537
2026-08-22
MySQL
Database Drivers
Database & Storage
→
MySQL connector with Python 3 support (
mysql-python fork).
22
clickhouse-driver
ClickHouse
17,531,550
1,302
2026-07-22
ClickHouse
Database Drivers
Database & Storage
→
Python driver with native interface for ClickHouse.
23
lancedb
Vector
14,213,182
11,358
2026-09-05
Vector
Database
Database & Storage
→
A developer-friendly embedded retrieval database for multimodal AI.
24
chromadb
Vector
10,285,054
29,231
2026-09-03
Vector
Database
Database & Storage
→
An open-source embedding database for building AI applications with embeddings and semantic search.
25
cassandra-driver
NoSQL Databases
5,323,050
1,427
2026-07-21
NoSQL Databases
Database Drivers
Database & Storage
→
The Python Driver for Apache Cassandra.
26
hishel
Database & Storage
4,525,855
408
2026-09-04
Caching
Database & Storage
→
RFC 9111 compliant HTTP caching for httpx and requests, with sync and async support.
27
tinydb
Key-Value & Document
3,609,284
7,561
2026-08-10
Key-Value & Document
Database
Database & Storage
→
A tiny, document-oriented database.
28
mssql-python
Other Relational Databases
3,480,894
469
2026-09-04
Other Relational Databases
Database Drivers
Database & Storage
→
Official Microsoft driver for SQL Server and Azure SQL, built on ODBC for high performance and low memory usage.
29
chdb
Analytical
3,336,612
2,890
2026-09-04
Analytical
Database
Database & Storage
→
In-process OLAP SQL engine with the full ClickHouse dialect, zero-copy pandas/Arrow interop, and federation to remote ClickHouse clusters via remoteSecure().
30
pynamodb
NoSQL Databases
3,332,791
2,647
2026-04-24
NoSQL Databases
ORM
Database & Storage
→
A Pythonic interface for
Amazon DynamoDB .
31
mongoengine
NoSQL Databases
2,131,453
4,349
2026-09-02
NoSQL Databases
ORM
Database & Storage
→
A Python Object-Document-Mapper for working with MongoDB.
32
dogpile.cache
Database & Storage
2,095,645
298
2026-08-11
Caching
Database & Storage
→
dogpile.cache is a next generation replacement for Beaker made by the same authors.
33
django-cacheops
Database & Storage
2,004,387
2,274
2026-04-15
Caching
Database & Storage
→
A slick ORM cache with automatic granular event-driven invalidation.
34
beanie
NoSQL Databases
1,435,003
2,696
2026-08-31
NoSQL Databases
ORM
Database & Storage
→
An asynchronous Python object-document mapper (ODM) for MongoDB.
35
sqlite-utils
SQLite
1,077,866
2,167
2026-09-02
SQLite
Database Drivers
Database & Storage
→
Python CLI utility and library for manipulating SQLite databases.
36
meilisearch
Database & Storage
966,631
602
2026-08-28
Search
Database & Storage
→
The official Python client for the
Meilisearch search engine.
37
django-haystack
Database & Storage
176,699
3,734
2026-08-21
Search
Database & Storage
→
Modular search for Django.
38
zvec
Vector
46,517
15,793
2026-09-04
Vector
Database
Database & Storage
→
An embedded vector database for on-device RAG and edge AI, the SQLite of vector databases.
39
django-mongodb-backend
NoSQL Databases
34,372
228
2026-09-01
NoSQL Databases
Database Drivers
Database & Storage
→
Official MongoDB database backend for Django.
40
django.db.models
Relational Databases
Bundled
89,940
2026-09-04
Relational Databases
ORM
Database & Storage
→
(part of Django) The Django
ORM .
41
sqlite3
SQLite
Stdlib
75,991
2026-09-05
SQLite
Database Drivers
Database & Storage
Stdlib
→
(Python standard library) SQLite interface compliant with DB-API 2.0.