360 安全技能中心

Pihole Ctl

面向本地 Pi-hole 的管理与监控技能，使用 Python sqlite3 查询 FTL 数据库获取拦截统计和热门域名，并可通过 pihole CLI 启用或禁用拦截、更新 Gravity；需具备数据库读取与相应命令权限。

热度 87.35

最近更新 2026-05-11 16:28:08

分类：自动化依赖：代码执行 / 读写文件应用场景：自动化脚本 / 数据处理 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add pihole-ctl

Metadata

name: pihole-ctl
description: 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".

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

Statistics: Query FTL database for accurate logs (Last 24h, Top Domains).
Management: Enable/Disable blocking (pihole enable/disable).
Blocklists: Update Gravity (pihole -g).
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

Database Schema