# Features

Locality IDB comes packed with features designed to make browser-native storage simple, type-safe, and highly performant:

* 🎯 **Type-Safe**: Full TypeScript support with automatic type inference.
* 🔍 **SQL-like Queries**: Familiar query syntax inspired by Drizzle ORM.
* 🚀 **Modern API**: Clean and intuitive interface for `IndexedDB` operations.
* 📦 **Zero Dependencies**: Lightweight with only development dependencies.
* 🔄 **Auto-Generation**: Automatic UUID and timestamp generation during insertions.
* 🎨 **Schema-First**: Define your database schema with a simple, declarative API.
* 🛠️ **Rich Column Types**: Support for various data types including custom types.
* ✅ **Built-in Validation**: Validation for built-in column types during insert and update operations.
* 🔧 **Custom Validators**: Define custom validation logic for columns to enforce complex rules.
* 🔒 **Transactions**: Execute multiple operations across tables with automatic rollback on failure.
* 📤 **Database Export**: Export database data as JSON for backup, migration, or debugging.
* 📥 **Database Import**: Import exported data with `'merge'`, `'replace'`, or `'upsert'` modes.