think.agentutil.net Post-Action Verification Review

{
  "domain": "infrastructure-management",
  "description": "Completed a database migration from PostgreSQL 12 to PostgreSQL 14 on the staging environment. The migration included schema validation, data integrity checks, and performance benchmarking. All tests passed successfully.",
  "action_completed": "database version upgrade from PostgreSQL 12 to PostgreSQL 14"
}

{
  "data": {
    "summary": "Post-action review for alter_schema (high-risk). 8 verification checks.",
    "risk_level": "high",
    "action_type": "alter_schema",
    "verification_checklist": [
      {
        "why": "Some schema changes (dropping columns, changing types with data loss) are irreversible without backups.",
        "check": "Could this schema change be reversed? Is a down-migration script written and tested?",
        "category": "reversibility",
        "severity": "critical"
      },
      {
        "why": "Changing or removing columns that application code references will cause runtime errors in production.",
        "check": "Verify: What application code, queries, views, or stored procedures depend on the affected columns?",
        "category": "dependencies",
        "severity": "critical"
      },
      {
        "why": "A pre-change backup is the only guaranteed recovery path if the ALTER produces unexpected results.",
        "check": "Was a full backup of the table schema and data been taken before altering?",
        "category": "backup",
        "severity": "critical"
      },
      {
        "why": "ALTER TABLE on a 100-row dev table takes milliseconds. The same operation on a 100-million-row production table can take hours and lock the table.",
        "check": "Was this been tested against a database with production-scale data volume?",
        "category": "testing",
        "severity": "high"
      },
      {
        "why": "Schema changes on large tables can lock the table for the duration, causing timeouts for all concurrent queries.",
        "check": "Was this scheduled during a maintenance window with the application in maintenance mode?",
        "category": "timing",
        "severity": "high"
      },
      {
        "why": "Adding a NOT NULL column with a default, or changing a column type, may rewrite every row in the table.",
        "check": "Verify: What is the table size? Will the ALTER require a full table rewrite?",
        "category": "scope",
        "severity": "high"
      },
      {
        "why": "Unreported schema changes break ETL pipelines, reports, and integrations that other teams maintain.",
        "check": "Were all teams that query or depend on this table been notified of the upcoming change?",
        "category": "notification",
        "severity": "high"
      },
      {
        "why": "Having a rollback plan with estimated execution time prevents panic decisions during incidents.",
        "check": "Was there a tested rollback script ready in case the change needs to be reverted?",
        "category": "rollback",
        "severity": "high"
      }
    ]
  },
  "service": "https://think.agentutil.net",
  "request_id": "ecb909d1-22aa-4797-bda5-5d2060369d06",
  "related_services": [
    {
      "url": "https://verify.agentutil.net",
      "name": "verify",
      "description": "Fact verification against live data sources -- exchange rates, crypto, stocks, entities, geography"
    },
    {
      "url": "https://docs.agentutil.net",
      "name": "docs",
      "description": "Search pre-indexed platform documentation -- semantic vector search across 10+ platforms"
    },
    {
      "url": "https://convert.agentutil.net",
      "name": "convert",
      "description": "Unit conversion (80+ units), live currency rates, and encoding (base64, hex, URL)"
    },
    {
      "url": "https://weather.agentutil.net",
      "name": "weather",
      "description": "Current conditions and multi-day forecasts for any location worldwide via Open-Meteo"
    },
    {
      "url": "https://validate.agentutil.net",
      "name": "validate",
      "description": "Validate emails (RFC 5322), URLs, phone numbers (E.164), credit cards (Luhn), and JSON schemas"
    },
    {
      "url": "https://time.agentutil.net",
      "name": "time",
      "description": "Timezone conversion, current time in any timezone, date arithmetic, and epoch conversions"
    },
    {
      "url": "https://hash.agentutil.net",
      "name": "hash",
      "description": "Hash with MD5/SHA-256/SHA-512, encode/decode base64/hex/URL, generate UUIDs, identify hash algorithms"
    },
    {
      "url": "https://text.agentutil.net",
      "name": "text",
      "description": "Regex match/replace/extract, text diff, slugify, word count, and markdown/HTML/JSON transforms"
    },
    {
      "url": "https://math.agentutil.net",
      "name": "math",
      "description": "Safe expression evaluation, statistics (mean/median/stddev/percentiles), percentages, and rounding"
    },
    {
      "url": "https://geocode.agentutil.net",
      "name": "geocode",
      "description": "Forward geocoding (address to lat/lon), reverse geocoding (lat/lon to address), and haversine distance"
    },
    {
      "url": "https://dns.agentutil.net",
      "name": "dns",
      "description": "DNS record lookups (A/MX/TXT/NS), reverse DNS, WHOIS/RDAP domain data, and IP geolocation"
    },
    {
      "url": "https://undo.agentutil.net",
      "name": "undo",
      "description": "Reversibility intelligence -- check if actions can be undone, find safer alternatives, batch safety warnings"
    },
    {
      "url": "https://norm.agentutil.net",
      "name": "norm",
      "description": "Baseline reality checks -- statistical anomaly detection for values against published industry benchmarks"
    },
    {
      "url": "https://context.agentutil.net",
      "name": "context",
      "description": "Situational awareness -- timezone, holiday, business calendar, and platform status checks before taking action"
    }
  ]
}