Jerry Lin avatar

Jerry Lin

Community

@jerrylin96 · Boston, MA

58Followers
|
38Public Repos
|
42Published Skills

Postdoctoral Associate at Boston University

Skills Distribution
DomainData Systems...GCP Data Engineeri.. (45%)BigQuery Analytics.. (20%)Software Engineeri.. (20%)Cloud Security & G.. (10%)

Agent Skills by Jerry Lin

Showing 42 vetted skills indexed across 1 GitHub repositories.

jerrylin96jerrylin96
9

gcp-data-pipelines

Routes data pipeline requests to the appropriate Google Cloud tool skill.

Community
Intermediate
jerrylin96jerrylin96
9

debugging-and-error-recovery

Diagnose test failures, build errors, and runtime bugs through structured root-cause triage.

Community
Intermediate
jerrylin96jerrylin96
9

timeline-postmortem

Diagnoses missed deadlines via 5 Whys interviews and reschedules Google Workspace tasks with buffered timelines.

Community
Intermediate
jerrylin96jerrylin96
9

discovering-gcp-data-assets

Searches Dataplex catalog and retrieves schema metadata for Google Cloud data assets.

Community
Intermediate
jerrylin96jerrylin96
9

gcp-spark

Generates and executes PySpark code on Google Cloud Dataproc clusters and Serverless.

Community
Advanced
jerrylin96jerrylin96
9

test-driven-development

Guides writing failing tests before implementation using the RED-GREEN-REFACTOR cycle.

Community
Intermediate
jerrylin96jerrylin96
9

planning-and-task-breakdown

Decompose specifications into atomic TDD tasks with acceptance criteria and dependency ordering.

Community
Advanced
jerrylin96jerrylin96
9

managing-python-dependencies

Detects project dependency managers and installs Python packages with the correct tooling.

Community
Intermediate
jerrylin96jerrylin96
9

incremental-implementation

Implements multi-file code changes in thin vertical slices with test and commit cycles.

Community
Advanced
jerrylin96jerrylin96
9

math-proof-audit

Verify mathematical code implementations against LaTeX derivations via adversarial subagent audits.

Community
Advanced
jerrylin96jerrylin96
9

data-autocleaning

Profiles and cleans BigQuery and GCS data using Dataplex scans and SQL transformations.

Community
Advanced
jerrylin96jerrylin96
9

gcp-dataflow

Guides authoring, packaging, launching, and diagnosing Apache Beam pipelines on Google Cloud Dataflow.

Community
Advanced
jerrylin96jerrylin96
9

bigquery-data-transfer-service

Discovers and inspects BigQuery Data Transfer Service configurations for data ingestion pipelines.

Community
Advanced
jerrylin96jerrylin96
9

signoff

Verifies human comprehension of branch diffs via Socratic interview and records Git attestation trailers.

Community
Advanced
jerrylin96jerrylin96
9

dbt-bigquery

Generates, modifies, and validates dbt models and pipelines targeting Google BigQuery.

Community
Advanced
jerrylin96jerrylin96
9

gcp-composer-troubleshooting

Diagnoses Cloud Composer and Airflow DAG failures using gcloud logs and remote code retrieval.

Community
Intermediate
jerrylin96jerrylin96
9

ponytail

Enforces minimal code solutions by applying YAGNI, reuse, and stdlib-first principles.

Community
Basic
jerrylin96jerrylin96
9

bigquery

Generates optimized BigQuery SQL, BigFrames code, and BQML AI function queries.

Community
Intermediate
jerrylin96jerrylin96
9

session-sync

Synchronizes Antigravity CLI conversation sessions across machines using Git remote refs.

Community
Advanced
jerrylin96jerrylin96
9

federate-lakehouse-catalog

Configures Google Cloud Lakehouse federated catalogs connecting BigQuery to Databricks Unity or AWS Glue.

Community
Advanced
jerrylin96jerrylin96
9

catchmeup

Summarizes git repository activity over preset time windows with signoff attestation audits.

Community
Intermediate
jerrylin96jerrylin96
9

adversarial-review

Reviews specs, plans, tests, and code diffs across four adversarial lifecycle gates.

Community
Advanced
jerrylin96jerrylin96
9

accidental-data-loss-prevention

Blocks irreversible deletion commands until explicit user consent is obtained.

Community
Basic
jerrylin96jerrylin96
9

building-data-apps

Build data dashboards and interactive reports with React, Vite, or Streamlit on GCP data sources.

Community
Advanced

Frequently Asked Questions About Jerry Lin

FAQPage Schema
What tasks can I accomplish with jerrylin96's skill registry?

You can build, deploy, and troubleshoot Google Cloud data pipelines: BigQuery SQL and BQML, dbt and Dataform ELT models, Apache Beam Dataflow jobs, Spark on Dataproc Serverless, Cloud Composer orchestration, DTS ingestion configs, lakehouse federation, plus GCS security audits and data-loss prevention guardrails.

Who is the target audience for these skills?

Data engineers, analytics engineers, and ML practitioners working on Google Cloud, plus software developers wanting disciplined workflows. Skills like test-driven-development, adversarial-review, spec-driven-development, and codebase-audit serve engineers enforcing quality gates before merging branch diffs.

How do the GCP pipeline skills work together in practice?

Start with gcp-data-pipelines as the entry router, then use specialized skills: discovering-gcp-data-assets to locate tables, dbt-bigquery or dataform-bigquery for transformations, gcp-dataflow or gcp-spark for processing, gcp-pipeline-orchestration for Composer DAGs, and gcp-pipeline-resource-provisioning for deployment.yaml-based provisioning.

Are these skills open source and what do they cost?

Most Google-published skills carry the Apache-2.0 license, permitting free use and modification; the ponytail skill uses MIT. Skills without explicit license metadata should be reviewed individually. There is no registry fee; costs derive only from underlying Google Cloud resource consumption.

What prerequisites are required to run these skills?

GCP skills require authenticated gcloud CLI with Application Default Credentials (gcloud-auth-verification resolves auth errors), appropriate IAM permissions, and project access to BigQuery, Dataflow, Dataproc, or Composer. Python-based work requires project-scoped virtual environments per managing-python-dependencies rather than global pip installs.