Data & backend
10,137 rows, by stacks then stars
233 of these skill files have been read, by 258 distinct authors, and what they tell an agent counted. What Data & backend authors agree on, and what they forbid
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/chembl-database Skill
no license0★ repoQuery ChEMBL's bioactive molecules and drug discovery data. Search compounds by structure/properties, retrieve bioactivity data (IC50, Ki), find inhibitors, perform SAR studies, for medicinal chemistry.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/clinicaltrials-database Skill
no license0★ repoQuery ClinicalTrials.gov via API v2. Search trials by condition, drug, location, status, or phase. Retrieve trial details by NCT ID, export data, for clinical research and patient matching.
The same file is in 9 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/clinpgx-database Skill
no license0★ repoAccess ClinPGx pharmacogenomics data (successor to PharmGKB). Query gene-drug interactions, CPIC guidelines, allele functions, for precision medicine and genotype-guided dosing decisions.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/clinvar-database Skill
no license0★ repoQuery 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.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/cosmic-database Skill
no license0★ repoAccess COSMIC cancer mutation database. Query somatic mutations, Cancer Gene Census, mutational signatures, gene fusions, for cancer research and precision oncology. Requires authentication.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/drugbank-database Skill
no license0★ repoAccess and analyze comprehensive drug information from the DrugBank database including drug properties, interactions, targets, pathways, chemical structures, and pharmacology data. This skill should be used when working with pharmaceutical data, drug discovery research, pharmacology studies, drug-drug interaction analysis, target identification, chemical similarity searches, ADMET predictions, or any task requiring detailed drug and drug target information from DrugBank.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/ena-database Skill
no license0★ repoAccess European Nucleotide Archive via API/FTP. Retrieve DNA/RNA sequences, raw reads (FASTQ), genome assemblies by accession, for genomics and bioinformatics pipelines. Supports multiple formats.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/ensembl-database Skill
no license0★ repoQuery Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/fda-database Skill
no license0★ repoQuery openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/gene-database Skill
no license0★ repoQuery NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation and functional analysis.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/geo-database Skill
no license0★ repoAccess NCBI GEO for gene expression/genomics data. Search/download microarray and RNA-seq datasets (GSE, GSM, GPL), retrieve SOFT/Matrix files, for transcriptomics and expression analysis.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/gwas-database Skill
no license0★ repoQuery NHGRI-EBI GWAS Catalog for SNP-trait associations. Search variants by rs ID, disease/trait, gene, retrieve p-values and summary statistics, for genetic epidemiology and polygenic risk scores.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/hmdb-database Skill
no license0★ repoAccess Human Metabolome Database (220K+ metabolites). Search by name/ID/structure, retrieve chemical properties, biomarker data, NMR/MS spectra, pathways, for metabolomics and identification.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/kegg-database Skill
no license0★ repoDirect REST API access to KEGG (academic use only). Pathway analysis, gene-pathway mapping, metabolic pathways, drug interactions, ID conversion. For Python workflows with multiple databases, prefer bioservices. Use this for direct HTTP/REST work or KEGG-specific control.
The same file is in 6 other repositories
Metabolomics workbench database
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/metabolomics-workbench-database Skill
no license0★ repoAccess 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.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/openalex-database Skill
no license0★ repoQuery and analyze scholarly literature using the OpenAlex database. This skill should be used when searching for academic papers, analyzing research trends, finding works by authors or institutions, tracking citations, discovering open access publications, or conducting bibliometric analysis across 240M+ scholarly works. Use for literature searches, research output analysis, citation analysis, and academic database queries.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/opentargets-database Skill
no license0★ repoQuery Open Targets Platform for target-disease associations, drug target discovery, tractability/safety data, genetics/omics evidence, known drugs, for therapeutic target identification.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/pdb-database Skill
no license0★ repoAccess RCSB PDB for 3D protein/nucleic acid structures. Search by text/sequence/structure, download coordinates (PDB/mmCIF), retrieve metadata, for structural biology and drug discovery.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/pubchem-database Skill
no license0★ repoQuery PubChem via PUG-REST API/PubChemPy (110M+ compounds). Search by name/CID/SMILES, retrieve properties, similarity/substructure searches, bioactivity, for cheminformatics.
The same file is in 7 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/pubmed-database Skill
no license0★ repoDirect REST API access to PubMed. Advanced Boolean/MeSH queries, E-utilities API, batch processing, citation management. For Python workflows, prefer biopython (Bio.Entrez). Use this for direct HTTP/REST work or custom API implementations.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/reactome-database Skill
no license0★ repoQuery Reactome REST API for pathway analysis, enrichment, gene-pathway mapping, disease pathways, molecular interactions, expression analysis, for systems biology studies.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/string-database Skill
no license0★ repoQuery STRING API for protein-protein interactions (59M proteins, 20B interactions). Network analysis, GO/KEGG enrichment, interaction discovery, 5000+ species, for systems biology.
The same file is in 8 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/uniprot-database Skill
no license0★ repoDirect REST API access to UniProt. Protein searches, FASTA retrieval, ID mapping, Swiss-Prot/TrEMBL. For Python workflows with multiple databases, prefer bioservices (unified interface to 40+ services). Use this for direct HTTP/REST work or UniProt-specific control.
The same file is in 8 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/uspto-database Skill
no license0★ repoAccess USPTO APIs for patent/trademark searches, examination history (PEDS), assignments, citations, office actions, TSDR, for IP analysis and prior art searches.
The same file is in 5 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/pur3v4d3r__pur3-pkb-codebase/.claude/skills/__scientific-skills/zinc-database Skill
no license0★ repoAccess ZINC (230M+ purchasable compounds). Search by ZINC ID/SMILES, similarity searches, 3D-ready structures for docking, analog discovery, for virtual screening and drug discovery.
The same file is in 6 other repositories
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/rand__cc-polymath/skills/discover-api Skill
no license0★ repoAutomatically discover API design skills when working with REST APIs, GraphQL schemas, API authentication, OAuth, JWT, rate limiting, API versioning, error handling, or endpoint design. Activates for backend API development tasks.
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/rand__cc-polymath/skills/discover-data Skill
no license0★ repoAutomatically discover data pipeline and ETL skills when working with ETL, data pipelines, streaming, batch processing, data validation, or pipeline orchestration. Activates for data development tasks.
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/rand__cc-polymath/skills/discover-database Skill
no license0★ repoAutomatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for database design, optimization, and implementation tasks.
kenantang/codex-and-claude-skills/collected-academic-research-skills/sources/rand__cc-polymath/skills/discover-security Skill
no license0★ repoAutomatically discover security skills when working with authentication, authorization, input validation, security headers, vulnerability assessment, or secrets management. Activates for application security, OWASP, and security hardening tasks.
MYMDO/AGENTSKILL/examples/python-fastapi Skill
0★ repoImplement or review FastAPI route, schema, dependency, service, and pytest changes. Use when the user asks to add endpoints, change API behavior, validate Pydantic models, fix FastAPI bugs, or update Python API tests.
meyverick/agy-skills/skills/encore-ts-backend-engineering Skill
0★ repoEngineers type-safe backend microservices using Encore.ts. Use when orchestrating declarative architectures and infrastructure-from-code topologies.
knvpk/Agentic/skills/backend-scaffold Skill
no license0★ repoBootstrap files every new backend project needs — flake.nix dev shell, Taskfile environment loading, pre-commit linters, ruff config for Python, and OpenAPI spec init. Use when starting a new backend service or repo from scratch, or when any of these foundational files are missing.
oa2p-solutions/ecommerce-foundations/skills/webhooks Skill
0★ repoUse when designing webhook receivers or senders — signature verification, replay protection, retry policy, at-least-once handling, dead-letter strategy, and event payload contracts. Load before wiring an inbound webhook endpoint (payment processor, shipping carrier, marketplace), publishing outbound events to merchant integrations, or debugging missing/duplicate events. Cross-references idempotency, payment-flows, order-lifecycle.
openagentskills/betterskills/skills/data/sql-query-review Skill
0★ repoReviews and improves SQL queries for readability and performance using a structured checklist. Use when users ask to optimize a query, review query performance, explain a slow query, or interpret an execution plan.
openagentskills/betterskills/skills/engineering/rest-api-design Skill
0★ repoDesigns or reviews REST HTTP APIs for consistency, versioning, errors, and pagination. Use when defining endpoints, OpenAPI specs, API contracts, or when the user asks about REST resource naming and status codes.
Answering natural language questions with dbt
danielvogler/ai-skills-library/.agents/skills/answering-natural-language-questions-with-dbt Skill
0★ repoWrites and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. Use when a user asks about analytics, metrics, KPIs, or data (e.g., "What were total sales last quarter?", "Show me top customers by revenue"). NOT for validating, testing, or building dbt models during development.
danielvogler/ai-skills-library/.agents/skills/building-dbt-semantic-layer Skill
0★ repoUse when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines. Covers MetricFlow configuration, metric types (simple, derived, cumulative, ratio, conversion), and validation for both latest and legacy YAML specs.
danielvogler/ai-skills-library/.agents/skills/configuring-dbt-mcp-server Skill
0★ repoGenerates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, or troubleshooting the dbt MCP server for AI tools like Claude Desktop, Claude Code, Cursor, or VS Code.
danielvogler/ai-skills-library/.agents/skills/creating-mermaid-dbt-dag Skill
0★ repoGenerates a Mermaid flowchart diagram of dbt model lineage using MCP tools, manifest.json, or direct code parsing as fallbacks. Use when visualizing dbt model lineage and dependencies as a Mermaid diagram in markdown format.
danielvogler/ai-skills-library/.agents/skills/fetching-dbt-docs Skill
0★ repoRetrieves and searches dbt documentation pages in LLM-friendly markdown format. Use when fetching dbt documentation, looking up dbt features, or answering questions about dbt Cloud, dbt Core, or the dbt Semantic Layer.
danielvogler/ai-skills-library/.agents/skills/migrating-dbt-core-to-fusion Skill
0★ repoUse when a user needs help triaging dbt-core to Fusion migration errors. Runs dbt-autofix first, then classifies remaining errors into actionable categories (auto-fixable, guided fixes, needs input, blocked).
Migrating dbt project across platforms
danielvogler/ai-skills-library/.agents/skills/migrating-dbt-project-across-platforms Skill
0★ repoUse when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time compilation to identify and fix SQL dialect differences.
danielvogler/ai-skills-library/.agents/skills/running-dbt-commands Skill
0★ repoFormats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters. Use when running models, tests, builds, compiles, or show queries via dbt CLI. Use when unsure which dbt executable to use or how to format command parameters.
Troubleshooting dbt job errors
danielvogler/ai-skills-library/.agents/skills/troubleshooting-dbt-job-errors Skill
0★ repoDiagnoses dbt Cloud/platform job failures by analyzing run logs, querying the Admin API, reviewing git history, and investigating data issues. Use when a dbt Cloud/platform job fails and you need to diagnose the root cause, especially when error messages are unclear or when intermittent failures occur. Do not use for local dbt development errors.
Using dbt for analytics engineering
danielvogler/ai-skills-library/.agents/skills/using-dbt-for-analytics-engineering Skill
0★ repoBuilds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.
danielvogler/ai-skills-library/.agents/skills/using-dbt-index Skill
0★ repoQueries dbt project metadata locally using the dbt-index CLI — no warehouse connection needed. Use when user asks about model or column lineage, blast radius of a change, test coverage, finding or describing dbt models or sources, build performance, semantic layer metrics, business context glossary, or comparing local vs production state.
danielvogler/ai-skills-library/.agents/skills/working-with-dbt-mesh Skill
0★ repoImplements dbt Mesh governance features (model contracts, access modifiers, groups, versioning) and multi-project collaboration with cross-project refs. Use when implementing dbt Mesh governance, setting up cross-project refs with dependencies.yml, disambiguating similarly-named models across projects, or splitting a monolithic dbt project into multiple mesh projects.
pngdeity/apm-user-repository/packages/implement-offline-first-sync/.apm/skills/implement-offline-first-sync Skill
0★ repoDesign offline-first local data storage sync logs and implement optimistic concurrency models to handle conflicts when syncing local SQLite instances back to a central server. USE FOR: managing database synchronization states, authoring local sync queues, implementing version-concurrency keys (RowVersion/Timestamp), and designing conflict resolution strategies (Client Wins / Server Wins / Merge). DO NOT USE FOR: simple local storage caching or direct non-transactional database updates.
pngdeity/apm-user-repository/packages/manage-sqlite-wasm-lifecycle/.apm/skills/manage-sqlite-wasm-lifecycle Skill
0★ repoSafely manage SQLite database file lifecycles and DbContext connection states in Blazor WebAssembly sandboxes during database resets, imports, exports, and restores. USE FOR: managing virtual sqlite.db files inside browser filesystems (OPFS/IndexedDB), draining DbContext connection pools before replacing database files on disk, executing direct binary database exports, and configuring connection strings for local browser sandboxes. DO NOT USE FOR: standard server-side database migrations or normal EF Core entity schema mapping.
Techtide alibaba analyticdb realtime
TechTideOhio/techtide-harness-kit/skills/alibaba/techtide-alibaba-analyticdb-realtime Skill
0★ repoOperate AnalyticDB for MySQL and PostgreSQL, Hologres real-time OLAP analytics, and DAS real-time diagnostics for sub-second interactive analytics workloads.
Techtide alibaba mse microservice engine
TechTideOhio/techtide-harness-kit/skills/alibaba/techtide-alibaba-mse-microservice-engine Skill
0★ repoConfigure and operate Alibaba MSE (Microservice Engine) - Nacos service discovery and configuration management, Sentinel rate limiting and circuit breaking, Seata distributed transactions, and ARMS APM for microservices observability.
Techtide alibaba polardb rds dba
TechTideOhio/techtide-harness-kit/skills/alibaba/techtide-alibaba-polardb-rds-dba Skill
0★ repoOperate PolarDB (MySQL/PG/Oracle) clusters and RDS instances - DAS diagnostics, database proxy, Global Database Network, backup strategy, and performance tuning.
Techtide aws api edge delivery review
TechTideOhio/techtide-harness-kit/skills/aws/techtide-aws-api-edge-delivery-review Skill
0★ repoReview AWS API and edge delivery posture across API Gateway, CloudFront, AWS WAF, Shield, ALB, custom domains, TLS policies, authentication, authorization, throttling, quotas, caching, origin protection, logging, and abuse controls. Use when public APIs, web entry points, or edge delivery can affect security and availability.
Techtide aws dynamodb data modeling performance review
TechTideOhio/techtide-harness-kit/skills/aws/techtide-aws-dynamodb-data-modeling-performance-review Skill
0★ repoReview Amazon DynamoDB data modeling and performance across access patterns, partition keys, sort keys, secondary indexes, GSI/LSI design, hot partitions, query versus scan behavior, capacity mode, adaptive capacity, global tables, TTL, DAX, item size, transactions, and cost. Use when DynamoDB correctness, latency, scaling, or cost depends on table design.
Techtide azure private endpoint adoption planner
TechTideOhio/techtide-harness-kit/skills/azure/techtide-azure-private-endpoint-adoption-planner Skill
0★ repoUse this skill for Azure Private Link and private endpoint adoption planning, including hub-versus-spoke placement, private DNS zone linkage, route implications, centralized versus workload-local endpoint trade-offs, and safe rollout validation.
TechTideOhio/techtide-harness-kit/skills/azure/techtide-azure-rbac-review Skill
0★ repoUse this skill for Azure RBAC, Entra-backed access, role assignment, custom role, scope, subscription, management group, or least-privilege review tasks. Trigger when the user asks whether Azure access is too broad or how to grant access safely.
Techtide gcp alloydb ai developer
TechTideOhio/techtide-harness-kit/skills/gcp/techtide-gcp-alloydb-ai-developer Skill
0★ repoDesign and build AI-powered applications on AlloyDB for PostgreSQL using AlloyDB AI - covering vector search, hybrid search (vector + full-text), AI SQL functions (ai_generate, ai_classify, ai_score, ai_embed), model endpoint management, and the AlloyDB Omni edge runtime. Prefer techtide-gcp-alloydb-cloudsql-dba for cluster operations, backup, HA, and DBA tasks; use this skill when the request is primarily about AlloyDB AI search, SQL AI functions, or embedding pipelines.
Techtide gcp apigee api platform operator
TechTideOhio/techtide-harness-kit/skills/gcp/techtide-gcp-apigee-api-platform-operator Skill
0★ repoDesign and operate Apigee X API proxies - rate limiting, OAuth/JWT security policies, quota plans, developer portal setup, and API product management.
Techtide gcp cloud auth advisor
TechTideOhio/techtide-harness-kit/skills/gcp/techtide-gcp-cloud-auth-advisor Skill
0★ repoAdvise on Google Cloud authentication and authorization patterns - covering Application Default Credentials (ADC), service account best practices, Workload Identity Federation (for GKE pods and external workloads), human user auth (gcloud, IAP, Identity Platform), service-to-service auth (OIDC ID tokens, short-lived credentials), and anti-patterns like service account key downloads. Use when designing auth flows, debugging GCP auth failures, implementing least-privilege SA setup, or migrating from SA keys to keyless authentication.
Techtide gcp data pipeline engineer
TechTideOhio/techtide-harness-kit/skills/gcp/techtide-gcp-data-pipeline-engineer Skill
0★ repoDesign and troubleshoot data pipelines using Dataflow (Apache Beam), Pub/Sub messaging, Dataproc (Spark/Hadoop), Cloud Composer (Apache Airflow), and Dataplex data governance.