메뉴
SQLite vector DB for work log storage and semantic search. Use for indexing work logs, generating embeddings, semantic search, and DB maintenance.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | sqlite-vectordb |
| description | SQLite vector DB for work log storage and semantic search. Use for indexing work logs, generating embeddings, semantic search, and DB maintenance. |
Store work logs in a searchable vector database and provide semantic search infrastructure.
When to use:
/log-work execution (integrated with work-logger)Note: DB initializes automatically. No need to run init_db.py manually.
Index a markdown log into the vector DB.
uv run .claude/skills/sqlite-vectordb/scripts/add_entry.py \
--file "private-docs/work-logs/YYYY-MM-DD-slug.md" \
--summary "One-line summary" \
--tags "tag1,tag2"
--file, -f (required): Work log file path--summary, -s (required): One-line summary for search indexing--tags, -t (required): Comma-separated tagsSemantic similarity search in work logs.
uv run .claude/skills/sqlite-vectordb/scripts/search.py \
--query "search terms" \
--limit 5
--query, -q (required): Search query--limit, -l: Max results (default: 5)--tag, -t: Filter by tag--type, -T: Filter by log type--json, -j: JSON outputRemove a work log entry from the database.
uv run .claude/skills/sqlite-vectordb/scripts/delete_entry.py \
--file "private-docs/work-logs/YYYY-MM-DD-slug.md"
Manual schema creation. Usually not needed - other scripts auto-initialize.
uv run .claude/skills/sqlite-vectordb/scripts/init_db.py
<technical_specs>
private-docs/work-logs/.vector-db/work-logs.dbsqlite-vec extensionall-MiniLM-L6-v2 (384-dim)uv run with PEP 723 inline deps</technical_specs>
Language requirement: All data stored in the vector DB MUST be written in English.
auth, refactor, not 인증, 리팩토링)all-MiniLM-L6-v2) performs best with English textExit codes:
Common fixes:
private-docs/work-logs/.vector-db/work-logs.db and re-run (auto-recreates)uv syncValid usage:
# Add entry (auto-initializes DB if missing)
uv run .claude/skills/sqlite-vectordb/scripts/add_entry.py \
--file "private-docs/work-logs/2026-01-16-auth-feature.md" \
--summary "Implement OAuth2 authentication" \
--tags "auth,oauth,security"
# Search with filters
uv run .claude/skills/sqlite-vectordb/scripts/search.py \
--query "authentication login" --limit 3 --tag auth
Invalid usage:
# WRONG: Non-existent file → Exit code 1
uv run .../add_entry.py --file "missing.md" ...
# WRONG: Empty summary → Poor search quality
uv run .../add_entry.py --file "..." --summary "" --tags "..."
Explore and debug .screenize project packages. Lists projects, reads project.json, summarizes event streams, displays timeline segments, and shows recording statistics.
Fetch a GitHub issue and create a detailed implementation plan. Use when given a GitHub issue URL or number to analyze the issue, explore relevant codebase areas, and produce a step-by-step implementation plan with file changes, architecture considerations, and risk assessment.
Document completed work with vector database indexing. Use `/log-work` after completing any significant task (feature, bug fix, refactoring, configuration change) to record what was done, decisions made, and files changed.