When should Claude use this skill instead of standard shell tools?

Use this skill when datasets exceed 100 records, require complex aggregations like GROUP BY, or need to be queried multiple times for follow-up questions.

Does this skill require any external database servers?

No, it leverages the serverless sqlite3 CLI tool, which is a single-file database format with zero dependencies and no setup required.

Where is the data stored and does it persist?

Data is stored in persistent SQLite database files located at ~/.claude-logs/ .db, allowing analysis to persist across different Claude sessions.

Can I use this for small datasets?

While it works for any size, it is most effective for datasets larger than 50-100 records where manual grep or jq commands become unwieldy.

Structured Logging & SQL Analysis

Name: Structured Logging & SQL Analysis
Author: sjungling

bysjungling

•

Database Management

Replaces complex custom parsing scripts with SQLite for efficient structured data analysis, correlation, and persistent state tracking.

The Structured Logging skill empowers Claude to move beyond brittle jq commands and custom Python parsing scripts by leveraging the power of SQLite for data-heavy tasks. It provides a standardized framework for loading large datasets—such as test results, application logs, or file processing states—into a queryable format. By using SQL for aggregations, joins, and multi-step analysis, it ensures data remains accessible across sessions and handles complex relationships that would otherwise require repetitive boilerplate code or manual data correlation.

Key Features

01Complex aggregation support including GROUP BY, COUNT, and statistical functions

028 GitHub stars

03Standardized persistent storage location for cross-session data analysis

04Elimination of repetitive and brittle manual parsing code in Python or jq

05Automatic SQLite table creation and data ingestion from JSON and CSV sources

06Advanced data correlation using SQL JOINs across disparate log files

Use Cases

01Managing and querying the processing state for massive batch file operations

02Analyzing hundreds of test results to identify flaky tests or specific performance bottlenecks

03Correlating error logs across multiple microservices using timestamps and request IDs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sjungling/sjungling-claude-plugins structured-logging

For use in Claude.ai and ChatGPT

Download Skill