Skip to content
cccskills
FreePublished on GitHub

pihole-ctl

Manage and monitor local Pi-hole instance. Query FTL database for statistics (blocked ads, top clients) and control service via CLI. Use when user asks "how many ads blocked", "pihole status", or "update gravity".

The English summary is being prepared. Showing the original description.

See how to install

Files included (4)

  • SKILL.md1.4 KB
  • _meta.json275 B
  • references/db-schema.md537 B
  • scripts/query_db.py2.9 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Pi-hole Controller

Usage

  • Role: Network Guardian.
  • Trigger: "Check Pi-hole", "Adblock status", "Who is querying top domains?".
  • Output: JSON stats or CLI command results.

Capabilities

  1. Statistics: Query FTL database for accurate logs (Last 24h, Top Domains).
  2. Management: Enable/Disable blocking (pihole enable/disable).
  3. Blocklists: Update Gravity (pihole -g).
  4. Audit: Identify chatty clients or top blocked domains.

Scripts

  • scripts/query_db.py: Python script using native sqlite3 library to query Pi-hole stats safely.
    • Requires read permission on /etc/pihole/pihole-FTL.db.
    • Usage: python3 scripts/query_db.py --summary --hours 24
    • Usage: python3 scripts/query_db.py --top 10

Permissions

  • Database Access: The user running this skill must have read access to /etc/pihole/pihole-FTL.db.
    • Recommended: Add user to pihole group (usermod -aG pihole ubuntu).
  • Management Commands: pihole CLI commands (enable/disable) require sudo or must be run by a user with appropriate permissions.

Reference Materials

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Agents can sign plugins, rotate credentials without losing identity, and publicly attest to behavior.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

Query historical crypto market data from 0xArchive across Hyperliquid, Lighter.xyz, and HIP-3. Covers orderbooks, trades, candles, funding rates, open interest, liquidations, and data quality. Use when the user asks about crypto market data, orderbooks, trades, funding rates, or historical prices on Hyperliquid, Lighter.xyz, or HIP-3.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

Calculate ROI for AI-as-a-Service (managed AI agents). Estimates cost savings, efficiency gains, and payback period for deploying AI agents across business operations. Use when evaluating whether managed AI agents make financial sense for a company.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

Design, build, deploy, and operate production AI agent systems — single agents, multi-agent teams, and autonomous swarms. Complete methodology from agent architecture through orchestration, memory systems, safety guardrails, and operational excellence.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

Design, build, test, document, and secure production-grade APIs. Covers the full lifecycle from schema design through deployment, monitoring, and versioning. Use when designing new APIs, reviewing existing ones, generating OpenAPI specs, building test suites, or debugging production issues.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

Turn your AI agent into a business automation architect. Design, document, implement, and monitor automated workflows across sales, ops, finance, HR, and support — no n8n or Zapier required.

The English summary is being prepared. Showing the original description.

johnalbertini14-glitch/openclaw-skills2Updated Feb 26, 2026

See all skills by johnalbertini14-glitch

Report a problem with this skill