Dataset
A Python library that simplifies database usage by providing an abstraction layer, allowing databases to be used like JSON files without complex SQL.
Score
30
User Rating
3.0
Free/Trial Support
Supported
Starting Price
--
Last Updated
Apr 23, 2026
Overview
What is Dataset?
Dataset is a Python library designed to make working with databases as easy as handling JSON or CSV files. It removes the need for direct SQL statements and full ORM models, offering automatic schema creation, upserts, and query helpers for SQLite, PostgreSQL, and MySQL.
What is Dataset used for?

Top Features
- Automatic schema creation
- Upserts for create/update
- Query helpers for simple operations
- Compatibility with major databases via SQLAlchemy
How to use Dataset?
Install via pip, connect to a database (e.g., SQLite), create tables automatically by inserting data, and use simple methods to query or update records without writing SQL.
Alternative Tools
No alternative tools found
Pros & Cons
Pros
- Easy to use for developers
- No need for complex SQL
- Works with SQLite, PostgreSQL, MySQL
- Automatic handling of database schemas
Cons
- Limited to basic operations, may not support advanced SQL features
- Built on SQLAlchemy, which adds some overhead
Use Cases
- Quick data storage for small to medium datasets
- Prototyping or scripting without database setup
- Simplifying database interactions in Python applications
Dataset Pricing
Free Plan
No detailed pricing information available
User Reviews
3.0
out of 5
3.0
No reviews yet
Be the first to review this tool!