partme-ai/tauri-app-sql

When to use this skill

ALWAYS use this skill when the user mentions:

• Using SQLite, MySQL, or PostgreSQL in a Tauri app
• SQL migrations or database schema setup
• Running queries from the frontend

Trigger phrases include:

• "sql", "sqlite", "database", "postgres", "mysql", "migration", "db plugin"

How to use this skill

1. Install the SQL plugin (with SQLite feature):

   cargo add tauri-plugin-sql --features sqlite
   

2. Register the plugin with migrations in your Tauri builder:

   use tauri_plugin_sql::{Migration, MigrationKind};
   let migrations = vec![Migration {
       version: 1, description: "create_users", sql: "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);",
       kind: MigrationKind::Up,
   }];
   tauri::Builder::default()
       .plugin(tauri_plugin_sql::Builder::new().add_migrations("sqlite:app.db", migrations).build())
   

3. Configure capabilities in src-tauri/capabilities/default.json:

   { "permissions": ["sql:allow-load", "sql:allow-execute", "sql:allow-select"] }
   

4. Query from the frontend:

   import Database from '@tauri-apps/plugin-sql';
   const db = await Database.load('sqlite:app.db');
   await db.execute('INSERT INTO users (name) VALUES (?)', ['Alice']);
   const users = await db.select<{ id: number; name: string }[]>('SELECT * FROM users');
   

5. Use parameterized queries to prevent SQL injection
6. Keep migrations versioned and run them automatically on app startup

Outputs

• SQL plugin setup with SQLite/Postgres/MySQL
• Migration system with versioned schemas
• Frontend query patterns with parameterized inputs

References

• https://v2.tauri.app/plugin/sql/

Keywords

tauri sql, sqlite, database, postgres, mysql, migrations, queries