Mz Query Tracing
MaterializeInc/materialize
Debug SQL execution time via distributed tracing (OpenTelemetry / Tempo).
Agent skill
Flyio Reference Architecture
by jeremylongshore in jeremylongshore/tons-of-skills-marketplace
Design a Fly.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries.
Install Flyio Reference Architecture
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architecture --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .claude/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .claude/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architectureType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architecture --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .agents/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .agents/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architecture --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .cursor/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .cursor/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace.git --path skills/.curated/flyio-reference-architecture--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architecture --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .gemini/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .gemini/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architectureInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .github/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .github/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-reference-architecture --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/.curated/flyio-reference-architecture .opencode/skills/flyio-reference-architecture && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "flyio-reference-architecture" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-reference-architecture into .opencode/skills/flyio-reference-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-reference-architecture", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
flyio-reference-architecture- GitHub stars
- 2.8k
- Token cost
- ~1.3k tokens
- SKILL.md length
- 503 words
- Files
- 2 (incl. references)
- Skills in repo
- 3,342
- Repo updated
- First seen
- Licence
- MIT
At a glance
Design a Fly.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries.
- Works in 6 steps: Partition stateless and stateful work → Design routing and placement → Design the Machine fleet → …
- Reviewing a production topology
- SKILL.md covers Overview, Prerequisites, Instructions and Authentication, plus 5 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Flyio Reference Architecture is an agent skill from jeremylongshore/tons-of-skills-marketplace. Design a Fly.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries. Use when reviewing a production topology. Trigger with: "architect app on Fly", "design multi-region Fly service", "review Fly platform topology".
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/official-docs.md`). Compatibility notes: Requires workload and data requirements, service objectives, approved regions, dependency ownership, and a cost and recovery model.
It sits in DevOps & Cloud, covering Observability. It works with PostgreSQL. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.
When your agent uses it
- Reviewing a production topology
- With: architect app on Fly
- Design multi-region Fly service
- Review Fly platform topology
Example prompts
- “architect app on Fly”
- “design multi-region Fly service”
- “review Fly platform topology”
- “/flyio-reference-architecture”
Requirements
- Compatibility (from SKILL.md): Requires workload and data requirements, service objectives, approved regions, dependency ownership, and a cost and recovery model.
- Pre-approved tools (allowed-tools): Read, Grep, Write, Edit
Workflow steps
6 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves these tools, so the agent can use them without asking each time:
ReadGrepWriteEdit
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
fly.io
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Compatibility
Requires workload and data requirements, service objectives, approved regions, dependency ownership, and a cost and recovery model.
From compatibility in the SKILL.md frontmatter.
Context cost
Flyio Reference Architecture loads about 1.3k tokens when it runs, and up to ~1.8k if it reads all its reference files. Until then it costs about 78 tokens; SKILL.md has 503 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 503 words, ~1,296 tokens.
Download SKILL.mdSave it as
.claude/skills/flyio-reference-architecture/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- flyio-reference-architecture
- description
- Design a Fly.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries. Use when reviewing a production topology. Trigger with: "architect app on Fly", "design multi-region Fly service", "review Fly platform topology".
- allowed-tools
- Read, Grep, Write, Edit
- compatibility
- Requires workload and data requirements, service objectives, approved regions, dependency ownership, and a cost and recovery model.
- version
- 2.0.0
- argument-hint
- [workload-regions-and-data-contract]
- model
- inherit
- effort
- high
- license
- MIT
- author
- Jeremy Longshore <jeremy@intentsolutions.io>
- tags
- saas, flyio, architecture, multi-region, resilience
Fly.io Multi-Region Application Architecture
Overview
Compose Fly.io primitives without implying global state that the platform does not provide. Anycast and Fly Proxy route toward Machines, 6PN connects services inside an organization, Machines and volumes are regional, and Managed Postgres has its own supported-region and recovery contract.
Prerequisites
- Users, traffic, latency, availability, residency, recovery, and consistency requirements
- Service and process-group boundaries plus external dependencies
- Current provider regions, capacity, pricing, and Managed Postgres availability
Instructions
Step 1: Partition stateless and stateful work
Separate request-serving, workers, scheduled tasks, caches, durable databases, and region-local files. Name the system of record for every data class.
Step 2: Design routing and placement
Choose primary and secondary regions from observed users, dependency location, residency, and capacity. Document Fly Proxy, public IP, Flycast, or dynamic routing behavior.
Step 3: Design the Machine fleet
Set process groups, VM resources, Machine counts, health checks, deployment strategy, autostart, shutdown, and failure-domain expectations per region.
Step 4: Design data explicitly
Use Managed Postgres where its service contract fits. Use volumes only with software-managed replication and recovery or for disposable regional state; never present one volume as multi-region storage.
Step 5: Design private and external connectivity
Map 6PN names, organization boundaries, WireGuard peers, outbound requirements, certificates, DNS, and third-party trust zones.
Step 6: Prove resilience and operations
Exercise regional and dependency failure, deploy rollback, database restore, volume restore, secret rotation, monitoring, cost controls, and ownership handoff.
Authentication
Use separate scoped identities for deployment, observation, database access, and external integrations. Protect 6PN and WireGuard credentials, App secrets, and database URLs; private networking narrows reachability but does not replace application authentication.
Tool Discipline
Use Read and Grep to inspect application configuration, deployment evidence, provider documentation, fixtures, logs, schemas, and existing tests before proposing a change. Use Write or Edit only for an approved plan, configuration, implementation, test, or redacted receipt. Do not create, deploy, scale, restart, stop, suspend, destroy, rotate, revoke, expose, or migrate live Fly.io resources without explicit operator approval.
Show full SKILL.md (177 more words)Show less
Output
- Architecture diagram and authority map
- Region, routing, Machine, data, identity, observability, cost, and recovery decisions
- Failure-mode exercises with measured recovery and unresolved risks
Return the target organization, app, environment, region set, Machine or database identifiers, source-contract fingerprint, evidence, unresolved risks, rollback state, and final decision without exposing tokens, secrets, connection strings, or customer data.
Examples
A global API runs stateless Machines in three evidence-selected regions while writes stay close to Managed Postgres in a supported primary region. Fly Proxy routing, read behavior, failure fallback, and database recovery are explicit; a cache volume is treated as disposable regional state.
Error Handling
| Failure | Response |
|---|---|
| Topology assumes global volume storage | Replace the assumption with Managed Postgres, an external replicated store, or application-managed replication. |
| Region lacks required service or capacity | Choose from current provider data and revisit latency, residency, and recovery tradeoffs. |
| Private path crosses organizations | Use an explicitly approved inter-network mechanism and application authentication; same-organization 6PN assumptions do not apply. |
Resources
© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 1 other file (references) in skills/.curated/flyio-reference-architecture of jeremylongshore/tons-of-skills-marketplace.
- SKILL.md
- references/official-docs.md
Open the folder on GitHubat commit cfae287
Compare with similar skills
Flyio Reference Architecture next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Flyio Reference Architecture this skilljeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | |
| Mz Query TracingMaterializeInc/materialize | 6.4k | — | ~1.8k | Automated safety check: Pass | Custom licence | |
| Database Observabilitygrafana/skills | 282 | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | |
| Database ObservabilityKilo-Org/kilo-marketplace | 190 | — | ~1.4k | Automated safety check: Pass | Apache-2.0 | |
| Neonsmontlouis/bible-strong | 172 | — | ~7.1k | Automated safety check: Notes | GPL-3.0 | |
| Gaik Add ExamplesGAIK-project/gaik-toolkit | 100 | — | ~2.4k | Automated safety check: Notes | MIT |
Similar skills
- Official
Database Observability
grafana/skills
Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables pgstatstatements / Performance Schema, creates a least-privilege monitoring user, configures the…
Database Observability
Kilo-Org/kilo-marketplace
Grafana Cloud Database Observability — query-level performance insights for MySQL and PostgreSQL.
Neon
smontlouis/bible-strong
Overview of Neon, a complete set of cloud backend primitives for apps and agents, spanning Lakebase Postgres, Auth, the Data API, Object Storage, Compute Functions, and the AI Gateway.
Gaik Add Examples
GAIK-project/gaik-toolkit
Adds or updates working code examples for GAIK toolkit components and pipelines in implementationlayer/examples/.
- Official
Vercel Optimize Audit
vercel-labs/agent-skills
Runs a metrics-first audit of a deployed Vercel project, gating investigations on real signals to produce ranked, citation-backed cost and performance recommendations.
More from jeremylongshore/tons-of-skills-marketplace
All 3,342 skills in this repoPerforming Security Code Review
jeremylongshore/tons-of-skills-marketplace
Execute this skill enables AI assistant to conduct a security-focused code review using the security-agent plugin.
Adapting Transfer Learning Models
jeremylongshore/tons-of-skills-marketplace
Build this skill automates the adaptation of pre-trained machine learning models using transfer learning techniques.
Agent Context Loader
jeremylongshore/tons-of-skills-marketplace
Execute proactive auto-loading: automatically detects and loads agents.md files.
Aggregating Performance Metrics
jeremylongshore/tons-of-skills-marketplace
Aggregate and centralize performance metrics from applications, systems, databases, caches, and services.
Analyzing Capacity Planning
jeremylongshore/tons-of-skills-marketplace
Execute this skill enables AI assistant to analyze capacity requirements and plan for future growth.
Analyzing Database Indexes
jeremylongshore/tons-of-skills-marketplace
Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.
Related
Works with
Categories
Questions about Flyio Reference Architecture
What does Flyio Reference Architecture do?
Design a Fly.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries. Flyio Reference Architecture is an agent skill from jeremylongshore/tons-of-skills-marketplace.io multi-region architecture with explicit routing, Machine, data, private-network, observability, and recovery boundaries.
When should I use Flyio Reference Architecture?
Flyio Reference Architecture fits situations like: reviewing a production topology; with: architect app on Fly; design multi-region Fly service; review Fly platform topology.
How do I install Flyio Reference Architecture in Claude Code?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a claude-code`. Or copy the skill folder (skills/.curated/flyio-reference-architecture in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/flyio-reference-architecture in your project. Claude Code loads it when a task matches its description.
How do I install Flyio Reference Architecture in Codex?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a codex`. Or copy the skill folder (skills/.curated/flyio-reference-architecture in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/flyio-reference-architecture in your project. Codex loads it when a task matches its description.
Can I use Flyio Reference Architecture in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-reference-architecture -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/flyio-reference-architecture, .gemini/skills/flyio-reference-architecture, .github/skills/flyio-reference-architecture and .opencode/skills/flyio-reference-architecture in your project.
What does Flyio Reference Architecture need to run?
SKILL.md names no scripts, command-line tools or credentials: Flyio Reference Architecture is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Grep, Write, Edit. Compatibility (from SKILL.md): Requires workload and data requirements, service objectives, approved regions, dependency ownership, and a cost and recovery model..
Does Flyio Reference Architecture access the network?
SKILL.md names 1 domain. As links in the text: fly.io. This is read from the text; nothing was executed.
Is Flyio Reference Architecture safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Flyio Reference Architecture use?
Flyio Reference Architecture is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Flyio Reference Architecture use?
About 1.3k tokens (SKILL.md is roughly 5.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 507 tokens, read only when the agent opens those files.
What are the alternatives to Flyio Reference Architecture?
Skills that share tags, products or a category with Flyio Reference Architecture: Mz Query Tracing (MaterializeInc/materialize, 6.4k stars), Database Observability (grafana/skills, 282 stars), Database Observability (Kilo-Org/kilo-marketplace, 190 stars) and Neon (smontlouis/bible-strong, 172 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Flyio Reference Architecture?
jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.
Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.