Claude Cursor opencode Skill

sqlite-wal-optimization

High concurrent SQLite access causing lock contention and missing indexes Keywords: sqlite, wal, indexes, performance

LLM Mart · 0 points · 0 0 0

Virus-scanned Reviewed automatically before listing.

Full trust report

Download vodailocz-kilo-kit-mcp-skills_learned_sqlite-wal-optimization-0448e6c.zip · 0 KB

vodailocz/kilo-kit-mcp 27 3 forks Apache-2.0 Updated 22d ago

Part of vodailocz/kilo-kit-mcp — 142 skills

Install

skills CLI npx skills add https://github.com/VoDaiLocz/kilo-kit-mcp/tree/main/skills/learned/sqlite-wal-optimization

Claude Code

claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install vodailocz-kilo-kit-mcp@llmmart

Git git clone https://github.com/VoDaiLocz/kilo-kit-mcp.git

The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole vodailocz/kilo-kit-mcp collection as a plugin from our marketplace. Git is the plain clone.

Skill manifest

sqlite-wal-optimization

Overview

High concurrent SQLite access causing lock contention and missing indexes

Solution Pattern & Best Practices

Apply PRAGMA journal_mode=WAL and create composite indexes on (task_mode, created_at)

Verification & Testing Strategy

Run PRAGMA integrity_check and benchmark with multi-client connections

Files (kilo-kit-mcp)

SKILL.md 517 B

---
name: "sqlite-wal-optimization"
description: "High concurrent SQLite access causing lock contention and missing indexes Keywords: sqlite, wal, indexes, performance"
---
# sqlite-wal-optimization

## Overview
High concurrent SQLite access causing lock contention and missing indexes

## Solution Pattern & Best Practices
Apply PRAGMA journal_mode=WAL and create composite indexes on (task_mode, created_at)

## Verification & Testing Strategy
Run PRAGMA integrity_check and benchmark with multi-client connections