Data & backend
10,176 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/brownbull/data-orchestrator Skill
59★ repoCoordinates data pipeline tasks (ETL, analytics, feature engineering). Use when implementing data ingestion, transformations, quality checks, or analytics. Applies data-quality-standard.md (95% minimum).
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/chriswiles/graphql-schema Skill
59★ repoGraphQL queries, mutations, and code generation patterns. Use when creating GraphQL operations, working with Apollo Client, or generating types.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cjharmath/postgres-patterns Skill
59★ repoPostgreSQL patterns for reviewing migrations and writing efficient queries. Use when reviewing Alembic migrations, optimizing queries, or debugging database issues.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cjharmath/postgres-performance Skill
59★ repoHigh-performance PostgreSQL patterns. Use when optimizing queries, designing for scale, or debugging performance issues.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cjharmath/py-fastapi-patterns Skill
59★ repoFastAPI patterns for API design. Use when creating endpoints, handling dependencies, error handling, or working with OpenAPI schemas.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cjharmath/py-sqlmodel-patterns Skill
59★ repoSQLModel and async SQLAlchemy patterns. Use when working with database models, queries, relationships, or debugging ORM issues.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cjharmath/web-auth Skill
59★ repoAuthentication patterns for React web applications. Use when implementing login flows, OAuth, JWT handling, session management, or protected routes in React web apps.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cleanexpo/api-endpoint-creation Skill
59★ repoNext.js 15+ API endpoint creation patterns with Supabase and workspace validation
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cleanexpo/backend-agent Skill
59★ repoHandles backend/API/database work for Unite-Hub. Implements Next.js API routes, Supabase database operations, RLS policies, authentication, and third-party integrations (Gmail, Stripe).
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/cleanexpo/database-migration Skill
59★ repoGuide for creating idempotent Supabase database migrations with RLS policies and workspace isolation
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/consiliency/schema-alignment Skill
59★ repoDetect and report drift between database schema and code data models. Works with SQLAlchemy, Django ORM, Prisma, TypeORM, and other ORMs. Generic across any project.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/crazydubya/database-migration-helper Skill
59★ repoCreates database migration files following project conventions for Prisma, Sequelize, Alembic, Knex, TypeORM, and other ORMs. Use when adding tables, modifying schemas, or when user mentions database changes.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/crearize/develop-backend Skill
59★ repoSpring Boot/MyBatisによるバックエンド実装スキル - RESTful API設計、データベース設計(Flywayマイグレーション)、Controller/Service/Mapper層の実装、単体テスト作成を行います。DRY原則を徹底し、product.utilパッケージの既存実装やAOPによる自動ログ出力を活用します。未使用コード削除をIDE警告で確認し、./gradlew checkでLint/テスト/カバレッジ80%以上を保証します。サーバー起動による動作確認も必須です。
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/crossbill-highlights/database-operations Skill
59★ repoInstructions on how to write database queries with SQLAlchemy.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/curiouslearner/auth-analyzer Skill
59★ repoReview and analyze authentication and authorization patterns for security vulnerabilities.
The same file is in 1 other repository
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/curiouslearner/query-builder Skill
59★ repoInteractive database query builder for generating optimized SQL and NoSQL queries.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/curiouslearner/webhook-tester Skill
59★ repoTest webhook integrations locally with tunneling, inspection, and debugging tools.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/daisuke897/aws-sso-login Skill
59★ repoAuthenticate to AWS using Single Sign-On (SSO). Use when AWS CLI operations require SSO authentication or when SSO session has expired.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/danielpodolsky/backend-fundamentals Skill
59★ repoAuto-invoke when reviewing API routes, server logic, Express/Node.js code, or backend architecture. Enforces REST conventions, middleware patterns, and separation of concerns.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/danielpodolsky/database-fundamentals Skill
59★ repoAuto-invoke when reviewing schema design, database queries, ORM usage, or migrations. Enforces normalization, indexing awareness, query optimization, and migration safety.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/danielpodolsky/security-fundamentals Skill
59★ repoAuto-invoke when reviewing authentication, authorization, input handling, data exposure, or any user-facing code. Enforces OWASP top 10 awareness and security-first thinking.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/alphafold-database Skill
59★ repoAccess AlphaFold's 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.
The same file is in 7 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/api-integration-specialist Skill
59★ repoExpert in integrating third-party APIs with proper authentication, error handling, rate limiting, and retry logic. Use when integrating REST APIs, GraphQL endpoints, webhooks, or external services. Specializes in OAuth flows, API key management, request/response transformation, and building robust API clients.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/biorxiv-database Skill
59★ repoEfficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.
The same file is in 5 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/brenda-database Skill
59★ repoAccess BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.
The same file is in 4 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/chembl-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/clinicaltrials-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/clinpgx-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/clinvar-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/cosmic-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/drugbank-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/ena-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/ensembl-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/fda-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/gene-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/geo-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/gwas-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/hmdb-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/kegg-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/metabolomics-workbench-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/openalex-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/opentargets-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/pdb-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/pubchem-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/pubmed-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/reactome-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/senior-backend Skill
59★ repoComprehensive backend development skill for building scalable backend systems using NodeJS, Express, Go, Python, Postgres, GraphQL, REST APIs. Includes API scaffolding, database optimization, security implementation, and performance tuning. Use when designing APIs, optimizing database queries, implementing business logic, handling authentication/authorization, or reviewing backend code.
The same file is in 4 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/senior-data-engineer Skill
59★ repoWorld-class data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka, and modern data stack. Includes data modeling, pipeline orchestration, data quality, and DataOps. Use when designing data architectures, building data pipelines, optimizing data workflows, or implementing data governance.
The same file is in 4 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/string-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/uniprot-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/uspto-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/davila7/zinc-database Skill
59★ 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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/dbxstudio/sql-queries-tool Skill
59★ repoExpert SQL query generation for DBX Studio. Use when writing, optimizing, or debugging SQL queries against user database connections.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/dbxstudio/sql-queries Skill
59★ repoExpert SQL query generation for DBX Studio. Use when writing, optimizing, or debugging SQL queries against user database connections.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/dennisliuck/sql-to-osc Skill
59★ repoSQL to OSC (Online Schema Change) conversion expert for Flyway migration scripts. Use when: (1) Converting SQL migration files to OSC format, (2) User mentions "OSC", "轉換 OSC", "osc.txt", or "Online Schema Change", (3) Working with Flyway ALTER TABLE/CREATE INDEX statements that need OSC conversion.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/devanb/backend-api Skill
59★ repoDesign and implement RESTful API endpoints following best practices for routing, versioning, and HTTP standards. Use this skill when creating or modifying API routes, controllers, or endpoints in files like routes/api.php, API controller files in app/Http/Controllers/Api/, controller files in app/Http/Controllers/, API resource classes, or when implementing REST API functionality. Use when working on URL structures, HTTP method handling (GET, POST, PUT, PATCH, DELETE), API versioning strategies, query parameter handling for filtering/sorting/pagination, HTTP status code responses, rate limiting configuration, or any API endpoint design decisions.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/devanb/backend-migrations Skill
59★ repoCreate reversible, focused database migrations with proper naming, version control practices, and zero-downtime deployment considerations. Use this skill when creating or editing migration files in database/migrations/, when writing schema changes (creating/modifying tables, columns, indexes, foreign keys), when implementing migration rollback methods, when managing database version control, when adding or modifying indexes on large tables, or when separating schema changes from data migrations for safer deployments.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/devanb/backend-models Skill
59★ repoDefine and configure database models with proper naming, relationships, timestamps, data types, constraints, and validation. Use this skill when creating or editing model files in app/Models/, Eloquent model classes, model relationships (hasMany, belongsTo, etc.), database table structures, model attributes and casts, model factories, or seeders. Use when working on model validation logic, database constraints, foreign key relationships, indexes, scopes, accessors, mutators, or any ORM-related model configuration.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/devanb/backend-queries Skill
59★ repoWrite secure, performant, and optimized database queries using parameterized queries, eager loading, proper indexing, and transaction management. Use this skill when writing database queries in controllers, repositories, services, or model methods, when using query builders or ORM methods, when implementing filtering/sorting/pagination logic, when optimizing N+1 query problems with eager loading, when working with joins and complex queries, when implementing query caching, or when wrapping related operations in database transactions.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/diet103/backend-dev-guidelines Skill
59★ repoComprehensive backend development guide for Node.js/Express/TypeScript microservices. Use when creating routes, controllers, services, repositories, middleware, or working with Express APIs, Prisma database access, Sentry error tracking, Zod validation, unifiedConfig, dependency injection, or async patterns. Covers layered architecture (routes → controllers → services → repositories), BaseController pattern, error handling, performance monitoring, testing strategies, and migration from legacy patterns.
The same file is in 5 other repositories