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