analyze-db-logs
CommunityDetects and diagnoses slow and super-slow SQLite queries.
Authormatthiasn
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps developers identify performance bottlenecks in database queries by analyzing slow and super-slow logs.
Core Features & Use Cases
- Log Analysis: Reads and interprets slow-query and super-slow-query logs from SQLite databases used in Flutter apps.
- Pattern Detection: Detects common performance issues such as read waves, N+1 reads, and transaction contention.
- Use Case: A developer notices sluggish app startup; they use this Skill to analyze logs and pinpoint specific query patterns causing slowdown, then optimize indexes or transaction scopes.
Quick Start
Provide the path to the log directory that contains your SQLite slow query logs for immediate analysis.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: analyze-db-logs Download link: https://github.com/matthiasn/lotti/archive/main.zip#analyze-db-logs Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.