Skill UI

Expert guidance for SQL database migrations across PostgreSQL, MySQL, and SQL Server, emphasizing zero-downtime deployments with validation checks, rollback plans, and data integrity safeguards for production systems.

Provides deep expertise in analyzing DWARF v3-v5 debug files, verifying their integrity through llvm-dwarfdump, and helping parse or write code that interacts with DWARF data for more reliable debugging toolchains.

Manages complete database testing workflows by generating realistic test data, wrapping tests in automatic transactions, and validating schema integrity to keep migrations and interactions reliable.

Ensures database integrity via the data-validation-engine plugin by automatically enforcing data types, ranges, formats, referential integrity, and business rules whenever validation or database integrity requests arise across multi-database environments.

Monitors OT historian servers (OSIsoft PI, Ignition, Wonderware) for unauthorized queries, data manipulation, and lateral movement so analysts catch attacks at the IT/OT boundary, validate data integrity after incidents, and respond to historian-specific CVEs.

Configure AIDE on Linux hosts to build baseline databases, run scheduled integrity checks, parse change reports, and generate alerts and compliance summaries for added, removed, or modified files.

Guides OT engineers through hardening process historian servers (OSIsoft PI, Honeywell PHD, GE Proficy, AVEVA Historian) by aligning Purdue network placement, access controls, DMZ replication, SQL injection defenses, and data integrity monitoring for safety, compliance, and analytics.

Automated harness for healthcare deployments that runs Jest suites across CDSS logic, PHI exposure, data integrity, clinical workflow, and integration gates, aborting releases on any critical failure to keep patient safety non-negotiable.