pihole-csv-analyzer SKILL.md skillA

pihole-csv-analyzer from mickpletcher/ai-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add mickpletcher/ai-skills/pihole-csv-analyzer@v1.1.0

Pins v1.1.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
mickpletcher/ai-skills
Path
claude/skills/pihole-csv-analyzer/SKILL.md
Versions recorded
5
Latest version
v1.1.0, committed Jun 10, 2026
First version recorded
Apr 24, 2026
Size
9,622 bytes
Repository stars
20
License
MIT

Analyze CSV exports from Pi-hole such as query logs, top domains, top clients, or adlist exports and produce actionable recommendations. Trigger immediately when the user uploads or mentions a Pi-hole CSV file, types "pihole" or "ph analyze", or asks to analyze DNS query data, blocklist hits, or Pi-hole exports. Produce an in-chat analysis plus candidate blocklist and allowlist outputs for review.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Pi-hole CSV Analyzer

## Intent

Analyze Pi-hole CSV exports to identify query patterns, noisy clients, allowlist candidates, blocklist candidates, and cleanup actions.

## Use When

- The user explicitly asks for `pihole-csv-analyzer`.
- The request matches the triggers or workflow described below.
- The task benefits from a reusable, structured output instead of a one-off answer.

## Do Not Use When

- Do not use without CSV or equivalent query data, for generic Pi-hole setup, or for changes that cannot be traced to export evidence.
- Required context is missing and cannot be reasonably inferred.
- A more specific skill in this repo is a better match.

## Workflow

1. Identify the exact task and available source material.
2. Apply the domain rules and output format in this skill.
3. State assumptions, uncertainty, and missing inputs clearly.
4. Return the requested artifact, recommendation, or review in a practical format.
5. Check the result against the validation checklist before finishing.

## Constraints

- Do not fabricate missing facts, measurements, dates, sources, or user context.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add mickpletcher/ai-skills/pihole-csv-analyzer@sha256:26231bc061ac1b59

The line at the top of this page pins the label v1.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_fwp2nuulnnqay4gp.svg)](https://markdownregistry.com/a/art_fwp2nuulnnqay4gp)

1 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, between Apr 24, 2026 and Jun 10, 2026, about one every 12 days.

versioncommittedcommitsizeaudit
v1.1.0 latest2026-06-10 d1e991f 9,622 BA view · diff
git:20260609.a0be1e42026-06-09 a0be1e4 7,891 BA view · diff
git:20260522.736a01e2026-05-22 736a01e 7,677 BA view · diff
git:20260514.3080b382026-05-14 3080b38 5,964 BA view · diff
git:20260424.ae606842026-04-24 ae60684 5,262 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (9622 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

mickpletcher/ai-skills · 20 stars · license MIT · pushed 2026-10-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_fwp2nuulnnqay4gp
GET https://markdownregistry.com/api/v1/resolve?ref=mickpletcher/ai-skills/pihole-csv-analyzer
GET https://markdownregistry.com/api/v1/blob/26231bc061ac1b59b6202499d338f46d12f38a1de62a512cfbe8c9d772a9760c

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from mickpletcher/ai-skills

alpaca-trading SKILL.md skill
mickpletcher/ai-skills · claude/skills/alpaca-trading/SKILL.md · Work safely in the Trading repository for Alpaca helpers, backtesting, journaling, scheduling, and related PowerShell…
v1.1.0 · audit A · 20 stars
astrophotography-processing SKILL.md skill
mickpletcher/ai-skills · claude/skills/astrophotography-processing/SKILL.md · Router for astrophotography processing, troubleshooting, and safe workflow guidance across deep-sky, narrowband…
git:20261013.4e6bf9e · audit A · 20 stars
blog-post SKILL.md skill
mickpletcher/ai-skills · claude/skills/blog-post/SKILL.md · Write or draft a blog post for Mick's IT blog at mickitblog.blogspot.com. Trigger when Mick asks for a blog post or…
v1.1.0 · audit A · 20 stars
blog-to-social SKILL.md skill
mickpletcher/ai-skills · claude/skills/blog-to-social/SKILL.md · Convert a finished blog post into three ready-to-post social media versions in one pass for Facebook, X, and LinkedIn…
v1.1.0 · audit A · 20 stars
container-home SKILL.md skill
mickpletcher/ai-skills · claude/skills/container-home/SKILL.md · Answer questions, assist with planning, and help with design decisions for Mick's off-grid shipping container lake home…
v1.1.0 · audit A · 20 stars
crypto-listings SKILL.md skill
mickpletcher/ai-skills · claude/skills/crypto-listings/SKILL.md · Retrieve new cryptocurrency listings from the past 7 days and upcoming listings in the next 7 days across major…
v1.1.0 · audit A · 20 stars
crypto-research SKILL.md skill
mickpletcher/ai-skills · claude/skills/crypto-research/SKILL.md · Deep-dive research report on a specific cryptocurrency before trading or investing. Always trigger immediately when the…
v1.1.0 · audit A · 20 stars
facebook-post SKILL.md skill
mickpletcher/ai-skills · claude/skills/facebook-post/SKILL.md · Write and polish Facebook posts on any topic. Trigger on requests to draft, rewrite, polish, improve a Facebook post…
v1.6.0 · audit A · 20 stars
facebook-reply SKILL.md skill
mickpletcher/ai-skills · claude/skills/facebook-reply/SKILL.md · Write replies to Facebook comments on Mick's posts. Trigger on requests to reply to a Facebook comment, especially when…
v1.2.0 · audit A · 20 stars
fitness-log SKILL.md skill
mickpletcher/ai-skills · claude/skills/fitness-log/SKILL.md · Track workouts, log fitness progress, adjust the training program, and generate Facebook posts from workout data…
v1.3.0 · audit A · 20 stars
fitness-programming SKILL.md skill
mickpletcher/ai-skills · claude/skills/fitness-programming/SKILL.md · Build structured training plans, progression blocks, and goal-specific fitness programming for Mick. Trigger when the…
v1.2.0 · audit A · 20 stars
food-analyzer SKILL.md skill
mickpletcher/ai-skills · claude/skills/food-analyzer/SKILL.md · Analyze food photos, nutrition labels, and ingredient lists. Trigger on food images, nutrition label scans, macro…
v1.3.0 · audit A · 20 stars

Every file in mickpletcher/ai-skills

Browse by kind, by grade A, or by owner.