room-database

# Room Database Skill ## Overview This skill provides expert capabilities for Android Room persistence library. It enables designing database schemas, implementing DAOs, configuring migrations, and integrating with modern Android architecture components. ## Allowed Tools - `bash` - Execute Gradle commands and Android build tools - `read` - Analyze Room entities and DAO files - `write` - Generate Room database components - `edit` - Update existing Room configurations - `glob` - Search for database-related files - `grep` - Search for patterns in database code ## Capabilities ### Entity Design 1. **Entity Definition** - Define @Entity classes with proper annotations - Configure primary keys (single and composite) - Set up foreign key relationships - Configure indices for query optimization - Implement embedded objects 2. **Type Converters** - Create @TypeConverter for custom types - Handle Date/Time conversions - Convert enums to database types - Serialize complex objects to JSON - Configure global type converters ### DAO Implementation 3. **Query Methods** - Write @Query annotations with SQL - Implement @Insert, @Update, @Delete - Configure conflict strategies - Create complex JOIN queries - Implement pagination queries 4. **Reactive Queries** - Return Flow for reactive updates - Configure LiveData return types - Implement one-shot suspend functions - Handle nullable results - Create parameterized queries #...