rusqlite

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.