sqlite
SQLite problem-solving patterns for embedded/edge deployments. Use when: connection setup, "database locked" errors, ALTER TABLE workarounds, concurrency problems, FTS setup, SQLite-specific gotchas. Do not use for: basic DDL/DML syntax (use context7 MCP), schema design decisions (use data-modeling skill first). Workflow: data-modeling skill (design) → this skill (implement). Decision: If asking "should I use PostgreSQL instead?" — see comparison section at bottom.
Installation and usage
SQLite problem-solving patterns for embedded/edge deployments. Use when: connection setup, "database locked" errors, ALTER TABLE workarounds, concurrency problems, FTS setup, SQLite-specific gotchas. Do not use for: basic DDL/DML syntax (use context7 MCP), schema design decisions (use data-modeling skill first). Workflow: data-modeling skill (design) → this skill (implement). Decision: If asking "should I use PostgreSQL instead?" — see comparison section at bottom.
安裝後，您可以透過在終端機執行以下指令來使用此技能：
skills use sqlite