SQLite Database Expert - Secure SQLite development for desktop apps
Provides secure SQLite development patterns for desktop applications, including parameterized queries, migrations, FTS5 search, performance, and data handling.
Tags
Updated: 2026-09-28Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Implement parameterized SQL queries
- Manage schema migrations
- Set up FTS5 search
- Optimize SQLite performance
- Integrate rusqlite with Tauri
- Enforce transaction safety
- Test with in-memory SQLite
Inputs
- Database path
- Schema changes
- Query parameters
- User-provided input
- Relevant reference files
Outputs
- SQLite database state
- Rust database code
- Database migrations
- FTS5 search implementation
- Automated tests
- Query results
Requirements
- SQLite 3.35+
- rusqlite 0.29+
- sea-query 0.28+
- r2d2 0.8+
- SQLite FTS5 support