14.9K skills · sorted by relevance
Turn CSV, Excel, or JSON data into a visual report page with key metrics, multiple charts, a data table, and written observations. The report uses supplied data and includes its source, reporting period, and methodology.
Check article pages for structured data, machine-readable details that help search engines understand content. Review required properties, add Article metadata in JSON-LD format, and verify the rendered page and HTTP response for specific implementation gaps.
Review database migration files before merging changes. It gathers evidence about what the changes do, rollback limits, database locks, and risks from large data volumes, then reports blockers when evidence needed for a decision is missing.
Create, edit, and clean spreadsheet files, including Excel workbooks and CSV data. Add formulas, formatting, and charts, preserve existing workbook conventions, and recalculate formulas with error checks before delivering the spreadsheet.
Helps plan and implement database structure changes and data transformations using Sequelize, TypeORM, or Prisma. Includes staged changes intended to avoid downtime, plus transaction and backup examples for rolling back failed migrations.
Design dbt data transformations with clearly organized models, data quality tests, documentation, and incremental processing that updates only part of a dataset. Use it to structure analytics tables and organize a dbt project.
Analyzes one .NET project to plan integration tests for an Oracle-to-PostgreSQL migration. Identifies database access methods, prioritizes migration risks, and documents test cases, seed data, and coverage, including empty strings, NULL values, and timezone behavior.
Prepare raw credit data for pre-loan modeling by checking data quality and screening variables. Review missing values, predictive usefulness, stability, noise, and correlation, then export an Excel report with organization-level statistics and cleaning results.
Investigate suspected data theft from AWS S3 by comparing access logs, GuardDuty findings, and Macie classifications. Identify unusual bulk downloads and transfers across accounts, assess sensitive data exposure, and build automated detection rules.
Check training data and machine learning models for malicious changes, including backdoors that cause unexpected behavior on specific inputs. Combine data quality checks, model analysis, and file integrity verification, then document findings and retest after remediation.
Analyze endpoint, cloud storage, and email logs for signs of insider data theft. Use pandas to compare upload volumes with normal user behavior and examine data loss prevention alerts, unusual file access, and activity outside working hours.
Work with BigQuery to create datasets and tables, run SQL queries, ingest data, and manage processing jobs. The skill also covers connections to BigQuery ML and Gemini for machine learning and AI analysis.
Design a database layer from business requirements, access patterns, and expected growth. Compare database technologies, define tables and relationships, and plan indexes, caching, scaling, migrations, backups, and recovery with clear reasons and trade-offs.
Build document search and AI retrieval workflows with Chroma, a database for numerical representations of text. Cover document storage, meaning-based search, metadata filters, persistence, and connections to LangChain and LlamaIndex.
Retrieve locally stored Chinese A-share prices, financial statements, and valuation context through the project's shared interfaces. Look up technical indicators, inspect available data fields, and check data dates when results disagree.
Check single-cell RNA-seq data quality, filter low-quality cells using median absolute deviation, a measure of spread, and compare plots before and after filtering. Outputs include filtered data and the original dataset with quality annotations.
Analyze single-cell data with scvi-tools, using deep learning to combine datasets, correct differences between experiments, and transfer cell labels. Model guides and reusable scripts cover RNA, protein, chromatin accessibility, spatial data, and downstream analysis.
Run nf-core workflows on local sequencing files or public GEO/SRA datasets to analyze gene expression, genetic variants, or chromatin accessibility. The skill guides environment checks, sample table preparation, workflow configuration, execution, and output verification.
Review code for privacy risks, prepare data protection impact assessments, and track personal data requests and deadlines. The skill supports GDPR and German privacy compliance work, with final compliance decisions referred to a data protection officer or legal counsel.
Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.
Write JavaScript for n8n Code nodes to aggregate, filter, and transform workflow data. Guidance covers data access, output formats, execution modes, common errors, and performance choices when processing large numbers of records.
Plan and configure GKE cluster networks, including private nodes, IP address ranges, DNS, and outbound connectivity. Use the guidance to set up VPC-native networking and Dataplane V2, which provides built-in network policy enforcement.
Guides implementation of audience uploads, individual removals, and full replacements through the Data Manager API. It covers formatting and hashing identifiers, validating requests, and checking processing results for Customer Match and supported device ID audiences.
Plan data ingestion and transformation workflows with Apache Airflow, Spark, and dbt. Get guidance on processing changed records, validating data quality, and rerunning failed or historical jobs without creating duplicate results.