AGENT SKILL

ac-time-series-storage

Storing and serving numeric measurements over time: the time series data model and its labels, the write path and out-of-order arrival, compaction and downsampling, retention as a per-series policy, the query path from range selectors to aggregation, cardinality as the design constraint that decides everything else, and the written storage record. It explains how time series storage behaves and how to keep it healthy; it never recommends a database product and never promises a query time. Use when asking "time series database", "metric cardinality", "labels versus tags", "timestamped samples", "downsampling", "rollup", "retention policy", "out of order samples", "histogram bucket", "PromQL", "capacity for metrics", "why is my TSDB slow", "sample interval". Not for SLO definition and alerting semantics (ac-reliability), not for event and log pipelines (ac-data-pipeline-orchestration), not for financial market data collection (ac-market-data-collection).

License 许可
MIT
最近更新
2026-11-15
Stars
★ 81
Forks
17

01 前言 Front Matter

name
ac-time-series-storage
status
seedling
license
MIT
metadata
{ "domain": "software-engineering" }
description
Storing and serving numeric measurements over time: the time series data model and its labels, the write path and out-of-order arrival, compaction and downsampling, retention as a per-series policy, the query path from range selectors to aggregation, cardinality as the design constraint that decides everything else, and the written storage record. It explains how time series storage behaves and how to keep it healthy; it never recommends a database product and never promises a query time. Use when asking "time series database", "metric cardinality", "labels versus tags", "timestamped samples", "downsampling", "rollup", "retention policy", "out of order samples", "histogram bucket", "PromQL", "capacity for metrics", "why is my TSDB slow", "sample interval". Not for SLO definition and alerting semantics (ac-reliability), not for event and log pipelines (ac-data-pipeline-orchestration), not for financial market data collection (ac-market-data-collection).

02 资源文件 10

03 SKILL.md 正文

Time-series storage

Overview

A time series is a named measurement sampled over time, and a time-series database is engineered around the patterns that produce: writes are append-mostly and arrive continuously, queries read dense windows rather than single rows, and the storage engine works by chunking, compressing, and gradually compacting the data so that recent samples are cheap to write and old samples are cheap to keep. The design constraint that dominates everything — capacity, query speed, feasibility — is cardinality: the number of distinct label combinations, because that is the number of series the system tracks.

The failure mode of a time-series deployment is almost never the engine; it is a label set that grew. A metric with an id label turns per-object into per-series, and one unbounded label multiplies the series count until ingest slows, queries time out, and the retention job starves. This skill covers the model, the write and query paths, the compaction and retention mechanics, and above all the design discipline over labels that decides whether the system stays healthy.

Primary sources: https://prometheus.io/docs/introduction/overview/ and https://en.wikipedia.org/wiki/Time_series_database.

When to use

  • Designing a metrics schema and its labels for a service or platform.
  • Diagnosing TSDB capacity, ingest, or query-performance problems.
  • Setting retention, downsampling, and rollup policies.
  • Evaluating the storage consequences of an observability design.

When NOT to use

  • For SLO targets, error budgets, and alert routing semantics (use ac-reliability).
  • For batch event and log pipeline orchestration (use ac-data-pipeline-orchestration).
  • For market data collection pipelines in finance (use ac-market-data-collection).

Subskill Index

Leaf Domain segment Scope (one line)
subskills/the-series-model.md software-engineering/the-series-model Series, samples, labels, and what cardinality means.
subskills/write-path.md software-engineering/write-path Ingest, scrape intervals, timestamp assignment, and out-of-order arrival.
subskills/schema-and-indexing.md software-engineering/schema-and-indexing The label index, matching, and cardinality as the design constraint.
subskills/chunking-and-compaction.md software-engineering/chunking-and-compaction Head chunks, compression, block compaction, and the cost curve.
subskills/downsampling-and-retention.md software-engineering/downsampling-and-retention Rollups, value-selection semantics, and retention as a policy.
subskills/query-path.md software-engineering/query-path Range selectors, aggregation, and the scrape-interval floor.
subskills/tsdb-record.md software-engineering/tsdb-record The written record: series inventory, capacity, and policy state.

Status and honest limits

Time-series engines differ in exact mechanics; this skill covers the shared design space rather than any single engine's internals, and names no products as recommendations. The honest absolute is that no amount of tuning rescues a schema whose cardinality was decided in application code, because the label set is decided before the database ever sees the sample. Nothing here promises a query time; the measurable outcomes are stored in the record with their dates.

04 同仓库更多 Skills

jiayaoqijia
jiayaoqijia/cryptoskill

troves

Deposit and withdraw from Troves DeFi yield vault strategies on Starknet. View available strategies, check positions, and manage vault deposits. Use this skill when the user mentions Troves, vault, yield vault, DeFi vault, strategy, yield farming, vault deposit, vault withdraw, earning yield through vaults, passive yield strategies, or wants to deposit into or withdraw from a yield strategy — even if they don't say "Troves" explicitly.

★ 81
jiayaoqijia
jiayaoqijia/cryptoskill

trade

Swap tokens on Starknet via Fibrous DEX aggregator. Supports per-provider selection (avnu, ekubo, or auto to race all). Use this skill when the user wants to swap, exchange, trade, convert, buy, or sell one token for another on Starknet. Also use when the user asks about token prices, exchange rates, DEX routing, best swap route, or wants to check how much they would receive for a given amount — even if they don't explicitly say "swap".

★ 81
jiayaoqijia
jiayaoqijia/cryptoskill

staking

Stake, unstake, claim, and compound rewards for STRK, WBTC, tBTC, SolvBTC, and LBTC on Starknet. View validators, pools, and staking positions. Use this skill when the user mentions staking, delegating, validators, staking pools, rewards, compounding, unstaking, earning yield, passive income on crypto, or wants to earn on their STRK or BTC tokens — even if they don't say "stake" explicitly.

★ 81
jiayaoqijia
jiayaoqijia/cryptoskill

send

Send STRK, ETH, or any ERC-20 token to a Starknet address. Supports simulation (dry-run) before execution. Use this skill when the user wants to send, transfer, pay, tip, or move tokens to another wallet address on Starknet. Also trigger when the user mentions sending funds to someone, making a payment, transferring assets, or moving crypto to a specific address — even if they just say "pay 10 STRK to 0x...".

★ 81
jiayaoqijia
jiayaoqijia/cryptoskill

portfolio

View a comprehensive DeFi portfolio dashboard and optimize portfolio allocation via automated rebalancing. Use this skill when the user wants an overview, summary, dashboard, total value, net worth, portfolio rebalancing, target allocation, or wants to see all their DeFi positions across Starknet at once. Also trigger when the user asks "what do I have", "show me everything", "how much am I worth", "my positions", "my investments", "rebalance my portfolio", "I want 50% ETH", "optimize my holdings", or any request for a holistic view of their Starknet holdings — even if they don't explicitly say "portfolio".

★ 81
jiayaoqijia
jiayaoqijia/cryptoskill

multi-swap

Execute multiple token swaps in a single Starknet transaction via Fibrous (default). Supports per-provider selection (avnu, ekubo, or auto to race all). Supports 2-3 swap pairs bundled into one multicall. Use this skill when the user wants to swap multiple token pairs at once, do batch swaps, execute several trades simultaneously, perform parallel swaps, or do bulk trading in one transaction. Also trigger when the user mentions "two swaps", "three swaps", "swap X and Y at the same time", or wants to convert multiple tokens in a single call.

★ 81