smart-contract-upgrade-governance – Other skill for AI agents

Smart Contract Upgrade Governance

What it is: Records evidence about timelocks, bytecode identity and governance approval; the register itself enforces none of these controls.

Overview

Provides a standardized, auditable framework and data model for Smart Contract Upgrade Governance operations across distributed engineering and decentralized application systems.

When to Use This Skill

• When formalizing architectural contracts, security invariants, or operational limits for Smart Contract Upgrade Governance.
• 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

1. Define the parameters, thresholds, and identity bindings required for the target operational register.

2. Select appropriate boundary enforcement values from validated enum select sets.

3. 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 | Upgrade Proposal ID | id | VARCHAR(64) PRIMARY KEY | string | Text | UPG-001 |

| 2 | Target Contract Address | text | VARCHAR(56) | string | Text | CAUD... |

| 3 | New WASM Bytecode Hash | text | VARCHAR(64) | string | Text | e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 |

| 4 | Timelock Delay Hours | number | INTEGER | integer | Number | 48 |

| 5 | Governance Quorum Required | select | VARCHAR(32) | string | Select | 3-of-5 Multisig |

| 6 | State Migration Function | text | VARCHAR(64) | string | Text | migrate_storage_v2 |

| 7 | Emergency Cancel Permitted | select | VARCHAR(16) | string | Select | Yes |

| 8 | Audit Certification Attached | select | VARCHAR(16) | string | Select | Yes |

| 9 | Upgrade Lifecycle Status | select | VARCHAR(32) | string | Select | Timelock Pending |

| 10 | Authorized Proposer | text | VARCHAR(56) | string | Text | GPROP... |

| 11 | Proposal Submission Date | date | DATE | string, format: date | Date | 2026-10-01 |

Select Options

Governance Quorum Required

3-of-5 Multisig | 4-of-7 Multisig | DAO Token Vote Quorum

Emergency Cancel Permitted

Yes | No

Audit Certification Attached

Yes | No

Upgrade Lifecycle Status

Draft | Timelock Pending | Executed | Cancelled Revoked

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 Smart Contract Upgrade Governance 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.

Bind approval to network, contract, current/new executable hash, proposal ID and exact migration parameters; store full validated hashes, not the illustrative hash above. Record scheduled/executable times as UTC timestamps or ledger-bound values consistent with the actual contract, not a date-only proof of elapsed timelock. Verify replay protection, signer weights/thresholds, cancellation authority and storage-migration compatibility in code/tests before any upgrade. A checkbox saying audit attached does not establish an audit or authorize signing.

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.
• @smart-contract-formal-verification - verifies state invariants mathematically.
• @stellar-multisig-threshold-coordinator - covers signer weights and threshold coordination.

Reusable Prompt

I want to establish a verified Smart Contract Upgrade Governance register for our production protocol.
Guide me through the required field parameters and output the corresponding SQL DDL and JSON Schema.