16 skills found
phuryn / sql-queriesGenerate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation
Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.
Access NIH Metabolomics Workbench via REST API (4,200+ studies). Query metabolites, RefMet nomenclature, MS/NMR data, m/z searches, study metadata, for metabolomics and biomarker discovery.
samber / golang-databaseComprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling
microsoft / azure-cosmos-db-pyBuild Azure Cosmos DB NoSQL services with Python/FastAPI following production-grade patterns
FreedomIntelligence / bio-blast-searchesRun BLAST searches against NCBI databases using Biopython's Bio.Blast module.
FreedomIntelligence / bio-entrez-fetchRetrieve records from NCBI databases using Biopython's Entrez module (EFetch, ESummary utilities).
FreedomIntelligence / bio-entrez-linkNavigate between NCBI databases using Biopython's Entrez module (ELink utility).
FreedomIntelligence / bio-entrez-searchSearch NCBI databases using Biopython's Entrez module (ESearch, EInfo, EGQuery utilities).
microsoft / eventhouse-cliAuthors and queries Fabric Eventhouse and KQL databases: tables, functions, policies, materialized views, ingestion, and read-only KQL for real-time and time-series analytics. All KQL database work belongs here, table creation and simple queries included.
hashgraph-online / clickhouse-ioClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
levnikolaevich / ln-99-database-lifecycle-engineerPrepares and verifies schema migrations, database roles and isolated recovery or test resources; not query tuning or runtime mutation orchestration.
Microck / clinvar-databaseQuery NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.
jaechang-hits / pytdc-therapeutics-data-commonsTherapeutics Data Commons (TDC) AI-ready drug discovery datasets. Curated ADME, toxicity, DTI, DDI with scaffold/cold splits, standardized metrics, molecular oracles, and ADMET benchmarks for therapeutic ML and property prediction.
datadrivenconstruction / ifc-to-excelConvert IFC files (2x3, 4x1, 4x3) to Excel databases using IfcExporter CLI. Extract BIM data, properties, and geometry without proprietary software.
L3oNav / common-testingTest Types (ALL required): 1. **Unit Tests** - Individual functions, utilities, components 2. **Integration Tests** - API endpoints, database operations