database-operations
SQLite database, DBManager, HybridStorage, and schema operations for GMailArchiver. Use when working with database queries, transactions, mbox offsets, FTS5 search, or data integrity. Triggers on: database, SQLite, DBManager, HybridStorage, schema, transaction, mbox offset, FTS5, integrity, migration.
When & Why to Use This Skill
This Claude skill provides comprehensive technical guidance for managing the SQLite data layer within the GMailArchiver ecosystem. It specializes in DBManager operations, HybridStorage patterns, and schema management, ensuring robust data integrity, efficient FTS5 full-text search indexing, and seamless transaction handling for email archiving workflows.
Use Cases
- Developing and optimizing complex SQLite queries and transactions to ensure high-performance data persistence.
- Managing database schema migrations and versioning using SchemaManager to maintain system stability during updates.
- Implementing and troubleshooting FTS5 search indexes to enable fast, full-text search capabilities across large email archives.
- Performing data integrity audits and consistency checks between SQLite records and mbox file offsets using specialized CLI commands.
- Architecting atomic write patterns and hybrid storage solutions to prevent data corruption in high-concurrency environments.
| name | database-operations |
|---|---|
| description | >- |
| or data integrity. Triggers on | database, SQLite, DBManager, HybridStorage, |
Database Operations in GMailArchiver
This skill provides guidance on database operations for GMailArchiver.
Source Documentation
Always read the authoritative sources for current database design:
src/gmailarchiver/data/ARCHITECTURE.md- Data layer architecture:- DBManager responsibilities and interface
- HybridStorage atomic write patterns
- SchemaManager version handling
- Transaction management
- Integrity validation
docs/ARCHITECTURE.md- System-wide data architecture:- Database schema (tables, columns, relationships)
- FTS5 search index configuration
- Data integrity architecture
- Safety guarantees
CLAUDE.md- Quick reference:- Database schema summary
- Key interfaces overview
- CLI commands for database operations
Key Components
Read these files for implementation details:
src/gmailarchiver/data/db_manager.py- DBManager classsrc/gmailarchiver/data/hybrid_storage.py- HybridStorage classsrc/gmailarchiver/data/schema_manager.py- SchemaManager class
Database CLI Commands
uv run gmailarchiver db-info # Show database statistics
uv run gmailarchiver verify-integrity # Check schema and constraints
uv run gmailarchiver verify-consistency # Check DB ↔ mbox sync
uv run gmailarchiver verify-offsets # Validate mbox offsets
uv run gmailarchiver repair --backfill # Fix issues
Usage
When working with database code:
- Read
src/gmailarchiver/data/ARCHITECTURE.mdfor current design - Check
docs/ARCHITECTURE.mdfor schema details - If schema or patterns change, update the documentation (not this skill)
The source documentation is the single source of truth - this skill just points you there.