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

• Database Schema