2. DevOps & Infrastructure

Enables terminal-based iterative debugging where users run commands and provide output to guide fix suggestions.

Validates ClickHouse Cloud connectivity and configuration using clickhouse-connect, including version checks and query execution.

Automates project setup by designing architecture and configuring GitHub Actions CI pipelines based on requirement specifications.

Configures project structure and CI/CD pipelines based on user requirements.

Securely stores ClickHouse Cloud credentials in Doppler and 1Password for service setup, rotation, and backup of authentication materials.

Installs, configures, and validates local ClickHouse for development and backtesting with package manager support and E2E workflow validation.

Fetches ClickHouse Cloud service details including organization ID, endpoints, and configuration via API for seamless setup and validation.

Analyzes GitHub Actions workflow logs to diagnose CI/CD failures, build issues, and test discrepancies in real-time.

Generates a UTC timestamp by executing a minimal Python script through the shell tool.

Guides employees through initial ClickHouse Cloud setup using gapless-crypto-clickhouse, including credential configuration and connection testing.

Automates CI/CD pipelines by implementing GitHub Actions configuration files in YAML format.

Manages configuration files in user directories using chezmoi, with template handling, conflict resolution, and safe synchronization.

Automates commit creation after successful builds using commit-agent, integrating with CI/CD pipelines for version control.

Enforces pre-PR quality gates including 80% test coverage, passing tests, build success, and semantic versioning to ensure code quality before merging.

Configures home network gateway reverse proxy with Caddy, OAuth2 authentication, fail2ban security, and traffic routing.

Assists in AWS infrastructure research using official documentation and the aws-knowledge-mcp-server for specifications, best practices, and error analysis.

Monitors service health at raspberrypi.local:8000, enabling status checks, service management, and health check configuration.

Manages local network servers (Ubuntu, Raspberry Pi) via SSH, enabling remote command execution, service control, and log monitoring.

Manages deployment, scaling, and monitoring of a photography portfolio backend on fly.io, including logs and status checks.

Quickly identifies and summarizes key project configuration settings including build tools, dependencies, environment variables, and CI/CD pipelines without parsing entire files.

Diagnoses and fixes CI/CD failures from lint and test errors in TypeScript/React projects using ESLint, Prettier, and Vitest.

Guides implementation of Cloudflare R2 object storage, covering bucket configuration, file operations, and Workers integration for S3-compatible storage solutions.

Analyzes projects to generate deployment configuration JSON, detecting language, dependencies, and producing dev/prod runtime commands.

Configures backend Docker environment with Flyway database migrations and MySQL integration testing.