oulang-data-query

Installation
SKILL.md

Oulang Data Query — Agent Instructions

Authentication

BigQuery (gold tables + live MySQL)

import jwt, time, json, urllib.request, urllib.parse
SA_EMAIL = "googleplay@megacursos.iam.gserviceaccount.com"
# Get PRIVATE_KEY from agent memory or repo env
now = int(time.time())
payload = {"iss": SA_EMAIL, "sub": SA_EMAIL, "aud": "https://oauth2.googleapis.com/token",
           "iat": now, "exp": now + 3600, "scope": "https://www.googleapis.com/auth/cloud-platform"}
signed_jwt = jwt.encode(payload, PRIVATE_KEY, algorithm="RS256")
data = urllib.parse.urlencode({"grant_type": "urn:ietf:params:oauth:grant-type:jwt-bearer", "assertion": signed_jwt}).encode()
TOKEN = json.loads(urllib.request.urlopen(urllib.request.Request("https://oauth2.googleapis.com/token", data=data, headers={"Content-Type": "application/x-www-form-urlencoded"})).read())["access_token"]
Installs
2
First Seen
Apr 14, 2026