# Log Analysis SQLite

> Use this tool when you need to analyze and troubleshoot large volumes of log data from applications. It creates a structured SQLite database from compressed log files, allowing for querying by log level, timestamp, and module to identify error patterns and generate insights. The tool is ideal for extracting error data and supporting further analysis in Parquet format.

Canonical page: https://skillsregistry.net/skills/direkt-log-analysis-sqlite  
JSON: https://api.skillsregistry.net/v1/skills/direkt-log-analysis-sqlite

## Description

This SQLite MCP server implementation enables AI assistants to analyze log files by creating and querying a structured database from compressed log data. It processes gzipped log files into an SQLite database with tables for logs, stack traces, and parsing errors, while providing tools to extract error data to Parquet format for further analysis. The server supports querying by log level, timestamp, and module, making it valuable for troubleshooting application issues, identifying error patterns, and generating insights from large volumes of log data.

## Trust

- **Trust score (0–1):** 0.63
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-02

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/direkt-log-analysis-sqlite)
- **Repository:** <https://github.com/direkt/mcp-test>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "direkt-log-analysis-sqlite"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/direkt-log-analysis-sqlite` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/direkt-log-analysis-sqlite/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt