tauri-impl-database

Implement key-value, SQL-backed, or custom Rust databases in Tauri apps.

4|Updated Mar 20, 2026
One-click install
npx skills add https://github.com/OpenAEC-Foundation/OpenAEC-Workspace-Composer --skill tauri-impl-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: tauri-impl-database
Source: https://github.com/OpenAEC-Foundation/OpenAEC-Workspace-Composer/tree/main/.claude/skills/tauri-2/tauri-impl/tauri-impl-database
Command: npx skills add https://github.com/OpenAEC-Foundation/OpenAEC-Workspace-Composer --skill tauri-impl-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Provides a structured guide for adding persistent data storage to Tauri-based desktop apps using store, sql, or custom Rust-backed databases, consolidating patterns and best practices.

Core Features & Use Cases

  • Store-based key-value persistence for settings, preferences, and small data with tauri-plugin-store.
  • SQL-based persistence with tauri-plugin-sql for frontend SQL access and migrations.
  • Custom Rust/SQLx-based database layer for advanced data models, pooling, and complex transactions.
  • Includes references for anti-patterns, examples, and API methods to accelerate implementation.

Quick Start

Follow one of the three database integration patterns to add a local SQLite database to your Tauri app and run your first query.

Frequently Asked Questions about tauri-impl-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add a local SQLite database to my Tauri app?▼

Persistent data storage in Tauri apps is solved by implementing key-value stores, SQL-backed stores, or custom Rust-backed databases. It provides structured data patterns, migrations, and safe CRUD operations across frontend and backend boundaries.

What's the best way to manage persistent settings in Tauri?▼

To add a local SQLite database to your Tauri app, use the tauri-plugin-sql pattern for frontend SQL access with migrations, or implement a custom Rust-backed database layer using sqlx for advanced data models and connection pooling.

How do I use sqlx with Tauri for complex database transactions?▼

The best way to manage persistent settings in Tauri is using the tauri-plugin-store pattern for key-value persistence, which handles small data like preferences efficiently without requiring a full SQL database setup.

Does tauri-plugin-sql support frontend database migrations?▼

Use sqlx with Tauri by implementing a custom Rust-backed database layer that enforces asynchronous commands and parameterized queries, enabling advanced data models, pooling, and complex transactions across backend boundaries.

When should I use a custom Rust-backed database instead of tauri-plugin-store?▼

Yes, tauri-plugin-sql supports frontend SQL access and database migrations directly. It enables safe CRUD operations across frontend and backend boundaries while enforcing proper permissions and parameterized queries.

Do I need to set up directories before connecting a database in Tauri?▼

Use a custom Rust-backed database with sqlx instead of tauri-plugin-store when your Tauri app requires advanced data models, connection pooling, or complex transactions that exceed simple key-value persistence needs.