76건 · 관련도순
Design PostgreSQL tables by choosing data types, validation rules, and indexes that match actual queries. The skill also guides JSONB usage, partitioning large tables, and planning schema changes with attention to read and write workloads.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Plan how an AI agent uses limited input space through reusable prompt prefixes, shorter tool outputs, summaries, and task splitting. Measure token use, response quality, and latency to choose optimizations that provide a net benefit.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Investigate slow PostgreSQL and MySQL queries using execution plans, which show how the database runs a query. Develop index, SQL, and configuration changes, then compare measurements before and after each change to validate the results.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Estimate GPU memory, training step time, checkpoint costs, and recovery overhead for training or reinforcement learning. Compare state partitioning, recomputation, offloading, and device counts to assess whether a job can finish within its deadline.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Investigate slow PostgreSQL and MySQL queries using execution plans, which show how queries run, and performance measurements. Develop index changes, SQL rewrites, and configuration adjustments, then validate their effects with measurements and monitoring.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Master the four operations of context engineering — Write, Select, Compress, Isolate. Manage token budgets, compaction strategies, and context partitioning to keep AI sessions sharp and efficient.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search, hybrid search, or BM25 ranking - Use PostGIS for spatial/geographic data - Set up TimescaleDB hypertables for time-series data - Migrate tables to hypertables or evaluate migration candidates - Plan or execute safe schema migrations with zero downtime **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Three.js scene-graph parsing and export workflows: mesh baking, InstancedMesh expansion, part partitioning, per-link OBJ export, and URDF articulation.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Optimize workload distribution across workers, processes, or nodes for efficient parallel execution. Use when asked to balance work distribution, improve parallel efficiency, reduce stragglers, implement load balancing, or optimize task scheduling. Covers static/dynamic partitioning, work stealing, and adaptive load balancing strategies.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Use when reviewing a DataFusion Comet pull request that touches native or JVM columnar shuffle, the shuffle writers and readers, partitioning, the Arrow IPC block format, shuffle compression, or the Celeborn integration. Load alongside review-comet-pr.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Use when partitioning content between an Advanced Materials main text and its Supporting Information, ensuring the paper stands alone while extended data, full experimental detail, and secondary characterization live in the SI. Organizes the Supporting Information; does not write the main text.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Quantifies biodiversity from species abundance/incidence tables using Hill numbers (iNEXT) with coverage-based rarefaction-extrapolation (Chao & Jost 2012), asymptotic richness via Chao1/ACE/jackknife as a lower bound, Baselga turnover/nestedness partition with the Podani alternative as sensitivity check, mandatory Hellinger transformation before ordination (Legendre & Gallagher 2001), Faith PD and SES_MPD/SES_MNTD with explicit null-model choice, and Maire 2015 functional-diversity dimensionality optimization. Use when comparing diversity across sites with unequal sampling effort, picking the right richness estimator for singleton-heavy amplicon data, partitioning beta diversity into turnover vs nestedness, reporting Hill-number effective species counts rather than raw entropies, computing SES_MPD with explicit null-model justification, or deciding whether to apply standard metrics to compositional amplicon data. Not for clinical 16S microbiome diversity (see microbiome/diversity-analysis).
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Set up and manage NVIDIA GPU servers for AI workloads — driver installation, CUDA toolkit, container toolkit, MIG partitioning, GPU health monitoring, and multi-GPU configuration for LLM inference and training.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Operate GPU-backed Kubernetes clusters for AI inference and training with scheduling, autoscaling, node health, MIG partitioning, and cost controls.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Optimizes database queries and improves performance across PostgreSQL and MySQL systems including index design, query rewrites, configuration tuning, and partitioning strategies.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Expert knowledge for Azure Service Bus development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using queues/topics with sessions, partitioning, autoforwarding, JMS/AMQP integrations, or geo-disaster recovery, and other Azure Service Bus related development tasks. Not for Azure Event Hubs (use azure-event-hubs), Azure Relay (use azure-relay), Azure Queue Storage (use azure-queue-storage), Azure Notification Hubs (use azure-notification-hubs).
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
When designing distributed systems for scalability, reliability, and consistency. Covers CAP/PACELC theorems, consistency models (strong, eventual, causal), replication patterns (leader-follower, multi-leader, leaderless), partitioning strategies (hash, range, geographic), transaction patterns (saga, event sourcing, CQRS), resilience patterns (circuit breaker, bulkhead), service discovery, and caching strategies for building fault-tolerant distributed architectures.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Compute the bacterial pan-genome from Prokka/Bakta GFF3 annotations with Roary's CD-HIT + BLAST + MCL clustering pipeline. Builds gene presence/absence matrices, core/soft-core/shell/cloud partitions, multi-FASTA core gene alignments (with `-e`), and a pan-genome reference. Use Panaroo for higher-accuracy pan-genomes from highly fragmented assemblies, PIRATE for paralog-aware clustering, or PPanGGOLiN for graph-based partitioning.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Applies data-grid architecture for high-traffic stateful workloads. Use when a single database cannot scale and in-memory partitioning is needed.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Think and work like an expert Horticulturist. Use when a task calls for Horticulturist judgment. Reasons from plant-environment-cultural coupling, source-sink carbon partitioning, and chilling/photoperiod thresholds through rootstock-scion matching, DLI/VPD and substrate EC/pH targets, Dynamic/Utah chill models, and CA/MA postharvest setpoints while treating blossom-end rot, bitter pit, tipburn, storage scald, and MRL/PHI breaches as first-class failure modes.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
Think and work like an expert Geodynamics & Tectonics Scientist. Use when a task calls for Geodynamics & Tectonics Scientist judgment. Reasons from plate kinematics, lithospheric rheology, and interseismic-versus-coseismic strain partitioning through GAMIT/GLOBK and MintPy geodesy, Okada/viscoelastic slip inversion, OxCal paleoseismic chronologies, ASPECT mantle modeling, and OpenQuake/USGS NSHM hazard while treating InSAR atmospheric delay, monument instability, unmodeled postseismic afterslip, and incompatible-timescale rate stacking as first-class failure modes.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.