How do I install the Newrelic CLI Nrql skill?

Run npx skillmds@latest add kilo-org/newrelic-cli-nrql in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Newrelic CLI Nrql safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Newrelic CLI Nrql?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Newrelic CLI Nrql free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Newrelic CLI Nrql?

Kilo-Org (@kilo-org) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Newrelic CLI Nrql by kilo-org — Agent Skill

Name: Newrelic CLI Nrql
Author: Kilo-Org

Newrelic CLI Nrql

This subskill should be used when composing or running ad hoc NRQL queries for New Relic telemetry, facets, time windows, rates, and comparisons. Use newrelic-nrql-debug-ladder instead for failing, empty, or schema-mismatched queries.

Kilo-Org ff3804a 3.0 KB Updated Sep 17, 2026

File contents

NRQL Queries

Run ad-hoc NRQL queries against your New Relic account.

Basic Syntax

newrelic nrql query \
  --accountId $NEW_RELIC_ACCOUNT_ID \
  --query "YOUR NRQL HERE"

Key Event Types

Event Type	What it tracks
`Transaction`	Web/non-web request timings
`TransactionError`	Exceptions and errors
`DatabaseTrace`	Individual DB query timings
`ExternalTrace`	Outbound HTTP calls
`SystemSample`	Host CPU, memory, disk
`ProcessSample`	Per-process metrics
`Log`	Log lines (if log forwarding enabled)
`PageView`	Browser page load events
`JavaScriptError`	Front-end JS errors

Common Patterns

Response Time

SELECT average(duration), percentile(duration, 95, 99)
FROM Transaction
WHERE appName = 'my-app'
TIMESERIES 5 minutes
SINCE 1 hour ago

Error Rate

SELECT percentage(count(*), WHERE error IS true) AS 'Error %'
FROM Transaction
WHERE appName = 'my-app'
TIMESERIES 5 minutes
SINCE 1 hour ago

Throughput (RPM)

SELECT rate(count(*), 1 minute) AS 'RPM'
FROM Transaction
WHERE appName = 'my-app'
TIMESERIES
SINCE 1 hour ago

Slowest Endpoints

SELECT average(duration)
FROM Transaction
WHERE appName = 'my-app'
FACET name
SINCE 1 hour ago
LIMIT 10
ORDER BY average(duration) DESC

DB Bottlenecks

SELECT average(duration), count(*)
FROM DatabaseTrace
WHERE appName = 'my-app'
FACET statement
SINCE 1 hour ago
LIMIT 10
ORDER BY average(duration) DESC

Compare Two Time Windows

SELECT average(duration)
FROM Transaction
WHERE appName = 'my-app'
SINCE 1 hour ago
COMPARE WITH 1 day ago

Count Errors by Type

SELECT count(*)
FROM TransactionError
WHERE appName = 'my-app'
FACET error.class
SINCE 1 hour ago

Host CPU

SELECT average(cpuPercent)
FROM SystemSample
FACET hostname
TIMESERIES 5 minutes
SINCE 1 hour ago

Host Memory

SELECT average(memoryUsedPercent)
FROM SystemSample
FACET hostname
TIMESERIES 5 minutes
SINCE 1 hour ago

Time Range Shortcuts

SINCE 30 minutes ago
SINCE 1 hour ago
SINCE 3 hours ago
SINCE 1 day ago
SINCE 1 week ago
SINCE '2026-02-01 00:00:00' UNTIL '2026-02-02 00:00:00'

Useful Clauses

FACET name          -- group by field
TIMESERIES 5 min    -- time series chart
LIMIT 20            -- max results
ORDER BY count() DESC
COMPARE WITH 1 day ago
WHERE appName = 'x' AND duration > 1

Output Formatting

# Raw JSON
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID \
  --query "SELECT count(*) FROM Transaction SINCE 1 hour ago" \
  --format json

# Pretty table (default)
newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID \
  --query "SELECT count(*) FROM Transaction SINCE 1 hour ago"

---name: newrelic-cli-nrqldescription: This subskill should be used when composing or running ad hoc NRQL queries for New Relic telemetry, facets, time windows, rates, and comparisons. Use newrelic-nrql-debug-ladder instead for failing, empty, or schema-mismatched queries.---# NRQL QueriesRun ad-hoc NRQL queries against your New Relic account.---## Basic Syntax```bashnewrelic nrql query \ --accountId $NEW_RELIC_ACCOUNT_ID \ --query "YOUR NRQL HERE"```---## Key Event Types| Event Type | What it tracks ||---|---|| `Transaction` | Web/non-web request timings || `TransactionError` | Exceptions and errors || `DatabaseTrace` | Individual DB query timings || `ExternalTrace` | Outbound HTTP calls || `SystemSample` | Host CPU, memory, disk || `ProcessSample` | Per-process metrics || `Log` | Log lines (if log forwarding enabled) || `PageView` | Browser page load events || `JavaScriptError` | Front-end JS errors |---## Common Patterns### Response Time```nrqlSELECT average(duration), percentile(duration, 95, 99)FROM TransactionWHERE appName = 'my-app'TIMESERIES 5 minutesSINCE 1 hour ago```### Error Rate```nrqlSELECT percentage(count(*), WHERE error IS true) AS 'Error %'FROM TransactionWHERE appName = 'my-app'TIMESERIES 5 minutesSINCE 1 hour ago```### Throughput (RPM)```nrqlSELECT rate(count(*), 1 minute) AS 'RPM'FROM TransactionWHERE appName = 'my-app'TIMESERIESSINCE 1 hour ago```### Slowest Endpoints```nrqlSELECT average(duration)FROM TransactionWHERE appName = 'my-app'FACET nameSINCE 1 hour agoLIMIT 10ORDER BY average(duration) DESC```### DB Bottlenecks```nrqlSELECT average(duration), count(*)FROM DatabaseTraceWHERE appName = 'my-app'FACET statementSINCE 1 hour agoLIMIT 10ORDER BY average(duration) DESC```### Compare Two Time Windows```nrqlSELECT average(duration)FROM TransactionWHERE appName = 'my-app'SINCE 1 hour agoCOMPARE WITH 1 day ago```### Count Errors by Type```nrqlSELECT count(*)FROM TransactionErrorWHERE appName = 'my-app'FACET error.classSINCE 1 hour ago```### Host CPU```nrqlSELECT average(cpuPercent)FROM SystemSampleFACET hostnameTIMESERIES 5 minutesSINCE 1 hour ago```### Host Memory```nrqlSELECT average(memoryUsedPercent)FROM SystemSampleFACET hostnameTIMESERIES 5 minutesSINCE 1 hour ago```---## Time Range Shortcuts```SINCE 30 minutes agoSINCE 1 hour agoSINCE 3 hours agoSINCE 1 day agoSINCE 1 week agoSINCE '2026-02-01 00:00:00' UNTIL '2026-02-02 00:00:00'```---## Useful Clauses```nrqlFACET name -- group by fieldTIMESERIES 5 min -- time series chartLIMIT 20 -- max resultsORDER BY count() DESCCOMPARE WITH 1 day agoWHERE appName = 'x' AND duration > 1```---## Output Formatting```bash# Raw JSONnewrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID \ --query "SELECT count(*) FROM Transaction SINCE 1 hour ago" \ --format json# Pretty table (default)newrelic nrql query --accountId $NEW_RELIC_ACCOUNT_ID \ --query "SELECT count(*) FROM Transaction SINCE 1 hour ago"```

Frequently asked questions