1
sqlalchemy
Relational Databases
405,459,299
12,091
2026-08-17
Relational Databases
ORM
Database & Storage
→
The Python SQL Toolkit and Object Relational Mapper.
2
cachetools
Database & Storage
320,943,692
2,777
2026-08-01
Caching
Database & Storage
→
Extensible memoizing collections and decorators.
3
msgpack
Database & Storage
276,024,904
2,101
2026-08-17
Serialization
Database & Storage
→
MessagePack serializer implementation for Python.
4
redis
NoSQL Databases
258,795,928
13,609
2026-08-17
NoSQL Databases
Database Drivers
Database & Storage
→
The Python client for Redis.
5
orjson
Database & Storage
223,757,091
8,204
2026-08-14
Serialization
Database & Storage
→
Fast, correct JSON library.
6
psycopg
PostgreSQL
123,798,280
2,472
2026-07-20
PostgreSQL
Database Drivers
Database & Storage
→
The most popular PostgreSQL adapter for Python.
7
marshmallow
Database & Storage
116,036,350
7,242
2026-08-08
Serialization
Database & Storage
→
A lightweight library for converting complex objects to and from simple Python datatypes.
8
asyncpg
PostgreSQL
114,759,979
8,067
2026-02-27
PostgreSQL
Database Drivers
Database & Storage
→
A fast PostgreSQL Database Client Library for Python/asyncio.
9
pymongo
NoSQL Databases
108,615,717
4,353
2026-08-17
NoSQL Databases
Database Drivers
Database & Storage
→
The official Python client for MongoDB.
10
pymysql
MySQL
92,701,150
7,843
2026-08-05
MySQL
Database Drivers
Database & Storage
→
A pure Python MySQL driver compatible to mysql-python.
11
duckdb
Analytical
58,433,045
40,323
2026-08-17
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
elasticsearch
Database & Storage
50,773,626
4,385
2026-08-17
Search
Database & Storage
→
The official low-level Python client for
Elasticsearch .
13
opensearch-py
Database & Storage
50,068,017
469
2026-07-28
Search
Database & Storage
→
The official low-level Python client for
OpenSearch .
14
peewee
Relational Databases
48,312,690
11,985
2026-08-14
Relational Databases
ORM
Database & Storage
→
A small, expressive ORM.
15
msgspec
Database & Storage
41,226,048
4,030
2026-08-11
Serialization
Database & Storage
→
A fast serialization and validation library with built-in support for JSON, MessagePack, YAML, and TOML.
16
pyodbc
Other Relational Databases
40,017,131
3,078
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
35,600,907
2,905
2024-03-03
Caching
Database & Storage
→
SQLite and file backed cache backend with faster lookups than memcached and redis.
18
clickhouse-connect
ClickHouse
29,983,026
515
2026-08-17
ClickHouse
Database Drivers
Database & Storage
→
The official ClickHouse client, with SQLAlchemy and Superset connectors.
19
oracledb
Other Relational Databases
25,210,772
446
2026-08-04
Other Relational Databases
Database Drivers
Database & Storage
→
The official Python driver for Oracle Database, successor to cx_Oracle.
20
sqlmodel
Relational Databases
21,337,426
18,265
2026-08-12
Relational Databases
ORM
Database & Storage
→
SQLModel is based on Python type annotations, and powered by Pydantic and SQLAlchemy.
21
mysqlclient
MySQL
19,403,128
2,531
2026-07-26
MySQL
Database Drivers
Database & Storage
→
MySQL connector with Python 3 support (
mysql-python fork).
22
clickhouse-driver
ClickHouse
19,082,544
1,302
2026-07-22
ClickHouse
Database Drivers
Database & Storage
→
Python driver with native interface for ClickHouse.
23
chromadb
Vector
12,540,806
29,077
2026-08-17
Vector
Database
Database & Storage
→
An open-source embedding database for building AI applications with embeddings and semantic search.
24
lancedb
Vector
9,273,697
11,170
2026-08-17
Vector
Database
Database & Storage
→
A developer-friendly embedded retrieval database for multimodal AI.
25
cassandra-driver
NoSQL Databases
7,433,740
1,427
2026-07-21
NoSQL Databases
Database Drivers
Database & Storage
→
The Python Driver for Apache Cassandra.
26
tinydb
Key-Value & Document
5,663,197
7,553
2026-08-10
Key-Value & Document
Database
Database & Storage
→
A tiny, document-oriented database.
27
pynamodb
NoSQL Databases
3,915,770
2,649
2026-04-24
NoSQL Databases
ORM
Database & Storage
→
A Pythonic interface for
Amazon DynamoDB .
28
chdb
Analytical
3,245,043
2,870
2026-08-17
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().
29
mssql-python
Other Relational Databases
3,204,809
461
2026-08-17
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.
30
mongoengine
NoSQL Databases
2,413,591
4,348
2026-08-16
NoSQL Databases
ORM
Database & Storage
→
A Python Object-Document-Mapper for working with MongoDB.
31
dogpile.cache
Database & Storage
2,335,877
295
2026-08-11
Caching
Database & Storage
→
dogpile.cache is a next generation replacement for Beaker made by the same authors.
32
django-cacheops
Database & Storage
1,640,133
2,274
2026-04-15
Caching
Database & Storage
→
A slick ORM cache with automatic granular event-driven invalidation.
33
beanie
NoSQL Databases
1,531,192
2,692
2026-08-07
NoSQL Databases
ORM
Database & Storage
→
An asynchronous Python object-document mapper (ODM) for MongoDB.
34
sqlite-utils
SQLite
1,290,638
2,151
2026-08-14
SQLite
Database Drivers
Database & Storage
→
Python CLI utility and library for manipulating SQLite databases.
35
meilisearch
Database & Storage
1,043,513
600
2026-07-22
Search
Database & Storage
→
The official Python client for the
Meilisearch search engine.
36
django-haystack
Database & Storage
177,592
3,734
2026-08-15
Search
Database & Storage
→
Modular search for Django.
37
zvec
Vector
43,239
15,453
2026-08-17
Vector
Database
Database & Storage
→
An embedded vector database for on-device RAG and edge AI, the SQLite of vector databases.
38
django-mongodb-backend
NoSQL Databases
29,252
227
2026-08-17
NoSQL Databases
Database Drivers
Database & Storage
→
Official MongoDB database backend for Django.
39
django.db.models
Relational Databases
Not on PyPI
88,420
2026-08-17
Relational Databases
ORM
Database & Storage
→
40
sqlite3
SQLite
Not on PyPI
74,339
2026-08-17
SQLite
Database Drivers
Database & Storage
Built-in
→
(Python standard library) SQLite interface compliant with DB-API 2.0.