database▌

ClinPGx (Clinical Pharmacogenomics Database) is a comprehensive resource for clinical pharmacogenomics information, successor to PharmGKB. It consolidates data from PharmGKB, CPIC, and PharmCAT, providing curated information on how genetic variation affects medication response. Access gene-drug pairs, clinical guidelines, allele functions, and drug labels for precision medicine applications.

The Gene Expression Omnibus (GEO) is NCBI's public repository for high-throughput gene expression and functional genomics data. GEO contains over 264,000 studies with more than 8 million samples from both array-based and sequence-based experiments.

ClinVar is NCBI's freely accessible archive of reports on relationships between human genetic variants and phenotypes, with supporting evidence. The database aggregates information about genomic variation and its relationship to human health, providing standardized variant classifications used in clinical genetics and research.

USPTO provides specialized APIs for patent and trademark data. Search patents by keywords/inventors/assignees, retrieve examination history via PEDS, track assignments, analyze citations and office actions, access TSDR for trademarks, for IP analysis and prior art searches.

Production-ready SQL and NoSQL schemas with normalization, indexing, and migration strategies built in. \n \n Generates complete schemas from natural language descriptions, covering entities, relationships, constraints, and indexes tailored to SQL or NoSQL databases \n Provides normalization guidance (1NF through 3NF), foreign key strategies with ON DELETE rules, and composite index planning based on access patterns \n Includes anti-patterns reference (FLOAT for money, missing FK indexes, non-re

Safe, reversible database schema changes for production systems. \n \n Covers PostgreSQL, MySQL, and five major ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate) with workflow examples and schema patterns for each \n Enforces core principles: immutable deployed migrations, forward-only production rollbacks, and separation of schema (DDL) from data (DML) migrations \n Provides the expand-contract pattern for zero-downtime column renames and large refactors, with concrete timeline examples \

This skill provides tools for working with Supabase database tables through the REST API. Supports SELECT queries with filtering, INSERT, UPDATE, DELETE operations, and calling RPC functions.

Frontend CloudBase Relational Database client initialization with Supabase-compatible query API. \n \n Provides canonical synchronous initialization pattern using @cloudbase/js-sdk for browser-based apps (React, Vue, vanilla JS) \n Returns a shared db client that uses identical method names and patterns to Supabase for queries, inserts, updates, and deletes \n Enforces single-client reuse across components; prohibits lazy-loading, async wrappers, and re-initialization \n Handles only frontend da

ZINC is a freely accessible repository of 230M+ purchasable compounds maintained by UCSF. Search by ZINC ID or SMILES, perform similarity searches, download 3D-ready structures for docking, discover analogs for virtual screening and drug discovery.

Amazon RDS simplifies relational database deployment and operations. Support multiple database engines with automated backups, replication, encryption, and high availability through Multi-AZ deployments.