vm-infrastructure-ops
Troubleshoot and manage the GCP e2-micro VM running the eth-realtime-collector. Handle systemd failures, network connectivity issues, and real-time data stream monitoring for Ethereum network data.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
141 skills found
Troubleshoot and manage the GCP e2-micro VM running the eth-realtime-collector. Handle systemd failures, network connectivity issues, and real-time data stream monitoring for Ethereum network data.
High-performance in-memory DataFrame library for Python and Rust. Features lazy evaluation, parallel execution, and an Apache Arrow backend for efficient ETL, data processing, and faster pandas alternatives.
Executes SQL queries against the WordPress development database for inspection, troubleshooting, and audit log analysis.
Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.
Build read models and projections from event streams for CQRS, materialized views, and optimized query performance in event-sourced systems.
Generate optimized SQL queries from natural language. Supports BigQuery, PostgreSQL, MySQL, and Snowflake. Analyze database schemas, interpret business requirements, and output ready-to-run queries with explanations.
Expert SQL agent for modern database systems, query optimization, HTAP environments, and data architecture patterns. Optimize performance, schema design, and analytical workloads effectively.
Writes, executes, and refines SQL queries, from basic selects to complex multi-table joins, aggregations, and subqueries for data retrieval and reporting.
Load, validate, and preprocess weekly insurance policy CSV data with intelligent period detection and standardization.
Search, analyze, and audit GeminiClaw session logs and memory. Use to investigate past interactions, track token usage, debug tool calls, and monitor agent performance.
Read and analyze any data file (CSV, JSON, Parquet, Avro, Excel, etc.) or remote URL (S3, HTTPS) using DuckDB. Automatically detect file formats and preview/profile datasets.
Specialized data engineering agent for designing ETL/ELT pipelines, defining data schemas, managing data quality, and implementing robust ingestion workflows.