SKILL.md - Production AI Database

Overview

Access to New Day Church's AV infrastructure database tracking devices, wires, integration notes, and software across the Enfield campus production environment.

API Endpoint

Base URL: http://10.10.40.91:3002/api
Authentication: None (trusted network)

Resources

Resource	Endpoints	Description
Devices	GET/POST/PUT/DELETE `/devices`, `/devices/:id`	AV equipment, computers, monitors, cameras
Wires	GET/POST/PUT/DELETE `/wires`, `/wires/:id`	Physical connections between devices
Integration Notes	GET/POST/PUT/DELETE `/integration-notes`	Documentation, troubleshooting, setup guides
Software	GET/POST/PUT/DELETE `/software`	Installed software tracking
Settings	GET/POST/PUT/DELETE `/settings/:key`	Configuration keys

Common Query Patterns

List All Devices

bash

curl http://10.10.40.91:3002/api/devices | jq '.[].device_name'

Get Device by ID

bash

curl http://10.10.40.91:3002/api/devices/DEV_027

Find Devices by Type

bash

curl http://10.10.40.91:3002/api/devices | jq '.[] | select(.device_type | contains("camera"))'

Find Devices Not Responding to Ping

bash

curl http://10.10.40.91:3002/api/devices | jq '.[] | select(.ping_responding == false)'

Find Devices with Troubleshooting Notes

bash

curl http://10.10.40.91:3002/api/devices | jq '.[] | select(.troubleshooting_notes | length > 0)'

Device Categories in Database

Video Production

•ATEM Switchers (2/ME Production Studio, Constellation router)
•Cameras (PTZ Panasonic AW-UE150, GH4, EVA1, Marshall)
•Monitors (confidence, production, multiview)
•Projectors (Epson, Panasonic)

Signal Processing

•Magewell Encoders/Decoders (NDI, AIO)
•Blackmagic HyperDeck Recorders
•Ross Router (NK 3G16)
•Micro Converters (HDMI↔SDI)
•Decimators

Audio

•Yamaha QL5 Soundboard
•Q-SYS Core + Touch Controls
•QSC Amplifiers (5 units)
•Pro Tools Audio Computer + Avid S1 Controllers

Control & Infrastructure

•Q-SYS Core (building automation)
•Synology Server (10.10.40.91)
•Director Macs (FOH & Production)
•Graphics Computer (CG1 Mac Studio)
•Prime Computers (tracks)

Computers

•Windows NUC (Q-Sys Designer)
•Mac Minis (various roles)
•Mac Studio (CG1)
•MacBook Air (Prime backup)

Stage Connectivity

•Tie Plates / Wall Boxes (WB-101 through WB-104)
•Stage Boxes (SDI 8-port)
•Teradek Wireless (Cam 7 & 8)

Key Device Types

Type	Description
`atem_1me_constellation`	ATEM router/switcher
`atem_2me`	ATEM 2 M/E Production Studio
`camera`	PTZ cameras (Panasonic)
`monitor`	Various displays
`ross_nk_3g16`	Ross video router
`tie_plate`	Stage wall box connections
`splitter`	SDI/HDMI splitters
`converter`	Format converters
`decoder`	NDI decoders
`server`	Synology NAS
`computer`	Various Mac/Windows PCs

Notable Device Patterns

IP Address Ranges

•10.10.40.x — Production network
•10.11.40.x — Alternative/worship network

Common Credentials

•Username: ndc, Admin, NDC-Admin
•Password pattern: 5eHUBr9w (common), NewDayWorship, systemaccess

Dante License Keys

•Stored in device descriptions
•Multiple virtual soundcard licenses tracked

Integration Notes Use Cases

•Troubleshooting guides — Common fixes for each device
•Connection mappings — How devices interconnect
•Software configurations — Streamdeck, Q-SYS, etc.
•Signal flow documentation — Video/audio routing
•Password/License management — Secure info tracking

Query Examples

Find All Cameras

bash

curl -s http://10.10.40.91:3002/api/devices | jq '.[] | select(.device_name | test("cam|camera"; "i")) | {name: .device_name, ip: .ip_address, location: .location}'

Find Devices Needing Replacement Soon

bash

curl -s http://10.10.40.91:3002/api/devices | jq '.[] | select(.replacement_year <= 2026) | {name: .device_name, year: .replacement_year, purchased: .purchased_year}'

Get All Ping-Offline Devices

bash

curl -s http://10.10.40.91:3002/api/devices | jq '.[] | select(.ping_responding == false) | {name: .device_name, last_seen: .ping_last_change}'

Find Devices by Location

bash

curl -s http://10.10.40.91:3002/api/devices | jq '.[] | select(.location == "Production") | .device_name'

Signal Flow Analysis

Devices have available_ports with:

•inputs — What can connect in
•outputs — What can connect out
•port_mapping — Routing rules (matrix, one_to_one, source, sink, processing)

Port Mapping Types

•matrix — Any input to any output (routers, ATEMs)
•one_to_one — Fixed input-to-output mapping (tie plates)
•source — Output only (cameras, computers)
•sink — Input only (monitors)
•processing — Transforms signal (computers, encoders)

Scripts

Located at: ~/.openclaw/workspace/scripts/production-db/

Helper Scripts (TODO)

•list_devices.sh — All devices with filters
•find_offline.sh — Devices not responding to ping
•trace_signal.sh — Follow signal path through wires
•device_detail.sh — Full device info by name/ID
•export_config.sh — Backup configuration

Maintenance Tasks

•Weekly: Check ping_responding for offline devices
•Monthly: Verify replacement year planning
•Quarterly: Update troubleshooting notes from incidents
•As needed: Add new devices, update wire connections

Security Notes

•No API authentication (internal network only)
•Passwords stored in device descriptions (readable)
•IP addresses in 10.x.x.x range (private network)
•Consider VPN for external access

Integration Ideas

•Link with Asana tasks for equipment issues
•Alert on ping failures
•Auto-generate signal flow diagrams
•Track warranty expiration
•Maintenance scheduling