sqlite-provider

Provide a SQLite-backed Waggle provider for local task data management.

3|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/kazukinagata/waggle --skill sqlite-provider
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sqlite-provider
Source: https://github.com/kazukinagata/waggle/tree/main/providers/sqlite/skills/sqlite-provider
Command: npx skills add https://github.com/kazukinagata/waggle --skill sqlite-provider

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, jq, and includes scripts (resource) components.

What problem does it solve?

Waggle users often need a persistent local storage backend for task data when running in isolated environments. This skill provides a SQLite-backed Waggle provider implementation that handles config retrieval, schema validation, and CRUD operations for tasks.

Core Features & Use Cases

  • Config retrieval and headless session setup for the sqlite provider when the active provider is sqlite.
  • Schema validation and auto-repair using the included scripts to ensure required tables exist (tasks, task_dependencies, teams, sprints, intake_log).
  • CRUD and query tooling for tasks, including convenient scripts to create, read, update, delete, and fetch tasks with related dependencies.
  • View-server integration and identity resolution for local deployments.

Quick Start

Load this skill to initialize Waggle's SQLite-backed provider and begin managing tasks with a local database.

Frequently Asked Questions about sqlite-provider

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

FAQPage Schema
How do I set up local SQLite storage for Waggle task data?

To set up local SQLite storage for Waggle task data, load this skill to initialize the SQLite-backed provider, which handles config retrieval, headless session setup, and local database management for offline environments.

What is a SQLite-backed Waggle provider used for?

A SQLite-backed Waggle provider is used for persistent local task data management in isolated environments, offering offline storage, schema validation, and reliable CRUD operations without requiring an external database server.

Can I use SQLite for Waggle CRUD operations and task querying offline?

Yes, you can use SQLite for Waggle CRUD operations and task querying offline. This provider includes scripts to create, read, update, delete, and fetch tasks with related dependencies entirely through a local database.

Does the Waggle SQLite provider validate and repair database schemas automatically?

Yes, the Waggle SQLite provider validates and auto-repairs database schemas using included scripts to ensure required tables like tasks, task_dependencies, teams, sprints, and intake_log exist and are correctly structured.

Do I need sqlite3 and jq installed to run the Waggle SQLite provider?

Yes, you need sqlite3 and jq installed to run the Waggle SQLite provider, as these dependencies are required for executing the local database operations and processing JSON data within the provider scripts.

What are the limitations of using a local SQLite backend for Waggle task management?

Using a local SQLite backend for Waggle task management is limited to isolated, offline environments and local deployments, making it less suitable for distributed systems requiring concurrent multi-user access or remote server connectivity.