reviewing-oracle-to-postgres-migration

Warn

Audited by Runlayer on Mar 11, 2026

Risk Level: MEDIUM
Scan Summary
Max Score
77%
Files
11
Flagged
2
Chunks
13
Flagged Files (2)
reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-timestamp-timezone.mdMEDIUM
77.5%

Risky tool definition detected

Configure Npgsql for UTC via Connection String or AppContext Npgsql 6+ ships with `EnableLegacyTimestampBehavior` set to `false` by default, which causes `timestamptz` values to be returned as `DateTime` with `Kind=Utc`. Explicitly setting the switch at startup is still recommended to guard against accidental opt-in to legacy mode (e.g., via a config file or a transitive dependency) and to make the intent visible to future maintainers: ```csharp // Program.cs / Startup.cs — apply once at applica

Tool: reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-timestamp-timezone.md [2/2] Description: Assert.True(retrieved.CreatedAt >= before, "Persisted CreatedAt should not be earlier than the pre-insert UTC timestamp."); } ``` ### Test: Verify timestamp comparisons across Oracle and PostgreSQL baselines ```csharp [Fact] public async Task TimestampComparison_ShouldReturnSameRowsAsOracle() { var cutoff = DateTime.UtcNow.AddDays(-1); var oracleResults = await oracleRepository.Get

reviewing-oracle-to-postgres-migration/references/postgres-concurrent-transactions.mdLOW
51.9%

Tool passed security scan

Passed Files (9)Click to expand
reviewing-oracle-to-postgres-migration/references/postgres-refcursor-handling.mdOK
38.9%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/REFERENCE.mdOK
35.9%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-sorting.mdOK
24.3%

Tool passed security scan

reviewing-oracle-to-postgres-migration/SKILL.mdOK
23.8%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-to-char-numeric.mdOK
23.8%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/no-data-found-exceptions.mdOK
12.8%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/empty-strings-handling.mdOK
12.4%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-type-coercion.mdOK
12.2%

Tool passed security scan

reviewing-oracle-to-postgres-migration/references/oracle-parentheses-from-clause.mdOK
12.1%

Tool passed security scan

Audit Metadata
Max File Score
77%
Classification
UNKNOWN_SERVER
Files Scanned
11
Files Flagged
2
Chunks Analyzed
13
Analyzed
Mar 11, 2026, 03:01 AM
Security Audit — runlayer — reviewing-oracle-to-postgres-migration