skills/newrelic-cli-skills/infrastructure/SKILL.md
This subskill should be used when investigating New Relic Infrastructure host CPU, memory, disk, network, process, or capacity metrics with the New Relic CLI and NRQL. Use the parent newrelic-cli-skills skill for setup and routing.
npx skillsauth add kilo-org/kilo-marketplace newrelic-cli-infrastructureInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Monitor host metrics (CPU, memory, disk, processes) via New Relic Infrastructure.
newrelic entity search --name "" --type HOST | \
jq '.[] | {name, alertSeverity, guid}'
# Average CPU per host (last hour)
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(cpuPercent)
FROM SystemSample
FACET hostname
TIMESERIES 5 minutes
SINCE 1 hour ago
"
# CPU spikes > 80%
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT percentage(count(*), WHERE cpuPercent > 80) AS 'Time > 80% CPU'
FROM SystemSample
FACET hostname
SINCE 1 hour ago
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(memoryUsedPercent), average(memoryFreeBytes / 1e9) AS 'Free GB'
FROM SystemSample
FACET hostname
TIMESERIES 5 minutes
SINCE 1 hour ago
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT latest(diskUsedPercent)
FROM StorageSample
FACET hostname, mountPoint
SINCE 10 minutes ago
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(receiveBytesPerSecond), average(transmitBytesPerSecond)
FROM NetworkSample
FACET hostname
TIMESERIES 5 minutes
SINCE 1 hour ago
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(cpuPercent)
FROM ProcessSample
WHERE hostname = 'my-host'
FACET processDisplayName
SINCE 30 minutes ago
LIMIT 10
ORDER BY average(cpuPercent) DESC
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(memoryResidentSizeBytes) / 1e6 AS 'RSS MB'
FROM ProcessSample
WHERE hostname = 'my-host'
FACET processDisplayName
SINCE 30 minutes ago
LIMIT 10
ORDER BY average(memoryResidentSizeBytes) DESC
"
# Side-by-side: host CPU vs app response time
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(cpuPercent) AS 'CPU %'
FROM SystemSample
WHERE hostname = 'my-host'
TIMESERIES 5 minutes
SINCE 1 hour ago
"
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID --query "
SELECT average(duration) AS 'Avg Response (s)'
FROM Transaction
WHERE appName = 'my-app'
TIMESERIES 5 minutes
SINCE 1 hour ago
"
# Compare the two time series to see if CPU pressure correlates with slowdowns
newrelic entity search --name "" --type HOST | \
jq '.[] | {name, reporting}'
development
Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.
documentation
Patterns for reading and writing oleander Iceberg catalog tables in Spark jobs, including naming conventions, write modes, and catalog hierarchy.
data-ai
Integrate Okta for enterprise identity workflows including OIDC login, group claims, and policy-based access controls. Use when implementing workforce or B2B identity scenarios.
documentation
Use when arranging Apache NiFi processors, process groups, ports, comments, numbering, crossing connections, dense fan-in/fan-out, or reusable readable canvas layouts.