All skills
google avatar

/cloud-logging-query-generation

@becc4b8
by googlegoogle/skills21k stars
1,698

Generates Logging Query Language (LQL) queries for Google Cloud Logging from natural language. Use this skill when you need to query log data or when you are debugging issues. You can filter log data by Google Cloud service. Don't use this skill to query other databases, such as SQL or Cloud Spanner.

Use this Skill: https://skilld.dev/gh/google/skills/cloud-logging-query-generation

This session only. Nothing lands on disk.

referencesquery_app_engine.md

≈555 tokens on demand. Your agent reads this file only when SKILL.md points to it.

App Engine LQL queries

Base schema and structural patterns

App Engine logs are anchored to the gae_app resource type.

Targeting specific workloads

  • Service and Version Isolation: Filter using resource.labels.module_id="<MODULE_ID>" (for the Service) and resource.labels.version_id="<VERSION_ID>" (for the Version).

Log routing and correlation

  • Request Logs: Use log_id("appengine.googleapis.com/request_log") to capture HTTP ingress telemetry.
  • Audit Logs: Inspect deployment operations by validating protoPayload.serviceName="appengine.googleapis.com".
  • Trace ID: Correlate all logs emitted during a single HTTP request execution by filtering via trace="projects/<PROJECT_ID>/traces/<TRACE_ID>".

Example queries

High severity errors in a specific time range

Variables to replace: <START_TIME>, <END_TIME>

resource.type="gae_app"
severity >= ERROR
timestamp >= "<START_TIME>"
timestamp <= "<END_TIME>"

HTTP requests that resulted in a 5xx server error

Variables to replace: None

resource.type="gae_app"
log_id("appengine.googleapis.com/request_log")
httpRequest.status >= 500

App Engine logs from New Year's Eve (in UTC time)

Variables to replace: None

resource.type="gae_app" AND
severity>=ERROR AND
timestamp>="2025-12-31T00:00:00Z" AND timestamp<="2026-01-01T00:00:00Z"

Sampled HTTP error logs

Variables to replace: None

resource.type="gae_app" AND
protoPayload.status >= 400 AND
sample(insertId, 0.1)

App Engine log entries with a trace ID

Variables to replace: <PROJECT_ID>, <TRACE_ID>

resource.type="gae_app" AND
trace="projects/<PROJECT_ID>/traces/<TRACE_ID>"

App Engine logs

Variables to replace: <MODULE_ID>, <VERSION_ID>

resource.type="gae_app" AND
resource.labels.module_id="<MODULE_ID>" AND
resource.labels.version_id="<VERSION_ID>"

Log entries from App Engine deployments

Variables to replace: None

resource.type="gae_app" AND
protoPayload.@type="type.googleapis.com/google.cloud.audit.AuditLog" AND
protoPayload.serviceName="appengine.googleapis.com"

Source: SKILL.md on GitHub

No alerts9d3 checks · Risk SAFE
  • Gen Agent Trust Hub9d

    This skill is designed to generate Logging Query Language (LQL) queries for Google Cloud Logging from natural language input. It provides comprehensive reference guides, syntax rules, and examples for various Google Cloud services. No security issues were detected.

  • Socket9d

    No alerts

  • Snyk9d

    Risk: LOW · No issues

Signed by skilld at becc4b8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 weeks ago
metadata
{
  "version": "1.0.0",
  "category": "CloudObservabilityAndMonitoring"
}

README badge

README badge for google/skills/cloud-logging-query-generation