Skill UI

Provide REST API access to ClinPGx, the successor to PharmGKB, for querying gene-drug interactions, CPIC/DPWG/FDA guidelines, allele functions, and evidence that supports precision dosing and pharmacogenomics-driven clinical decisions.

A comprehensive guide detailing best practices for database interaction in Go. It covers secure query writing using parameterized placeholders, handling transactions, managing connection pooling, dealing with NULLable columns, and choosing between libraries like sqlx and pgx, while strongly advising against using ORMs.