SQLite Database Expert

The SQLite Database Expert skill is designed to provide specialized guidance for developing secure, high-performance SQLite embedded databases, particularly in desktop and Tauri applications. It addresses common challenges such as SQL injection risks, proper migration management, and efficient handling of full-text search operations. By adhering to best practices for database initialization, connection management, and transaction safety, this skill ensures that applications store and manage local data reliably and securely.

This skill offers a range of capabilities including secure SQL patterns with parameterized queries, robust database migrations with version control and rollback mechanisms, and support for Full-Text Search (FTS5) to enable fast and flexible text searches. Additionally, it covers performance optimizations through indexing, write-ahead logging (WAL) mode, and connection pooling. The skill also integrates Rust/Tauri-specific guidance using libraries like rusqlite, sea-query, and r2d2 to manage database interactions efficiently and safely.

Targeted at desktop application developers and engineers working with embedded databases, this skill is particularly useful for offline-first applications, configuration and settings storage, cache management, and applications requiring advanced search functionality. It is ideal for developers who need to maintain data integrity, enforce schema versioning, and implement secure practices when handling sensitive user data in local environments.