Tutorial and tips for GitHub Actions workflows
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Github.com ui .currently does not natively supoport search for multiple topic tags as of now. However their api allows you to query multiple tags. Below is a simple example to query github.com with ecs and go topic tags. | |
| curl -H "Accept: application/vnd.github.mercy-preview+json" \ | |
| https://api.github.com/search/repositories?q=topic:ecs+topic:go | |
| Response from the github can be rather verbose so lets filter only relavant info such repo url and description. | |
| curl -H "Accept: application/vnd.github.mercy-preview+json" \ | |
| https://api.github.com/search/repositories\?q\=topic:ecs+topic:go | jq '.items[] | {url:.url, description:.description}' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| TIMESTAMP_TRUNC(jobs.start_time, second) as sec, | |
| SUM(SAFE_DIVIDE(total_slot_ms, TIMESTAMP_DIFF(end_time, start_time, MILLISECOND))) AS Slot_Count, project_ID as project | |
| FROM | |
| `region-us`.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION jobs | |
| WHERE jobs.start_time BETWEEN TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 3 DAY) AND CURRENT_TIMESTAMP() | |
| GROUP BY project_id, sec | |
| ORDER BY sec DESC |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # calculate sha256 hash from a pub key to compare to github deploy key | |
| KEY=$1 | |
| KEYPATH="~/.ssh/${KEY}.pub" | |
| ssh-keygen -E sha256 -l -f "$KEYPATH" |
Companion prompts for the video: OpenClaw after 50 days: 20 real workflows (honest review)
These are the actual prompts I use for each use case shown in the video. Copy-paste them into your agent and adjust for your setup. Most will work as-is or the agent will ask you clarifying questions.
Each prompt describes the intent clearly enough that the agent can figure out the implementation details. You don't need to hand-hold it through every step.
My setup: OpenClaw running on a VPS, Discord as primary interface (separate channels per workflow), Obsidian for notes (markdown-first), Coolify for self-hosted services.
OlderNewer