Observability Newrelic

New Relic Observability

Authentication

IMPORTANT: Credentials are injected automatically by a proxy layer. Do NOT check for NEWRELIC_API_KEY in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.

Configuration environment variables you CAN check (non-secret):

• NEWRELIC_ACCOUNT_ID - New Relic account ID
• NEWRELIC_BASE_URL - API base URL (proxy mode)

---

Available Scripts

All scripts are in .claude/skills/observability-newrelic/scripts/

query_nrql.py - Run NRQL Queries (START HERE)

python .claude/skills/observability-newrelic/scripts/query_nrql.py --account-id ACCOUNT_ID --query "SELECT average(duration) FROM Transaction SINCE 1 hour ago"

getapmsummary.py - APM Summary

python .claude/skills/observability-newrelic/scripts/get_apm_summary.py --account-id ACCOUNT_ID --app-name MyApp [--time-range 30m]

---

NRQL Query Reference

-- Response time
SELECT average(duration) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago

-- Throughput
SELECT count(*) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago TIMESERIES 5 minutes

-- Error rate
SELECT percentage(count(*), WHERE error = true) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago

-- Apdex score
SELECT apdex(duration, t: 0.5) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago

-- Slowest transactions
SELECT average(duration), count(*) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago FACET name LIMIT 10

-- Database query time
SELECT average(databaseDuration) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago TIMESERIES

-- External service calls
SELECT average(externalDuration), count(*) FROM Transaction WHERE appName = 'MyApp' SINCE 1 hour ago FACET externalTransactionName

---

Investigation Workflow

Application Performance Issue

1. get_apm_summary.py --account-id  --app-name  (overview)
2. query_nrql.py --query "SELECT average(duration) FROM Transaction WHERE appName = '' SINCE 1 hour ago TIMESERIES 5 minutes"
3. query_nrql.py --query "SELECT percentage(count(*), WHERE error = true) FROM Transaction WHERE appName = '' SINCE 1 hour ago TIMESERIES 5 minutes"

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: swapnildahiphale
• Source: swapnildahiphale/OpenSRE
• License: Apache-2.0
• Homepage: https://opensre.in

Install and usage instructions live in the source repository linked above.