메뉴
Optimizes SQLite queries, schema design, and FTS5 usage for the Gyst knowledge base. Use when writing database queries, modifying schema, debugging slow searches, or when the user mentions "slow," "performance," "query," "index," or "database."
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Tests Gyst compatibility with self-hosted LLMs running through Ollama, vLLM, and OpenCode. Use when the user mentions "self-hosted," "local LLM," "Ollama," "vLLM," "OpenCode," "private," or "on-premise." Also use when testing MCP compatibility across different clients.
Analyzes current algorithms in Gyst and proposes specific improvements based on real eval data. Use when the user says "improve," "optimize," "better search," "fix retrieval," "algorithm," "brainstorm," or when eval metrics show degradation. Also use after running retrieval-eval.ts.
Enforces code uniformity across the entire Gyst codebase. This skill activates on EVERY file edit in src/. It checks patterns, naming, imports, error handling, logging, and database access. Use when writing, reviewing, or modifying any TypeScript file. Auto-activate always.
Sets up and maintains CI/CD pipelines for the Gyst project using GitHub Actions. Use when the user mentions "CI," "CD," "pipeline," "deploy," "actions," "workflow," "release," or "publish." Also use when creating or modifying .github/workflows/ files.
Detects bugs, logic errors, and unsafe patterns in TypeScript code. Use when writing new functions, reviewing code, fixing errors, or when the user says "check for bugs" or "review this." Auto-activate when editing files in src/.
Enforces consistent code patterns across the Gyst codebase. Use when writing new code, reviewing changes, or when the user mentions "consistency," "uniformity," "patterns," or "refactor." Auto-activate on any src/**/*.ts file.
| name | db-optimizer |
| description | Optimizes SQLite queries, schema design, and FTS5 usage for the Gyst knowledge base. Use when writing database queries, modifying schema, debugging slow searches, or when the user mentions "slow," "performance," "query," "index," or "database." |
| allowed-tools | Read, Grep, Glob, Bash |
| paths | src/store/**/*.ts |
bm25(entries_fts, 10.0, 5.0, 1.0)query.replace(/[\"*():^]/g, ' ')title:authentication searches only the title columnCurrent indexes:
Consider adding:
db.run("PRAGMA journal_mode=WAL");
db.run("PRAGMA busy_timeout=5000");
db.run("PRAGMA synchronous=NORMAL");
db.run("PRAGMA cache_size=-64000");