Dados e Análise

Escreva consultas de banco de dados seguras, performáticas e otimizadas usando consultas parametrizadas, carregamento antecipado (eager loading), indexação adequada e gerenciamento de transações. Use esta skill ao escrever consultas em controladores, repositórios, serviços ou métodos de modelo, ao usar construtores de consulta ou métodos ORM, e ao implementar lógica de filtragem, ordenação, paginação ou otimizar problemas de consulta N+1.

Initialize new feature with Clean Architecture folder structure and skeleton files. Creates scaffold for domain, data, and presentation layers with TODOs. Use AFTER /plan to create the initial structure, then run /domain and /data to fill in details.

Standard single-cell RNA-seq analysis pipeline. Use for QC, normalization, dimensionality reduction (PCA/UMAP/t-SNE), clustering, differential expression, and visualization. Best for exploratory scRNA-seq analysis with established workflows. For deep learning models use scvi-tools; for data format questions use anndata.

Master Cohere v2 Chat API with Python, specializing in entity extraction using JSON Schema mode for structured outputs. Use when extracting entities from text, building data extraction pipelines, implementing NER systems, or requiring validated JSON responses from LLMs.

Um guia completo de desenvolvimento backend para Supabase Edge Functions e PostgreSQL. Abrange design de banco de dados, autenticação, padrões de Edge Function, Row-Level Security, integração de e-mail, processamento de pagamentos e implantação no Supabase.

Navigate Supabase database tables, relationships, and query patterns. Use when you need to understand how tables connect, write queries, or find the right data source.

Query IUPHAR/BPS Guide to Pharmacology (GtoPdb) for receptor-ligand interactions, target/ligand metadata, families, and approved drugs. Affinities (pKi/pIC50/pKd), action (Agonist/Antagonist/etc.), species, structures (SMILES/InChI). No auth. Always resolve targets via geneSymbol/accession; most metadata lives in sub-resources (/databaseLinks, /structure, /synonyms).

Construa pipelines MLOps de ponta a ponta, desde a preparação de dados até o treinamento, validação e implantação de modelos em produção. Use ao criar pipelines de ML, implementar práticas MLOps ou automatizar fluxos de trabalho de treinamento e implantação de modelos.

Discover novel miRNAs and quantify known miRNAs using miRDeep2 de novo prediction from small RNA-seq data. Use when identifying new miRNAs or performing comprehensive miRNA profiling with discovery.

Call topologically associating domains (TADs) from Hi-C data using insulation score, HiCExplorer, and other methods. Identify domain boundaries and hierarchical domain structure. Use when calling TADs from Hi-C insulation scores.

Data journalism workflows for analysis, visualization, and storytelling. Use when analyzing datasets, creating charts and maps, cleaning messy data, calculating statistics or building data-driven stories. Essential for reporters, newsrooms and researchers working with quantitative information.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.