Soroban Oracle Data Feed Audit
What it is: Tracks decentralized price feed providers, staleness boundaries, and multi-source medianizer logic to prevent oracle manipulation in Soroban protocols.
Overview
Provides a standardized, auditable framework and data model for Soroban Oracle Data Feed Audit operations across distributed engineering and decentralized application systems.
When to Use This Skill
- When formalizing architectural contracts, security invariants, or operational limits for Soroban Oracle Data Feed Audit.
- When cross-functional review is required between protocol developers, smart contract auditors, and AI engineering agents.
- When generating reproducible CSV, SQL DDL, JSON Schema, and Notion property registers for tracking compliance.
How It Works
- Define the parameters, thresholds, and identity bindings required for the target operational register.
- Select appropriate boundary enforcement values from validated enum select sets.
- Export standardized artifacts (CSV table, SQL DDL, JSON Schema) to integrate into validation CI pipelines.
Field Reference
| # |
Field Name |
Type |
SQL Type |
JSON Schema Type |
Notion Property Type |
Example Value |
| 1 |
Oracle Feed ID |
id |
SERIAL PRIMARY KEY |
integer |
Text |
ORC-001 |
| 2 |
Asset Pair Identifier |
text |
VARCHAR(32) |
string |
Text |
XLM/USD |
| 3 |
Oracle Contract Address |
text |
VARCHAR(56) |
string |
Text |
CORC... |
| 4 |
Max Stale Period Seconds |
number |
INTEGER |
number |
Number |
300 |
| 5 |
Deviation Threshold Bps |
number |
INTEGER |
number |
Number |
100 |
| 6 |
TWAP Window Length Seconds |
number |
INTEGER |
number |
Number |
1800 |
| 7 |
Medianizer Minimum Sources |
number |
INTEGER |
number |
Number |
3 |
| 8 |
Circuit Breaker Reversion Bound |
select |
VARCHAR(16) |
string |
Select |
Yes |
| 9 |
Feed Health Status |
select |
VARCHAR(32) |
string |
Select |
Active Healthy |
| 10 |
Last Reported Price |
currency |
NUMERIC(18,7) |
number |
Number |
0.1250000 |
| 11 |
Audit Verification Date |
date |
DATE |
string, format: date |
Date |
2026-10-01 |
Select Options
Circuit Breaker Reversion Bound
Yes | No
Feed Health Status
Active Healthy | Stale Alert | Deviation Triggered | Paused
Relations
Audit Reference -> links to the formal review documentation or test repository.
Target Architecture -> links to the deployed contract or autonomous agent runtime component.
Examples
Prompt
How do I configure and track Soroban Oracle Data Feed Audit for our production environment?
Recommended Next Step
Generate the unified field schema, SQL DDL migration, and JSON validation schema to register into your system catalog.
Workflow: Define criteria -> Run automated verification -> Record baseline -> Monitor invariants.
Best Practices
- Enforce strict typing on numerical bounds and currency amounts; avoid unstructured free-text fields for critical states.
- Re-run validation test suites on every state-altering commit or parameter change.
- Keep example data synthetic and isolated from production cryptographic keys or private endpoints.
Limitations
- Provides architectural specifications, data models, and verification schemas; does not execute direct transaction signing without authorized external tooling.
- Requires network connectivity and valid RPC credentials when querying on-chain states.
Security & Safety Notes
- All parameters declare
risk: safe. No unauthorized state modification or privileged credential access is performed.
- Use synthetic dummy keys and mock addresses in test suites and local verification scripts.
Common Pitfalls
- Problem: Mismatched decimal precision between contract runtime and database register.
Solution: Always verify decimals using the explicit field mapping in this reference.
- Problem: Missing authorization checks prior to state update.
Solution: Cross-validate against the Security Audit register before deployment.
Related Skills
- @soroban-contract-audit - provides the security checklist and vulnerability categorization.
- @soroban-storage-ttl-lifecycle - covers ledger rent and TTL extension policy.
- @smart-contract-formal-verification - verifies state invariants mathematically.
Reusable Prompt
I want to establish a verified Soroban Oracle Data Feed Audit register for our production protocol.
Guide me through the required field parameters and output the corresponding SQL DDL and JSON Schema.
1---2name: soroban-oracle-data-feed-audit3description: 'DeFi price oracle integration and safety audit register: heartbeat bounds, stale price threshold reversion, and TWAP medianizer validation.'4category: engineering5risk: safe6source: self7source_type: self8date_added: "2026-10-01"9author: Ranjeet206310tags: [soroban, oracle, defi, pricing, stellar, security, web3]11tools: []12source_repo: Ranjeet2063/agentic-awesome-skills13metadata:14 source: https://skillmd.com/skills/iradoweck/soroban-oracle-data-feed-audit15---1617# Soroban Oracle Data Feed Audit1819**What it is:** Tracks decentralized price feed providers, staleness boundaries, and multi-source medianizer logic to prevent oracle manipulation in Soroban protocols.2021## Overview2223Provides a standardized, auditable framework and data model for **Soroban Oracle Data Feed Audit** operations across distributed engineering and decentralized application systems.2425## When to Use This Skill2627- When formalizing architectural contracts, security invariants, or operational limits for Soroban Oracle Data Feed Audit.28- When cross-functional review is required between protocol developers, smart contract auditors, and AI engineering agents.29- When generating reproducible CSV, SQL DDL, JSON Schema, and Notion property registers for tracking compliance.3031## How It Works32331. Define the parameters, thresholds, and identity bindings required for the target operational register.342. Select appropriate boundary enforcement values from validated enum select sets.353. Export standardized artifacts (CSV table, SQL DDL, JSON Schema) to integrate into validation CI pipelines.3637## Field Reference3839| # | Field Name | Type | SQL Type | JSON Schema Type | Notion Property Type | Example Value |40|---|------------|------|----------|------------------|----------------------|---------------|41| 1 | Oracle Feed ID | `id` | `SERIAL PRIMARY KEY` | `integer` | Text | `ORC-001` |42| 2 | Asset Pair Identifier | `text` | `VARCHAR(32)` | `string` | Text | `XLM/USD` |43| 3 | Oracle Contract Address | `text` | `VARCHAR(56)` | `string` | Text | `CORC...` |44| 4 | Max Stale Period Seconds | `number` | `INTEGER` | `number` | Number | `300` |45| 5 | Deviation Threshold Bps | `number` | `INTEGER` | `number` | Number | `100` |46| 6 | TWAP Window Length Seconds | `number` | `INTEGER` | `number` | Number | `1800` |47| 7 | Medianizer Minimum Sources | `number` | `INTEGER` | `number` | Number | `3` |48| 8 | Circuit Breaker Reversion Bound | `select` | `VARCHAR(16)` | `string` | Select | `Yes` |49| 9 | Feed Health Status | `select` | `VARCHAR(32)` | `string` | Select | `Active Healthy` |50| 10 | Last Reported Price | `currency` | `NUMERIC(18,7)` | `number` | Number | `0.1250000` |51| 11 | Audit Verification Date | `date` | `DATE` | `string, format: date` | Date | `2026-10-01` |5253## Select Options5455**Circuit Breaker Reversion Bound**5657```58Yes | No59```6061**Feed Health Status**6263```64Active Healthy | Stale Alert | Deviation Triggered | Paused65```6667## Relations6869- `Audit Reference` -> links to the formal review documentation or test repository.70- `Target Architecture` -> links to the deployed contract or autonomous agent runtime component.7172## Examples7374**Prompt**7576```77How do I configure and track Soroban Oracle Data Feed Audit for our production environment?78```7980**Recommended Next Step**8182> Generate the unified field schema, SQL DDL migration, and JSON validation schema to register into your system catalog.83>84> Workflow: Define criteria -> Run automated verification -> Record baseline -> Monitor invariants.8586## Best Practices8788- Enforce strict typing on numerical bounds and currency amounts; avoid unstructured free-text fields for critical states.89- Re-run validation test suites on every state-altering commit or parameter change.90- Keep example data synthetic and isolated from production cryptographic keys or private endpoints.9192## Limitations9394- Provides architectural specifications, data models, and verification schemas; does not execute direct transaction signing without authorized external tooling.95- Requires network connectivity and valid RPC credentials when querying on-chain states.9697## Security & Safety Notes9899- All parameters declare `risk: safe`. No unauthorized state modification or privileged credential access is performed.100- Use synthetic dummy keys and mock addresses in test suites and local verification scripts.101102## Common Pitfalls103104- **Problem:** Mismatched decimal precision between contract runtime and database register.105 **Solution:** Always verify decimals using the explicit field mapping in this reference.106- **Problem:** Missing authorization checks prior to state update.107 **Solution:** Cross-validate against the Security Audit register before deployment.108109## Related Skills110111- @soroban-contract-audit - provides the security checklist and vulnerability categorization.112- @soroban-storage-ttl-lifecycle - covers ledger rent and TTL extension policy.113- @smart-contract-formal-verification - verifies state invariants mathematically.114115## Reusable Prompt116117```118I want to establish a verified Soroban Oracle Data Feed Audit register for our production protocol.119Guide me through the required field parameters and output the corresponding SQL DDL and JSON Schema.120```