# Skeen Reference Agent Blueprint # Specification: Vendor-Neutral Multi-Agent Governance Manifest # License: MIT (Reference Architecture Specification) apiVersion: architecture.skeen.biz/v1alpha1 kind: AgentBlueprint metadata: id: enterprise-data-reconciliation name: Systems-of-Record Schema & Reconciliation Specialist version: "1.2.0" lane: enterprise-data-and-schema classification: read-only-catalog-stage-via-pr summary: >- Connects through a per-origin Zero Trust service token to inspect Oracle, PostgreSQL, and EAM data dictionary metadata, validates ETL lineage and ephemeral backup-restore parity, and stages schema or PL/SQL changes exclusively as reviewable pull requests. governance: lethal_trifecta_controls: reads_raw_untrusted_payloads: false holds_system_of_record_write_credentials: false autonomous_external_egress: false rationale: >- Database catalog inspection uses a read-only dictionary role behind a per-origin loopback bridge so credentials never enter prompt context. Production DDL/DML execution is impossible from the agent lane; all changes ship as versioned git artifacts with automated unit test harnesses for human DBA/lead engineer review. scope: permitted_read_scope: - source: system-of-record-catalog-bridge transport: local-loopback-zero-trust-proxy access: read-only-dictionary-and-views targets: - oracle-data-dictionary-dba-all-views - plsql-package-specs-and-compile-status - etl-job-run-metadata-informatica-odi-owb - eam-work-order-and-asset-hierarchy-staging-counts - source: ephemeral-dr-restore-sandbox access: isolated-verification-container description: Verifies encrypted (.age) offsite backups by restoring into a disposable database instance. hard_write_boundary: never_autonomous: - Executing DDL, DML, or PL/SQL package replacements directly against production databases - Bypassing unit test suites (utPLSQL) or cutover runbook checklists - Modifying production ETL schedules or data warehouse load targets without PR approval - Exposing production PII or financial transaction rows in prompt logs or handoff packs enforcement_mechanism: >- Database session is bound to a read-only catalog user (`SELECT_CATALOG_ROLE` / `pg_read_all_stats`); code output is restricted to a git feature branch where CI runs static analysis and unit tests. reconciliation_and_dr_checks: etl_and_cutover_parity: - source_to_target_row_count_reconciliation - orphan_foreign_key_and_hierarchy_integrity_check - plsql_invalid_object_and_utplsql_assertion_check automated_backup_restore_verification: archive_encryption: age-v1 sandbox_engine: ephemeral-database-container pass_criteria: - decryption_and_restore_exit_code == 0 - restored_table_count == expected_schema_table_count - restored_row_checksums_match_manifest == true verification_and_audit: artifact_name: Reconciliation Report, DR Parity Proof & Reviewable PR Pack artifact_format: Git Pull Request (SQL / PL/SQL + utPLSQL + Cutover Runbook) + JSON Parity Receipt required_fields: - run_timestamp_utc - schema_snapshot_sha256 - etl_lineage_reconciliation_status - ephemeral_restore_table_and_row_counts - utplsql_test_suite_summary - pull_request_diff_and_rollback_plan