Find Hypertable Candidates
timescale/pg-aiguide
A skill your agent uses to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.
Analyze Fly.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices.
Install Flyio Cost Tuning
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-cost-tuning -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-cost-tuning --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-cost-tuning .claude/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .claude/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuningType 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-cost-tuning -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-cost-tuning --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-cost-tuning .agents/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .agents/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuning -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-cost-tuning --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-cost-tuning .cursor/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .cursor/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuning--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-cost-tuning -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace flyio-cost-tuning --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-cost-tuning .gemini/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .gemini/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuningInstalls 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-cost-tuning -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-cost-tuning .github/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .github/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuning -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-cost-tuning --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-cost-tuning .opencode/skills/flyio-cost-tuning && 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-cost-tuning" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/flyio-cost-tuning into .opencode/skills/flyio-cost-tuning/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "flyio-cost-tuning", 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-cost-tuning- GitHub stars
- 2.8k
- Token cost
- ~1.2k tokens
- SKILL.md length
- 497 words
- Files
- 2 (incl. references)
- Skills in repo
- 3,342
- Repo updated
- First seen
- Licence
- MIT
At a glance
Analyze Fly.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices.
- Works in 6 steps: Reconcile the bill to resources → Measure utilization and state → Evaluate autostop safely → …
- Forecasting capacity
- 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 Cost Tuning is an agent skill from jeremylongshore/tons-of-skills-marketplace. Analyze Fly.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices. Use when reducing spend or forecasting capacity. Trigger with: "audit Fly bill", "right-size Fly Machines", "reduce Fly idle cost".
Its SKILL.md is about 1.2k 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 current billing exports or invoices, app and database inventory, utilization evidence, service objectives, and an approved optimization window.
It sits in Data & Analytics, covering Forecasting and time series. 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
- Forecasting capacity
- With: audit Fly bill
- Right-size Fly Machines
- Reduce Fly idle cost
Example prompts
- “audit Fly bill”
- “right-size Fly Machines”
- “reduce Fly idle cost”
- “/flyio-cost-tuning”
Requirements
- Compatibility (from SKILL.md): Requires current billing exports or invoices, app and database inventory, utilization evidence, service objectives, and an approved optimization window.
- 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 current billing exports or invoices, app and database inventory, utilization evidence, service objectives, and an approved optimization window.
From compatibility in the SKILL.md frontmatter.
Context cost
Flyio Cost Tuning loads about 1.2k tokens when it runs, and up to ~1.7k if it reads all its reference files. Until then it costs about 66 tokens; SKILL.md has 497 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). 497 words, ~1,239 tokens.
Download SKILL.mdSave it as
.claude/skills/flyio-cost-tuning/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- flyio-cost-tuning
- description
- Analyze Fly.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices. Use when reducing spend or forecasting capacity. Trigger with: "audit Fly bill", "right-size Fly Machines", "reduce Fly idle cost".
- allowed-tools
- Read, Grep, Write, Edit
- compatibility
- Requires current billing exports or invoices, app and database inventory, utilization evidence, service objectives, and an approved optimization window.
- version
- 2.0.0
- argument-hint
- [organization-app-and-billing-window]
- model
- inherit
- effort
- high
- license
- MIT
- author
- Jeremy Longshore <jeremy@intentsolutions.io>
- tags
- saas, flyio, cost-management, right-sizing, autostop
Fly.io Cost and Capacity Review
Overview
Optimize from measured usage and the current pricing page, not copied monthly constants. Separate running and stopped Machine charges, persistent volume and snapshot charges, network and IP costs, and Managed Postgres resources that live outside application deletion.
Prerequisites
- Billing window, currency, organization, apps, and cost owner
- Machine state and resource history plus traffic, latency, and availability objectives
- Inventory of volumes, snapshots, IPs, transfer, builders, and Managed Postgres clusters
Instructions
Step 1: Reconcile the bill to resources
Map each charge class to current Machines, volumes, snapshots, addresses, transfer, builders, and databases. Include unattached and stopped-resource dependencies.
Step 2: Measure utilization and state
Compare CPU, memory, concurrency, request, latency, restart, and running-time signals with the selected VM size and Machine count.
Step 3: Evaluate autostop safely
For eligible service apps, model auto_stop_machines as stop or suspend with auto_start_machines and a deliberate minimum-running setting. Include cold-start and state-safety costs.
Step 4: Right-size and place
Change one dimension at a time: VM preset, additional memory, count, region placement, or database plan. Preserve capacity and recovery headroom.
Step 5: Remove orphaned cost with approval
Identify unattached volumes, obsolete snapshots beyond policy, unused addresses, old builders, and databases no longer referenced. Deletion requires owner confirmation and recovery evidence.
Step 6: Verify savings and service health
Compare the next billing interval and performance signals with the baseline; reverse changes that violate latency, availability, or recovery objectives.
Authentication
Prefer read-only organization tokens for inventory and billing analysis. Cost review does not authorize deleting Machines, volumes, addresses, snapshots, or Managed Postgres clusters; obtain resource-owner approval and preserve recovery evidence first.
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 (170 more words)Show less
Output
- Cost allocation by resource class and owner
- Ranked optimization plan with forecast, risk, and rollback
- Post-change cost and service-objective comparison
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
An internal HTTP app has predictable idle nights. The operator confirms it has no unsafe local state, models suspend and autostart with one minimum Machine during business hours, preserves volume charges in the forecast, and validates cold-start latency before rollout.
Error Handling
| Failure | Response |
|---|---|
| Bill and inventory do not reconcile | Check deleted apps, stopped Machines, orphaned volumes, addresses, builders, transfer, and Managed Postgres outside app scope. |
| Autostop harms availability | Raise minimum capacity or revert the setting; do not optimize through an unmeasured outage. |
| Pricing changed | Re-fetch the official pricing page and recompute; never preserve a stale copied rate. |
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-cost-tuning of jeremylongshore/tons-of-skills-marketplace.
- SKILL.md
- references/official-docs.md
Open the folder on GitHubat commit cfae287
Compare with similar skills
Flyio Cost Tuning 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 Cost Tuning this skilljeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1.2k | Automated safety check: Pass | MIT | |
| Find Hypertable Candidatestimescale/pg-aiguide | 1.9k | 1 repos | ~2.6k | Automated safety check: Pass | Apache-2.0 | |
| Setup Timescaledb Hypertablestimescale/pg-aiguide | 1.9k | — | ~4.7k | Automated safety check: Pass | Apache-2.0 | |
| TimescaleDB Reference2025Emma/vibe-coding-cn | 23k | 1 repos | ~750 | Automated safety check: Pass | MIT | |
| Using Timeseries Databasesancoleman/ai-design-components | 525 | — | ~1.7k | Automated safety check: Pass | MIT | |
| Postgrestimescale/pg-aiguide | 1.9k | — | ~941 | Automated safety check: Pass | Apache-2.0 |
Similar skills
Setup Timescaledb Hypertables
timescale/pg-aiguide
A skill your agent uses when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data.
TimescaleDB Reference
2025Emma/vibe-coding-cn
TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time…
Using Timeseries Databases
ancoleman/ai-design-components
Time-series database implementation for metrics, IoT, financial data, and observability backends.
Postgres
timescale/pg-aiguide
A skill your agent uses for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.
TimesFM Forecasting
google-research/timesfm
Forecasts any univariate time series zero-shot with Google's TimesFM model, returning point forecasts and calibrated prediction intervals without training.
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 Cost Tuning
What does Flyio Cost Tuning do?
Analyze Fly.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices. Flyio Cost Tuning is an agent skill from jeremylongshore/tons-of-skills-marketplace.io Machine, volume, network, IP, and Managed Postgres cost drivers without freezing volatile prices.
When should I use Flyio Cost Tuning?
Flyio Cost Tuning fits situations like: forecasting capacity; with: audit Fly bill; right-size Fly Machines; reduce Fly idle cost.
How do I install Flyio Cost Tuning in Claude Code?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-cost-tuning -a claude-code`. Or copy the skill folder (skills/.curated/flyio-cost-tuning in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/flyio-cost-tuning in your project. Claude Code loads it when a task matches its description.
How do I install Flyio Cost Tuning in Codex?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flyio-cost-tuning -a codex`. Or copy the skill folder (skills/.curated/flyio-cost-tuning in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/flyio-cost-tuning in your project. Codex loads it when a task matches its description.
Can I use Flyio Cost Tuning 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-cost-tuning -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-cost-tuning, .gemini/skills/flyio-cost-tuning, .github/skills/flyio-cost-tuning and .opencode/skills/flyio-cost-tuning in your project.
What does Flyio Cost Tuning need to run?
SKILL.md names no scripts, command-line tools or credentials: Flyio Cost Tuning is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Grep, Write, Edit. Compatibility (from SKILL.md): Requires current billing exports or invoices, app and database inventory, utilization evidence, service objectives, and an approved optimization window..
Does Flyio Cost Tuning 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 Cost Tuning 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 Cost Tuning use?
Flyio Cost Tuning 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 Cost Tuning use?
About 1.2k tokens (SKILL.md is roughly 5k 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 491 tokens, read only when the agent opens those files.
What are the alternatives to Flyio Cost Tuning?
Skills that share tags, products or a category with Flyio Cost Tuning: Find Hypertable Candidates (timescale/pg-aiguide, 1.9k stars), Setup Timescaledb Hypertables (timescale/pg-aiguide, 1.9k stars), TimescaleDB Reference (2025Emma/vibe-coding-cn, 23k stars) and Using Timeseries Databases (ancoleman/ai-design-components, 525 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Flyio Cost Tuning?
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.