What problem does it solve?
This Skill provides a robust and idiomatic Rust interface for interacting with SQLite databases, enabling efficient data storage, retrieval, and management within Rust applications.
Core Features & Use Cases
- Database Connection Management: Securely opens and manages connections to SQLite databases, including in-memory and file-based options.
- SQL Query Execution: Supports executing raw SQL statements, parameterized queries, and batch operations.
- Data Mapping: Facilitates seamless conversion between Rust types and SQLite data, including handling optional values and complex structures.
- Schema Migrations & FTS5: Includes patterns for managing database schema evolution and implementing full-text search capabilities.
- Use Case: Store and query application data like user preferences, history logs, or chat conversations efficiently and reliably.
Quick Start
Use the rusqlite skill to open an in-memory SQLite database connection and execute a simple CREATE TABLE statement.