Skill Creator

terrylica

70 published skills · 194 GitHub stars across the catalog. View on GitHub ↗

creating-knowledge-entries

terrylica's avatarfrom terrylica★ 1

Create structured GitHub Issue knowledge entries with one-shot input. Handles auto-formatting, AI labeling, title extraction, and publishing. Use when user wants to share tips, document solutions, create how-tos, or add any knowledge to the base.

file-searching

terrylica's avatarfrom terrylica★ 1

Regex-based file search across repository contents using gh-grep extension. Use when searching code files for patterns, not issue content.

label-management

terrylica's avatarfrom terrylica★ 1

Create, edit, delete, and organize GitHub Issue labels and milestones. Use for label operations, milestone management, or organizing issue taxonomy.

managing-lifecycle

terrylica's avatarfrom terrylica★ 1

Create, update, close, and bulk process GitHub Issues with state management and metadata updates. Use for CRUD operations, changing issue states, or batch processing.

searching-issues

terrylica's avatarfrom terrylica★ 1

Search GitHub Issues and PRs with 30+ qualifiers including labels, dates, users, state, milestones, and content. Use when searching for issues by keywords, metadata, or complex filters.

documentation-improvement-workflow

terrylica's avatarfrom terrylica

Systematically improve documentation quality from 7/10 → 9/10 using assessment checklists and transformation patterns. Use when documentation exists but lacks Quick Start, clear prerequisites, or working examples. Optimized for crypto/trading data projects.

duckdb-remote-parquet-query

terrylica's avatarfrom terrylica

Query remote Parquet files via HTTP without downloading using DuckDB httpfs. Leverage column pruning, row filtering, and range requests for efficient bandwidth usage. Use for crypto/trading data distribution and analytics.

multi-agent-parallel-investigation

terrylica's avatarfrom terrylica

Decompose complex questions into 4-6 parallel investigations with different perspectives, synthesize into phased decision framework. Use when facing architecture decisions with multiple unknowns in crypto/trading data platforms.

mql5-x-compile

terrylica's avatarfrom terrylica

Compile MQL5 indicators via CLI using X: drive mapping to bypass 'Program Files' path spaces issue. Use when compiling MQL5, MetaEditor, indicators, scripts, or when user mentions compilation errors related to paths with spaces.

mt5-log-reader

terrylica's avatarfrom terrylica

Reads MetaTrader 5 log files to validate indicator execution, unit tests, and compilation errors. Use when user mentions Experts pane, MT5 logs, errors, or asks "did it work".

clickhouse-cloud-connection

terrylica's avatarfrom terrylica

Test and validate ClickHouse Cloud connection using clickhouse-connect for gapless-crypto-clickhouse. Use when validating connectivity, troubleshooting connection issues, or verifying environment configuration. Includes version check and query validation.

clickhouse-cloud-credentials

terrylica's avatarfrom terrylica

Store ClickHouse Cloud credentials in Doppler + 1Password for gapless-crypto-clickhouse. Use when setting up new services, rotating credentials, or backing up authentication material. Covers API keys, connection details, and database password storage.

clickhouse-cloud-service-setup

terrylica's avatarfrom terrylica

Fetch ClickHouse Cloud service details from API (organization ID, service endpoints, configuration). Use when setting up new ClickHouse Cloud services, discovering endpoints, or validating service metadata for gapless-crypto-clickhouse project.

gapless-crypto-clickhouse-onboarding

terrylica's avatarfrom terrylica

Onboard company employees (Claude Code CLI users) to use gapless-crypto-clickhouse package with ClickHouse Cloud credentials. Use when company employee needs to set up ClickHouse Cloud access, mentions first-time setup, credential configuration, connection testing, or troubleshooting ClickHouse Cloud connections.

local-clickhouse

terrylica's avatarfrom terrylica

Install, configure, and validate local ClickHouse for gapless-crypto-clickhouse development and backtesting. Use when setting up local development environment, enabling offline mode, improving query performance for backtesting, or running E2E validation. Includes mise/Homebrew/apt installation, mode detection, connection validation, and E2E workflow scripts.

service-monitoring-setup

terrylica's avatarfrom terrylica

Autonomous setup and management of external service monitoring using UptimeRobot (HTTP endpoint monitoring) and Healthchecks.io (heartbeat/Dead Man's Switch monitoring). Use when setting up monitoring for Cloud Run Jobs, VM services, or investigating monitoring configuration issues. Includes Pushover integration, validated API patterns, and dual-service architecture.

bigquery-ethereum-data-acquisition

terrylica's avatarfrom terrylica

Workflow for acquiring historical Ethereum blockchain data using Google BigQuery free tier. Empirically validated for cost estimation, streaming downloads, and DuckDB integration. Use when planning bulk historical data acquisition or comparing data source options for blockchain network metrics.

blockchain-data-collection-validation

terrylica's avatarfrom terrylica

Empirical validation workflow for blockchain data collection pipelines before production implementation. Use when validating data sources, testing DuckDB integration, building POC collectors, or verifying complete fetch-to-storage pipelines for blockchain data.

blockchain-rpc-provider-research

terrylica's avatarfrom terrylica

Systematic workflow for researching and validating blockchain RPC providers. Use when evaluating RPC providers for historical data collection, rate limits, archive access, compute unit costs, or timeline estimation for large-scale blockchain data backfills.

data-pipeline-monitoring

terrylica's avatarfrom terrylica

Monitor and troubleshoot dual-pipeline data collection systems on GCP. This skill should be used when checking pipeline health, viewing logs, diagnosing failures, or monitoring long-running operations for data collection workflows. Supports Cloud Run Jobs (batch pipelines) and VM systemd services (real-time streams).

historical-backfill-execution

terrylica's avatarfrom terrylica

Execute chunked historical blockchain data backfills using canonical 1-year pattern. Use when loading multi-year historical data, filling gaps in ClickHouse, or preventing OOM failures on Cloud Run. Keywords chunked_backfill.sh, BigQuery historical, gap filling, memory-safe backfill.

vm-infrastructure-ops

terrylica's avatarfrom terrylica

Troubleshoot and manage GCP e2-micro VM running eth-realtime-collector. Use when VM service is down, systemd failures occur, real-time data stream stops, or VM network issues arise. Keywords systemd, journalctl, eth-collector, gcloud compute.