database-backup-and-point-in-time-restore-testing SKILL.md skillA
database-backup-and-point-in-time-restore-testing from himanshuj16/algo-trading-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add himanshuj16/algo-trading-skills/database-backup-and-point-in-time-restore-testing@v1.1.0Pins v1.1.0 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- himanshuj16/algo-trading-skills
- Path
skills/database-backup-and-point-in-time-restore-testing/SKILL.md- Versions recorded
- 5
- Latest version
- v1.1.0, committed Sep 3, 2026
- First version recorded
- Jul 30, 2026
- Size
- 8,173 bytes
- Repository stars
- 50
- License
- Apache-2.0
Use when a trading database must be provably restorable to an exact timestamp before a bad migration; replays archived WAL metadata to a target time, detects gaps and unreachable targets, and audits measured RPO and RTO.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
## When to Use
Use this skill when operating a trading database (PostgreSQL/TimescaleDB) whose order books, fill records, and account balances must survive a bad deployment, a corrupting migration, or a regional outage — and recovery must land on an exact timestamp $T_{\text{target}}$ just before the damage. It is a **drill harness over backup metadata**: given the base snapshots and the WAL sequence your archive actually holds, it answers whether a recovery to $T_{\text{target}}$ would succeed, how wide the data-loss window would be, and whether that lands inside your RPO/RTO objectives.
Its practical value is catching the failure that real incidents expose too late: an archive that silently stopped advancing weeks ago, so that the "daily backups" everyone trusts cannot reach any recent recovery point.
## When NOT to Use
- **As proof that a backup is restorable.** This module replays an abstract WAL model, not real WAL pages. Only an actual restore into an isolated instance, followed by application-level reconciliation, proves recoverability. Use this between drills, not instead of them.
…Read the whole file at its exact version.
How to install
mdr add himanshuj16/algo-trading-skills/database-backup-and-point-in-time-restore-testing@sha256:3ce25f40a3b862f6The line at the top of this page pins the label v1.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_zxcfj3ruwsyirye2)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 5 versions of this file, between Jul 30, 2026 and Sep 3, 2026, about one every 9 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| v1.1.0 latest | 2026-09-03 | 8527a51 | 8,173 B | A | view · diff |
| v1.1.0 | 2026-08-23 | a0fdc9e | 8,190 B | A | view · diff |
| v1.0.0 | 2026-08-07 | 89d1436 | 3,505 B | A | view · diff |
| v1.0.0 | 2026-07-30 | dfc60c7 | 3,503 B | A | view · diff |
| v1.0.0 | 2026-07-30 | 66d0ca2 | 3,519 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (8173 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
himanshuj16/algo-trading-skills · 50 stars · license Apache-2.0 · pushed 2026-09-14 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_zxcfj3ruwsyirye2 GET https://markdownregistry.com/api/v1/resolve?ref=himanshuj16/algo-trading-skills/database-backup-and-point-in-time-restore-testing GET https://markdownregistry.com/api/v1/blob/3ce25f40a3b862f634cc01aaf30cb4b9a42cee2ecb32553763dd496d4bb8f777
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.