database-skill

TinyDB is a file-based JSON database that persists data locally without requiring a server. Configure it with JSONStorage, optional caching middleware, and automatic ID generation to enable CRUD operations on document collections stored as JSON files.

TinyDB Query API supports simple to complex queries including exact matches, comparisons, and logical operators. Use the Query object to filter documents, retrieve specific fields, and chain conditions for flexible document retrieval from your tables.

Yes. TinyDB with CachingMiddleware reduces database hits by caching frequently accessed records. Context-managed resource handling ensures proper lifecycle management, making it suitable for caching task data, notes, and temporary session information in local applications.

TinyDB fits local, file-based projects with lightweight persistence needs—tasks, notes, and small-scale data that don't require network access or concurrent multi-user writes. It's ideal when you want embedded storage without database server setup overhead.

Insert documents using table.insert(), retrieve with queries and table.all(), update with table.update(), and delete with table.remove(). TinyDB automatically generates IDs and manages schema-less JSON storage, supporting full CRUD workflows in a few lines of code.