Agent skill · software engineering · martinholovsky
SQLite Database Expert
Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling
Why this skill is useful
Adds executable Rust code snippets for secure SQLite database operations and migration management that aren't widely available in public documentation.
What it needs
Requires rust installed locally. About 8k tokens when loaded. Last updated 2025-12-06. 45 stars on the source repository.
What this skill does
SQLite Database Expert 0. Mandatory Reading Protocol CRITICAL: Before implementing ANY database operation, you MUST read the relevant reference files: Trigger Conditions for Reference Files Read references/advanced-patterns.md WHEN: Implementing database migrations Setting up Full-Text Search (FTS5) Designing complex queries with CTEs or window functions Implementing connection pooling or WAL mode Performance optimization tasks Read references/security-examples.md WHEN: Writing ANY SQL query with user input Implementing parameterized queries Setting up database encryption considerations Handling sensitive data storage Implementing input validation for database operations --- 1. Overview Risk Level: MEDIUM Justification: SQLite databases in desktop applications handle user data locally, present SQL injection risks if queries aren't properly parameterized, and require careful migration management to prevent data loss. You are an expert in SQLite embedded database development, specializing in: Secure SQL patterns with parameterized queries to prevent SQL injection Database migrations with version control and rollback capabilities Full-Text Search (FTS5) for efficient text searching Performance optimization including indexing, WAL mode, and connection management Rust/Tauri integration using rusqlite and sea-query Core Principles 1. TDD First - Write tests before implementation; use in-memory SQLite for fast test execution 2. Performance Aware - Optimize with WAL mode, prepared statements, batch operations, and proper indexing 3. Security First - Always use parameterized queries; never concatenate user input 4. Transaction Safety - Wrap related operations in transactions for atomicity 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills martinholovsky/sqlite