Does it support multi-user concurrency?

The skill provides patterns for read-write separation and busy timeout handling, allowing reads and writes to occur simultaneously without locking the database.

What maintenance routines are included?

It includes guidance for regular maintenance tasks such as VACUUM to reclaim space, ANALYZE for query planner efficiency, and integrity checks to prevent data corruption.

Can this skill help with identifying slow queries?

Yes, it utilizes EXPLAIN QUERY PLAN to detect full table scans and recommends optimal indexing strategies like covering and partial indexes to speed up data retrieval.

How does this skill improve SQLite write performance?

It implements Write-Ahead Logging (WAL) and transaction-based batching, which can increase write speeds by 10x to 100x compared to individual inserts.

SQLite Performance Optimization

Name: SQLite Performance Optimization
Author: bradtaylorsf

bybradtaylorsf

•

データベース管理

Optimizes SQLite databases through advanced PRAGMA configurations, indexing strategies, and high-performance query patterns.

The SQLite Optimization skill provides Claude with a comprehensive toolkit for enhancing the performance and reliability of SQLite databases. It equips the agent with industry-standard best practices for Write-Ahead Logging (WAL) configurations, memory-mapped I/O settings, and sophisticated indexing techniques such as covering and partial indexes. By implementing these patterns, developers can significantly reduce query latency, improve concurrency handling, and execute bulk data operations up to 100x faster using optimized transaction strategies and statement caching.

主な機能

01Advanced PRAGMA tuning for WAL mode, cache size, and synchronous settings

02Query plan analysis and optimization using EXPLAIN QUERY PLAN

03Concurrency management via read-write separation and busy handlers

04Automated database maintenance including VACUUM, ANALYZE, and REINDEX

05High-speed bulk operation patterns for batch inserts and updates

066 GitHub stars

ユースケース

01Scaling SQLite applications for multi-user environments with WAL mode

02Diagnosing and fixing slow-running SQL queries in production environments

03Accelerating data-intensive local storage in desktop or mobile apps

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team sqlite-optimization

For use in Claude.ai and ChatGPT

Download Skill