#SkillRepo stars
- 289Postgres Engineeringsandbaseai/workbuddy-skillUse when designing, changing, querying, securing, or diagnosing PostgreSQL databases; establish the real version and workload, prefer read-only evidence, and bound production effects before schema, index, maintenance, replication, or recovery actions.9
- 290Project Bindingssandbaseai/workbuddy-skillUse when authoring or changing a repository's project-specific bindings such as module ownership, workspace roots, database locations, gate keys, namespaces, palettes, registry contracts, or release values; keep facts in one authoritative declaration.9
- 291Schema Designsandbaseai/workbuddy-skillUse when designing or reviewing relational schema changes, initialization SQL, migrations, privileges, seed data, constraints, indexes, or schema tests; preserve authority boundaries and verify the real database contract.9
- 292SQL Code Reviewsandbaseai/workbuddy-skillUse when reviewing SQL across MySQL, PostgreSQL, SQL Server, or Oracle for injection risk, access control, correctness, performance, maintainability, and migration safety.9
- 293SQL Optimizationsandbaseai/workbuddy-skillUniversal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.9
- 294Importing Datatilmon-engineering/claude-skillsSystematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)5
- 295Using Sqlitetilmon-engineering/claude-skillsUse when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.5
- 296Using Typedbtilmon-engineering/claude-skillsUse when interacting with a TypeDB 3.x database via the typedb MCP tools (typedb-query, typedb-database_schema, etc.) - covers schema-first workflow, transaction types, TypeQL 3.x syntax (which differs materially from 2.x), and the most common failure modes5
- 297Accidental Data Loss Preventionhuytran1120/vietnam-agentic-skills**STOP AND VERIFY**: Before running any command or tool that results in irreversible data loss, you MUST obtain explicit user consent. When in doubt, ask. It is better to wait for confirmation than to accidentally delete production data or critical project assets. Use this for: - SQL: DROP TABLE/VIEW/SCHEMA/DATABASE, TRUNCATE, or broad DELETE (missing WHERE or using 1=1). - Cloud Storage: gsutil rm or gcloud storage rm targeting production data or critical buckets. - Infrastructure: gcloud projects delete, deleting Spanner/BigQuery/Dataproc resources, deleting secrets, or KMS key destruction.9
- 298Alphafold Database Fetch and Analyzehuytran1120/vietnam-agentic-skillsRetrieve and analyze AlphaFold predicted structures for a protein. Use when the user provides a specific UniProt Accession ID and wants structural confidence metrics (pLDDT), domain boundary analysis, or disorder assessment. Do not use if the user only has a protein name, gene name, or amino acid sequence — ask for a UniProt ID first.9
- 299Bio Biomart Querieshackernoon/cuttlefish-agent-skillsBulk-query Ensembl BioMart (and other BioMart instances) for cross-database ID mapping, gene/transcript/exon coordinates, and ortholog tables. Use when batch-converting Ensembl IDs to other namespaces (HGNC, RefSeq, UniProt, Entrez), pulling gene coordinate tables for thousands of genes, building ortholog wide-tables across species, or replacing slow Ensembl REST loops with one-shot bulk export. Encodes BioMart's XML query format, R biomaRt vs Python pybiomart trade-off, mart-vs-dataset hierarchy, and the URL endpoint that's BioMart-specific (separate from rest.ensembl.org).9
- 300Bio Blast Searcheshackernoon/cuttlefish-agent-skillsRun remote BLAST searches against NCBI servers using Biopython Bio.Blast.NCBIWWW. Use when identifying unknown sequences, finding homologs, picking the correct BLAST program (blastn/blastp/blastx/tblastn/tblastx/psiblast/megablast/dc-megablast), interpreting Karlin-Altschul E-values, avoiding the max_target_seqs trap (Shah 2019), choosing composition-based statistics, or limiting searches by organism. Covers RID lifecycle, database choice (nt/nr/refseq_select/swissprot), word-size and CBS taxonomy.9
- 301Bio Entrez Linkhackernoon/cuttlefish-agent-skillsFind cross-database references between NCBI databases using Biopython Bio.Entrez (ELink). Use when navigating gene to protein/structure, sequence to publication, PubMed to GEO, BioProject to SRA runs, or discovering all link relationships for a record. Covers linkname semantics, cmd= variants, asymmetric link warnings, neighbor_history for >200 input IDs, and per-database link tables.9
- 302Bio Gene Regulatory Networks Scenic Regulonshackernoon/cuttlefish-agent-skillsInfer transcription factor regulons from single-cell RNA-seq with pySCENIC by combining GRNBoost2 co-expression, cisTarget motif-enrichment pruning, and AUCell per-cell activity scoring. Covers the motif-pruning-as-directionality principle, regulon specificity scoring, run-to-run stability, and database/species matching. Use when identifying TF regulons, scoring TF activity per cell, finding master regulators of cell identity, or comparing regulon activity across conditions. For enhancer-driven multiomic GRNs see multiomics-grn; for bulk inference and VIPER protein-activity see grn-inference.9
- 303Bio Genome Annotation Prokaryotic Annotationhackernoon/cuttlefish-agent-skillsAnnotates bacterial and archaeal genomes (isolates, MAGs, plasmids) with Bakta (active versioned databases, NCBI-compliant output) or Prokka (legacy), producing GFF3/GenBank/EMBL/FASTA with INSDC locus tags. Covers Bakta-vs-Prokka-vs-PGAP-vs-DFAST choice, light-vs-full database tiers, translation-table selection (11/4/25), archaeal and leaderless-gene caveats, the small-ORF blind spot, pseudogene-vs-phase-variation, the pangenome re-annotation trap, and submission compliance. Use when annotating a newly assembled prokaryotic genome, choosing an annotation tool, re-annotating a collection for p9
- 304Bio Immunoinformatics Tcr Epitope Bindinghackernoon/cuttlefish-agent-skillsInfer or annotate TCR antigen specificity by unsupervised clustering (TCRdist/tcrdist3, GLIPH2, clusTCR, GIANA) and database lookup (VDJdb, IEDB, McPAS-TCR), and rank candidates with supervised predictors (ERGO-II, NetTCR-2.x, pMTnet) under explicit caveats. Encodes the central truth that general TCR-epitope prediction for UNSEEN epitopes essentially does not work (collapses to near-random; IMMREP22, Grazioli 2022) because labeled data is dominated by a few immunodominant epitopes and there is no true negative set — so clustering for discovery is the honest task and de-novo binding needs wet-l9
- 305Bio Interaction Databaseshackernoon/cuttlefish-agent-skillsQuery protein-protein and gene interaction databases (STRING, BioGRID, IntAct, SIGNOR, Reactome, HuRI, HuMAP, OmniPath, ConsensusPathDB, DIP). Use when building PPI networks, choosing between physical vs functional vs genetic interactions, signed/directed vs undirected, high-throughput vs curated, picking confidence thresholds, aggregating across resources, or navigating license constraints. Encodes the database decision matrix, STRING v12 channel semantics, OmniPath as meta-database, SIGNOR for signed signaling, and per-resource rate limits.9
- 306Bio Local Blasthackernoon/cuttlefish-agent-skillsBuild local BLAST databases and run searches using NCBI BLAST+ command-line tools. Use when running >50 queries, building custom databases with -parse_seqids and -taxid, downloading prebuilt NCBI databases via update_blastdb.pl, choosing -task variants (megablast/dc-megablast/blastn/blastn-short), tuning soft/hard masking, scaling threads, or extracting hits with blastdbcmd. Encodes BLAST v5 vs v4 database format, taxonomy filtering, makeblastdb pitfalls.9
- 307Bio Metagenomics Functional Profilinghackernoon/cuttlefish-agent-skillsProfiles the functional potential of shotgun metagenomes with HUMAnN 3's tiered search (MetaPhlAn prescreen, Bowtie2 pangenome, translated DIAMOND vs UniRef), giving gene-family (RPK) and MetaCyc pathway abundances stratified by species. Covers why a metagenome measures potential not activity, why dropping UNMAPPED/UNINTEGRATED biases everything, why stratification is an estimate, coverage-vs-abundance and MinPath/gap-fill, UniRef90-vs-50 and biome database bias, and the assembly/eggNOG/dbCAN/antiSMASH alternatives. Use when obtaining pathway or gene-family abundances, regrouping to KO/EC/GO, 9
- 308Bio Metagenomics Krakenhackernoon/cuttlefish-agent-skillsClassifies shotgun metagenomic reads to taxa with Kraken2's minimizer/LCA matching against a chosen reference database, then hands off to Bracken for abundance re-estimation. Covers why the database (not the algorithm) decides what can be detected, the --confidence and --minimum-hit-groups precision levers, unique-minimizer false-positive control, host-read removal, and why raw Kraken2 read counts are not abundances. Use when profiling who-is-there from shotgun reads, choosing a Kraken2 database, setting a confidence threshold, controlling false positives, or feeding reports to Bracken. For ma9
- 309Bio Metagenomics Metaphlanhackernoon/cuttlefish-agent-skillsProfiles shotgun metagenomes to species/SGB relative abundance with MetaPhlAn 4's clade-specific marker genes (bowtie2 short reads, minimap2 long reads). Covers why a MetaPhlAn percentage is a cell fraction (genome-size-normalized taxonomic abundance) and must never be merged with Kraken/Bracken read fractions, kSGB vs uSGB units for quantifying database-absent taxa, the unknown-fraction rescaling and its version-default flip, --index pinning as a batch variable, and when mOTUs3 or sourmash gather beat marker profiling. Use when profiling who-is-there with high precision, needing HMP-comparabl9
- 310Bio Microbiome Taxonomy Assignmenthackernoon/cuttlefish-agent-skillsAssigns taxonomy to amplicon ASVs/OTUs (16S, ITS, 18S) with a classifier conditioned on a reference database and primer region - DADA2 assignTaxonomy + addSpecies (RDP naive Bayes), DECIPHER IDTAXA, and QIIME2 q2-feature-classifier (classify-sklearn naive Bayes, classify-consensus-vsearch alignment-consensus). Covers region-specific training (extract-reads, fit-classifier-naive-bayes), why a full-length classifier fabricates calls on a V4 read, the scikit-learn version-pinning trap on pre-trained .qza classifiers, confidence thresholds (classify-sklearn 0.7, assignTaxonomy minBoot 50), and cho9
- 311Bio Primer Design Primer Specificityhackernoon/cuttlefish-agent-skillsChecks whether a PCR primer PAIR amplifies only the intended target genome-wide, using pair-aware in-silico PCR (MFEprimer-3.0, UCSC isPcr, NCBI Primer-BLAST) plus a primer3-py 3'-end-stability prefilter, against the correct database. Covers why plain BLAST is the wrong tool (it scores per-primer similarity, blind to 3'-terminal anchoring and to whether the two primers form a convergent amplicon in range), why a single 3'-terminal mismatch suppresses amplification while internal mismatches are tolerated, why intron-spanning RT-qPCR is defeated by processed pseudogenes that force a GENOME searc9
- 312Bio Proteomics Peptide Identificationhackernoon/cuttlefish-agent-skillsPeptide-spectrum matching from MS/MS with target-decoy FDR control, framing identification confidence as a property of a ranked list (q-value/PEP) rather than a raw engine score (XCorr, hyperscore, Andromeda, SpecEValue). Covers sequence-database search engines (Comet, MS-GF+, MSFragger, Sage, MaxQuant, MetaMorpheus), concatenated vs separate target-decoy competition, PEP vs q-value, the multi-level FDR cascade, open/mass-tolerant search, rescoring (Percolator, mokapot, MS2Rescore), and pyOpenMS SimpleSearchEngineAlgorithm + FalseDiscoveryRate. Use when identifying peptides from tandem mass sp9
- 313Bio Read Alignment Star Alignmenthackernoon/cuttlefish-agent-skillsAligns RNA-seq reads to a genome with STAR, the fast splice-aware aligner whose splice-junction database (built from a GTF at sjdbOverhang = readlength-1) and two-pass mode set junction sensitivity, whose 255-for-unique MAPQ breaks GATK, and whose GeneCounts output reveals library strandedness. Use when RNA reads must be placed on the genome for novel-isoform discovery, fusion detection, RNA variant calling, coverage tracks, splicing QC, or single-cell (STARsolo). Memory-constrained RNA alignment is hisat2-alignment; DE on known transcripts only should skip alignment for rna-quantification/ali9
- 314Bun Read and Write Data to MongoDB Using Mongoose and Bunjarle/bun-skillsRead and write data to MongoDB using Mongoose and Bun9
- 315Bun Redisjarle/bun-skillsUse Bun's native Redis client with a Promise-based API9
- 316Bun SQLjarle/bun-skillsBun provides native bindings for working with SQL databases through a unified Promise-based API that supports PostgreSQL, MySQL, and SQLite.9
- 317Bun SQLitejarle/bun-skillsBun natively implements a high-performance SQLite3 driver.9
- 318Bun TCPjarle/bun-skillsUse Bun's native TCP API to implement performance sensitive systems like database clients, game servers, or anything that needs to communicate over TCP (instead of HTTP)9
- 319Get Marketplace PriceLord1Egypt/RA-SkillsGiven a Discogs release/master URL, ID, or free-form release reference, return live Marketplace listings (per-listing price, media + sleeve condition, seller info, shipping, comments) plus full release-level metadata. Hybrid: public Database API for metadata + aggregate stats;…9
- 320Data Lake PlatformFreddy-CHEN-ux/00_claude_skillsUniversal data lake and lakehouse patterns covering ingestion (dlt, Airbyte), transformation (SQLMesh, dbt), storage formats (Iceberg, Delta, Hudi, Parquet), query engines (ClickHouse, DuckDB, Doris, StarRocks), streaming (Kafka, Flink), orchestration (Dagster, Airflow, Prefect), and visualization (Metabase, Superset, Grafana). Self-hosted and cloud options.8
- 321Data SQL OptimizationFreddy-CHEN-ux/00_claude_skillsProduction-grade SQL optimization for OLTP systems: EXPLAIN/plan analysis, balanced indexing, schema and query design, migrations, backup/recovery, HA, security, and safe performance tuning across PostgreSQL, MySQL, SQL Server, Oracle, SQLite.8
- 322Database BackupFreddy-CHEN-ux/00_claude_skillsBackup database before tests, migrations, or other database operations8
- 323Database FirstFreddy-CHEN-ux/00_claude_skillsREQUIRED before implementing any game feature, scoring logic, state transition, or decision-making. ALL business logic lives in PostgreSQL - frontend is presentation only. Load this to understand where code belongs: database function vs component. Covers RPC patterns, SECURITY DEFINER, and anti-patterns.8
- 324Gameplay SQLFreddy-CHEN-ux/00_claude_skillsTest game mechanics via SQL. Use game_* tools for gameplay flow.8
- 325Postgres VectorsFreddy-CHEN-ux/00_claude_skillsUse when working with embeddings, semantic similarity, vector search, or the <-> <#> <=> operators. Load for pgvector queries, HNSW index creation, embedding storage, or similarity calculations. Covers distance operators, index strategies, and common pitfalls with 384-dimensional vectors.8
- 326Search Skill DatabaseFreddy-CHEN-ux/00_claude_skillsQuery ALL available Skills database in Notion with filters. Load when user mentions "search skill database", "query notion", "search skills database", "find skills in notion", or "browse notion skills".8
- 327Share SkillFreddy-CHEN-ux/00_claude_skillsPush a local skill to the Notion skills database. Load when user mentions "share skill", "export skill", "push to notion", "add skill to database", or after creating a new skill with create-skill.8
- 328SQL ReaderFreddy-CHEN-ux/00_claude_skillsQuery production PostgreSQL database with read-only credentials. Use for investigating data, debugging issues, or analyzing application state.8
- 329Creator IntelligenceDreydrey9000/claude-skillsScrape, deconstruct, and database any Instagram creator or Viral Editz client's entire content strategy. Input = Instagram handle or client name. Output = full Notion database with deconstructed videos, hooks, scripts, frameworks, editing styles, performance data, Content Market Fit profile, and queryable intelligence. This is the BUSINESS tool for Viral Editz clients and creators — NOT for personal/dating intel (use ig-profile-scraper for that). Triggers: "deconstruct this creator", "add to creator database", "competitor analysis", "creator intelligence", "client database", "viral database", 5
- 330Azure Postgres Tslucaspmarie-a11y/claude-skills-vaultConnect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.5
- 331Azure Resource Manager Mysql Dotnetlucaspmarie-a11y/claude-skills-vaultAzure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.5
- 332Cc Skill Clickhouse Iolucaspmarie-a11y/claude-skills-vaultClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.5
- 333Claimable Postgreslucaspmarie-a11y/claude-skills-vaultProvision instant temporary Postgres databases via Claimable Postgres by Neon (pg.new). No login or credit card required. Use for quick Postgres environments and throwaway DATABASE_URL for prototyping.5
- 334Analyzing Database Indexesjeremylongshore/claude-code-plugins-plus-skillsThis skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.
- 335Analyzing Query Performancejeremylongshore/claude-code-plugins-plus-skillsThis skill enables Claude to analyze and optimize database query performance. It activates when the user discusses query performance issues, provides an EXPLAIN plan, or asks for optimization recommendations. The skill leverages the query-performance-analyzer plugin to interpret EXPLAIN plans, identify performance bottlenecks (e.g., slow queries, missing indexes), and suggest specific optimization strategies. It is useful for improving database query execution speed and resource utilization.
- 336Archiving Databasesjeremylongshore/claude-code-plugins-plus-skillsThis skill automates database archival processes. It helps reduce primary database size by moving historical records to archive tables or cold storage solutions like S3, Azure Blob, or GCS. The plugin supports PostgreSQL and MySQL, implementing automated retention policies, compression, compliance tracking, and zero-downtime migration. Use this when the user mentions "database archival", "archive old database records", "retention policies", "cold storage", or "reduce database size." It is particularly useful for handling requests related to data lifecycle management and compliance requirements