sqlite-database-expert

```yaml

39stars4forksUpdated 6/18/2026

Security Database Management #security #migrations #database #sqlite #full-text-search #tauri #rust

Security Assessment

Safe(100/100)

Security Score100/100

About sqlite-database-expert

The SQLite Database Expert skill provides specialized knowledge for building secure, performant embedded database solutions in desktop applications, particularly those using Tauri and Rust. This skill addresses the critical challenge of implementing local data persistence while preventing SQL injection vulnerabilities, managing schema migrations safely, and ensuring data integrity in offline-first applications. It emphasizes security-first development practices with mandatory use of parameterized queries and proper input validation.

This skill delivers comprehensive capabilities including secure SQL pattern implementation, database migration management with version control and rollback support, Full-Text Search (FTS5) integration for efficient text searching, and performance optimization through WAL mode, connection pooling, and indexing strategies. It specializes in Rust ecosystem integration using rusqlite and sea-query libraries, with built-in support for connection pooling via r2d2. The skill enforces a test-driven development approach using in-memory SQLite for fast test execution and provides detailed reference materials for advanced patterns and security examples.

This skill is designed for developers building desktop applications with local data storage requirements, particularly those working with Tauri, Electron with Rust backends, or native Rust desktop applications. It serves teams implementing offline-first architectures, applications requiring full-text search capabilities, and projects where data security and migration safety are paramount. The skill is especially valuable for developers transitioning from server-side databases to embedded solutions or those needing to implement complex database operations while maintaining strict security standards.

FAQ

What programming languages and frameworks does this skill support?

This skill specializes in Rust-based implementations using rusqlite and sea-query libraries, with primary focus on Tauri desktop applications. It requires SQLite 3.35+ and rusqlite 0.29+ for core functionality.

How does this skill prevent SQL injection vulnerabilities?

The skill enforces mandatory use of parameterized queries and never allows string concatenation of user input into SQL statements. It includes security reference files and validation patterns that must be consulted before implementing any database operation involving user input.

What is the risk level and why?

This skill has a MEDIUM risk level because it handles local user data, implements database migrations that could cause data loss if done incorrectly, and requires careful attention to SQL injection prevention. The skill includes mandatory reading protocols for reference files before implementing sensitive operations.

Does this skill support database migrations?

Yes, database migrations are a core capability. The skill provides version control for schema changes, rollback capabilities, and enforces migration discipline with proper tracking and validation to prevent data loss during schema evolution.

What performance optimization features are included?

The skill implements WAL (Write-Ahead Logging) mode, connection pooling via r2d2, prepared statement caching, batch operations, proper indexing strategies, and Full-Text Search (FTS5) for efficient text searching in large datasets.