Skills

Writes safe, reversible database schema migrations and the corresponding rollback scripts. Plans zero-downtime changes using expand-and-contract patterns, handles data backfills and index creation without locking, and generates migrations for tools like Alembic, Flyway, Prisma, Knex, and Rails ActiveRecord with clear up/down steps.

Generates mock API servers and stubbed responses from OpenAPI specs, sample payloads, or natural-language descriptions. Produces realistic fixture data, configurable latency and error scenarios, and ready-to-run mock servers using tools like Prism, MSW, WireMock, or json-server so frontend and integration tests can proceed without the real backend.

Assists with internationalization (i18n) and localization (l10n) of applications and content. Extracts translatable strings, generates resource bundles, translates copy while preserving placeholders and ICU plural/gender rules, and flags layout, date, number, and currency formatting concerns for target locales.

Optimizes web content for search engines and readers. Performs keyword analysis and intent mapping, improves titles, meta descriptions, headings, and internal linking, and generates structured data (JSON-LD) while keeping copy natural and useful. Outputs an actionable, prioritized list of on-page SEO improvements.

Designs GraphQL schemas from domain descriptions or existing data models. Produces typed SDL with queries, mutations, subscriptions, input types, enums, and interfaces, following naming conventions, pagination patterns (Relay-style connections), and error-handling best practices. Can also generate resolvers scaffolding and map schemas to existing REST or SQL backends.

Generates production-ready Kubernetes manifests — Deployments, Services, Ingresses, ConfigMaps, Secrets, HPAs, and more — from a plain-language description of the workload. Applies best practices for resource limits, health probes, security contexts, and rolling update strategies, with optional Kustomize overlays or Helm chart scaffolding.

Parses and analyzes application, system, and access logs to surface errors, anomalies, and root causes. Correlates events across services, identifies recurring patterns and spikes, extracts structured fields from unstructured lines, and produces a prioritized summary with likely causes and recommended next steps.

Extracts structured data from PDFs and scanned documents — invoices, receipts, forms, contracts, reports, and tables. Returns clean, typed output (JSON, CSV, or Markdown tables), handles multi-page layouts and nested tables, and flags low-confidence fields for review. Uses vision-capable models for image-based and scanned PDFs.

Generates and assists with incident response procedures for production systems. Helps with root cause analysis, creates runbooks for common failure modes, builds communication templates for stakeholders, and produces post-incident review documents. Supports SRE and on-call workflows.

Generates comprehensive load testing scripts and configurations for APIs. Supports k6, Locust, Artillery, and JMeter formats. Creates realistic traffic patterns, ramp-up scenarios, and threshold definitions. Includes analysis templates for identifying bottlenecks and capacity planning.

Generates mobile application prototypes and implementations for iOS and Android. Creates SwiftUI views, Jetpack Compose layouts, and React Native components from descriptions or wireframe images. Handles navigation patterns, state management, and platform-specific design guidelines.

Transcribes audio recordings into structured text with speaker diarization, timestamps, and formatting. Supports meeting recordings, interviews, podcasts, and lectures. Handles multiple languages and accents with automatic language detection and optional translation.

Crafts App Store metadata — title, subtitle, keyword field, and description — that maximizes both search visibility and conversion rate. Applies platform-specific character limits and indexing rules for iOS and Android, provides multiple copy variants per field, and outputs a keyword coverage matrix with before/after comparison.

Discovers, evaluates, and prioritizes App Store keywords for mobile apps. Expands seed keywords using autocomplete suggestions, competitor rankings, and category analysis, then scores each keyword by volume, difficulty, and relevance to build a prioritized keyword strategy with primary, secondary, long-tail, and aspirational buckets.

Analyzes complex networks and graphs using NetworkX, igraph, and PyTorch Geometric. Supports social network analysis, biological interaction networks, knowledge graphs, and citation networks. Performs community detection, centrality analysis, link prediction, graph neural networks, and network visualization with force-directed layouts.

Sets up and manages machine learning experiment tracking, hyperparameter optimization, and model registry workflows. Integrates with MLflow, Weights & Biases, and Optuna for systematic experimentation. Handles metric logging, artifact storage, model versioning, reproducibility, and automated hyperparameter search with early stopping.

Performs geospatial data analysis, mapping, and spatial statistics using GeoPandas, Shapely, Rasterio, and Folium. Supports vector and raster operations, coordinate transformations, spatial joins, buffer analysis, satellite imagery processing, choropleth mapping, and route optimization for GIS and remote sensing workflows.

Builds and evaluates time series forecasting models using statistical and ML approaches. Supports ARIMA, Prophet, LSTM, Transformer-based models, and foundation models like TimesFM. Handles seasonality detection, trend decomposition, anomaly detection, multi-step forecasting, and backtesting with proper train/test splits for financial, IoT, and scientific time series data.

Creates publication-quality scientific figures and plots using matplotlib, seaborn, and plotly. Supports common scientific plot types including heatmaps, volcano plots, survival curves, network graphs, phylogenetic trees, and multi-panel figures with proper statistical annotations, color-blind safe palettes, and journal formatting.

Designs and implements A/B testing experiments including hypothesis formulation, sample size calculation, variant configuration, metric definition, and statistical analysis planning. Covers both frontend feature flags and backend experiment frameworks.

Interacts with GitHub via the gh CLI for managing issues, pull requests, CI runs, releases, and repository settings. Automates common GitHub workflows including PR creation with proper descriptions, issue triage, release drafting, and CI debugging.