Performance & cost
7,008 rows, by stacks then stars
853 of these skill files have been read, by 797 distinct authors, and what they tell an agent counted. What Performance & cost authors agree on, and what they forbid
ulpi-io/plugin-marketplace/plugins/sickn33/skills/network-engineer Skill
no license1★ repoExpert network engineer specializing in modern cloud networking, security architectures, and performance optimization.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/page-cro Skill
no license1★ repoWhen the user wants to optimize, improve, or increase conversions on any marketing page — including homepage, landing pages, pricing pages, feature pages, or blog posts. Also use when the user says "CRO," "conversion rate optimization," "this page isn't converting," "improve conversions," "why isn't this page working," "my landing page sucks," "nobody's converting," "low conversion rate," "bounce rate is too high," "people leave without signing up," or "this page needs work." Use this even if the user just shares a URL and asks for feedback — they probably want conversion help. For signup/registration flows, see signup-flow-cro. For post-signup activation, see onboarding-cro. For forms outside of signup, see form-cro. For popups/modals, see popup-cro.
The same file is in 5 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/performance-engineer Skill
no license1★ repoExpert performance engineer specializing in modern observability,
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/performance-profiling Skill
no license1★ repoPerformance profiling principles. Measurement, analysis, and optimization techniques.
The same file is in 5 other repositories
Performance testing review ai review
ulpi-io/plugin-marketplace/plugins/sickn33/skills/performance-testing-review-ai-review Skill
no license1★ repoYou are an expert AI-powered code review specialist combining automated static analysis, intelligent pattern recognition, and modern DevOps practices. Leverage AI tools (GitHub Copilot, Qodo, GPT-5, C
The same file is in 2 other repositories
Performance testing review multi agent review
ulpi-io/plugin-marketplace/plugins/sickn33/skills/performance-testing-review-multi-agent-review Skill
no license1★ repoUse when working with performance testing review multi agent review
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/popup-cro Skill
no license1★ repoWhen the user wants to create or optimize popups, modals, overlays, slide-ins, or banners for conversion purposes. Also use when the user mentions "exit intent," "popup conversions," "modal optimization," "lead capture popup," "email popup," "announcement banner," "overlay," "collect emails with a popup," "exit popup," "scroll trigger," "sticky bar," or "notification bar." Use this for any overlay or interrupt-style conversion element. For forms outside of popups, see form-cro. For general page conversion optimization, see page-cro.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/prisma-expert Skill
no license1★ repoPrisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, re...
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/prompt-caching Skill
no license1★ repoCaching strategies for LLM prompts including Anthropic prompt caching, response caching, and CAG (Cache Augmented Generation) Use when: prompt caching, cache prompt, response cache, cag, cache augm...
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/prompt-engineer Skill
no license1★ repoWrites, refactors, and evaluates prompts for LLMs — generating optimized prompt templates, structured output schemas, evaluation rubrics, and test suites. Use when designing prompts for new LLM applications, refactoring existing prompts for better accuracy or token efficiency, implementing chain-of-thought or few-shot learning, creating system prompts with personas and guardrails, building JSON/function-calling schemas, or developing prompt evaluation frameworks to measure and improve model performance.
Python performance optimization
ulpi-io/plugin-marketplace/plugins/sickn33/skills/python-performance-optimization Skill
no license1★ repoProfile and optimize Python code using cProfile, memory profilers, and performance best practices. Use when debugging slow Python code, optimizing bottlenecks, or improving application performance.
ulpi-io/plugin-marketplace/plugins/sickn33/skills/react-best-practices Skill
no license1★ repoReact and Next.js performance optimization guidelines from Vercel Engineering. Use when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
ulpi-io/plugin-marketplace/plugins/sickn33/skills/react-patterns Skill
no license1★ repoProvides comprehensive React 19 patterns covering Server Components, Actions, use() hook, useOptimistic, useFormStatus, useFormState, React Compiler, concurrent features, Suspense, and modern TypeScript development. Proactively use for any React development, component architecture, state management, performance optimization, or when implementing React 19's latest features.
ulpi-io/plugin-marketplace/plugins/sickn33/skills/research-engineer Skill
no license1★ repoExpert network engineer specializing in modern cloud networking, security architectures, and performance optimization.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/ruby-pro Skill
no license1★ repoWrite idiomatic Ruby code with metaprogramming, Rails patterns, and performance optimization. Specializes in Ruby on Rails, gem development, and testing frameworks.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/schema-markup Skill
no license1★ repoWhen the user wants to add, fix, or optimize schema markup and structured data on their site. Also use when the user mentions "schema markup," "structured data," "JSON-LD," "rich snippets," "schema.org," "FAQ schema," "product schema," "review schema," "breadcrumb schema," "Google rich results," "knowledge panel," "star ratings in search," or "add structured data." Use this whenever someone wants their pages to show enhanced results in Google. For broader SEO issues, see seo-audit. For AI search optimization, see ai-seo.
The same file is in 3 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/signup-flow-cro Skill
no license1★ repoWhen the user wants to optimize signup, registration, account creation, or trial activation flows. Also use when the user mentions "signup conversions," "registration friction," "signup form optimization," "free trial signup," "reduce signup dropoff," "account creation flow," "people aren't signing up," "signup abandonment," "trial conversion rate," "nobody completes registration," "too many steps to sign up," or "simplify our signup." Use this whenever the user has a signup or registration flow that isn't performing. For post-signup onboarding, see onboarding-cro. For lead capture forms (not account creation), see form-cro.
The same file is in 4 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/skill-creator Skill
no license1★ repoCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
The same file is in 66 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/spark-optimization Skill
no license1★ repoOptimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/sickn33/skills/sql-optimization-patterns Skill
no license1★ repoMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
The same file is in 1 other repository
Supabase postgres best practices
ulpi-io/plugin-marketplace/plugins/sickn33/skills/supabase-postgres-best-practices Skill
no license1★ repoPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
The same file is in 8 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/turborepo-caching Skill
no license1★ repoConfigure Turborepo for efficient monorepo builds with local and remote caching. Use when setting up Turborepo, optimizing build pipelines, or implementing distributed caching.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/typescript-expert Skill
no license1★ repoTypeScript and JavaScript expert with deep knowledge of type-level programming, performance optimization, monorepo management, migration strategies, and modern tooling.
The same file is in 3 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/vector-index-tuning Skill
no license1★ repoOptimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/vercel-react-best-practices Skill
no license1★ repoReact and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/web-performance-optimization Skill
no license1★ repoOptimize website and web application performance including loading speed, Core Web Vitals, bundle size, caching strategies, and runtime performance
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/sickn33/skills/wordpress penetration testing Skill
no license1★ repoComplete WordPress development workflow covering theme development, plugin creation, WooCommerce integration, performance optimization, and security hardening.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/softaworks/skills/database-schema-designer Skill
no license1★ repoDesign robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
The same file is in 7 other repositories
ulpi-io/plugin-marketplace/plugins/steipete/skills/skill-creator Skill
no license1★ repoCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
The same file is in 66 other repositories
ulpi-io/plugin-marketplace/plugins/supabase/skills/skill-creator Skill
no license1★ repoCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
The same file is in 66 other repositories
Supabase postgres best practices
ulpi-io/plugin-marketplace/plugins/supabase/skills/supabase-postgres-best-practices Skill
no license1★ repoPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
The same file is in 8 other repositories
ulpi-io/plugin-marketplace/plugins/supercent-io/skills/database-schema-design Skill
no license1★ repoDesign and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQL, MongoDB, normalization, and performance optimization.
The same file is in 4 other repositories
ulpi-io/plugin-marketplace/plugins/supercent-io/skills/performance-optimization Skill
no license1★ repoOptimize application performance for speed, efficiency, and scalability. Use when improving page load times, reducing bundle size, optimizing database queries, or fixing performance bottlenecks. Handles React optimization, lazy loading, caching, code splitting, and profiling.
The same file is in 5 other repositories
ulpi-io/plugin-marketplace/plugins/supercent-io/skills/react-best-practices Skill
no license1★ repoReact and Next.js performance optimization guidelines from Vercel Engineering. Use when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
ulpi-io/plugin-marketplace/plugins/supercent-io/skills/vercel-react-best-practices Skill
no license1★ repoReact and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/trailofbits/skills/yara-rule-authoring Skill
no license1★ repoGuides authoring of high-quality YARA-X detection rules for malware identification. Use when writing, reviewing, or optimizing YARA rules. Covers naming conventions, string selection, performance optimization, migration from legacy YARA, and false positive reduction. Triggers on: YARA, YARA-X, malware detection, threat hunting, IOC, signature, crx module, dex module.
The same file is in 3 other repositories
ulpi-io/plugin-marketplace/plugins/vercel-labs/skills/skill-creator Skill
no license1★ repoCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
The same file is in 66 other repositories
ulpi-io/plugin-marketplace/plugins/vercel-labs/skills/vercel-react-best-practices Skill
no license1★ repoReact and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/wshobson/skills/bazel-build-optimization Skill
no license1★ repoOptimize Bazel builds for large-scale monorepos. Use when configuring Bazel, implementing remote execution, or optimizing build performance for enterprise codebases.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/wshobson/skills/cost-optimization Skill
no license1★ repoOptimize cloud costs through resource rightsizing, tagging strategies, reserved instances, and spending analysis. Use when reducing cloud expenses, analyzing infrastructure costs, or implementing cost governance policies.
Python performance optimization
ulpi-io/plugin-marketplace/plugins/wshobson/skills/python-performance-optimization Skill
no license1★ repoProfile and optimize Python code using cProfile, memory profilers, and performance best practices. Use when debugging slow Python code, optimizing bottlenecks, or improving application performance.
ulpi-io/plugin-marketplace/plugins/wshobson/skills/spark-optimization Skill
no license1★ repoOptimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/wshobson/skills/sql-optimization-patterns Skill
no license1★ repoMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
The same file is in 1 other repository
ulpi-io/plugin-marketplace/plugins/wshobson/skills/vector-index-tuning Skill
no license1★ repoOptimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.
The same file is in 2 other repositories
ulpi-io/plugin-marketplace/plugins/zhanghandong/skills/m10-performance Skill
no license1★ repoCRITICAL: Use for performance optimization. Triggers: performance, optimization, benchmark, profiling, flamegraph, criterion, slow, fast, allocation, cache, SIMD, make it faster, 性能优化, 基准测试
The same file is in 1 other repository
qyinm/agent-skills-archive/skills/experiment-loop Skill
no license1★ repoAutonomous optimization loop. Modifies code, measures a target metric, keeps improvements, and reverts regressions. Use for API latency, OCR time, bundle size, query speed, or any measurable optimization task.
Load testing backend from mobile perspective
almasumdev/awesome-mobile-testing-agent-skills/.github/skills/performance/load-testing-backend-from-mobile-perspective Skill
no license1★ repoExpert guidance on stress-testing backends from a mobile client's point of view — throttled networks, realistic request patterns, and client-side behavior under load. Use when asked how the app behaves on bad networks or under backend slowdowns.
Performance regression testing
almasumdev/awesome-mobile-testing-agent-skills/.github/skills/performance/performance-regression-testing Skill
no license1★ repoExpert guidance on detecting mobile performance regressions — startup time, frame jank, scroll performance, binary size — with baselines and noise-aware thresholds. Use when setting up perf gates in CI or when a release is suspected of regressing.
Image optimization pipeline config
jacob-balslev/skill-graph/examples/projects/markdown-static-site/skills/image-optimization-pipeline-config Skill
no license1★ repoUse when authoring or reviewing the build-time image pipeline config — defining responsive srcset breakpoints, picking output formats (AVIF / WebP / JPEG fallback), tuning compression quality per format, and ensuring the pipeline never produces a lossy artifact for source PNGs with transparency. Activate this skill whenever the task touches `lib/images/pipeline.config.ts`, `scripts/build-images.ts`, or any code path that resizes or recompresses content images. Do NOT use for runtime image rendering choices (use a frontend skill) or for chasing a specific build failure (use debugging).
jacob-balslev/skill-graph/marketplace/skills/compression Skill
no license1★ repoThis skill provides expertise in data and context compression: SaaS payload optimization (Zstd, Brotli, Gzip), database storage compression, and AI context window compression (Semantic Summarization, Token Pruning). Use when optimizing API latency, reducing storage costs, or managing long-running agent sessions near context limits. Do NOT use for image/video lossy compression (use product-photo) or file archiving.
jacob-balslev/skill-graph/marketplace/skills/connection-pooling Skill
no license1★ repoUse when reasoning about how an application manages its database connections: why every connection has a server-side cost, the difference between application-level pools (HikariCP, pgx pool, node-postgres Pool) and proxy-level pools (PgBouncer, Pgpool, ProxySQL), the three PgBouncer modes (session, transaction, statement) and their feature compatibility, the canonical pool-sizing math (Little's Law applied to database concurrency; Wooldridge's analyses), the failure modes (connection exhaustion, hot-loop reconnects, prepared-statement breakage under transaction pooling, idle-in-transaction leaks), and the diagnostic procedure when a workload is contending on connections instead of query work. Do NOT use for query-level performance (use query-optimization), for index design (use indexing-strategy), for read/write replica routing (use replication-patterns), or for cross-shard query coordination (use sharding-strategy). Do NOT use for choose the transaction isolation level for concurrent account transfers.
jacob-balslev/skill-graph/marketplace/skills/framework-fit-analysis Skill
no license1★ repoUse when choosing, replacing, or justifying a framework, library, SDK, runtime, database, UI kit, agent tool, or platform by fit: constraints, quality attributes, team skill, evidence, ecosystem maturity, maintenance health, migration cost, operability, performance, security, supply-chain posture, AI/codegen readiness, lock-in, reversibility, and exit cost. Do NOT use for routine dependency hygiene (use `dependency-architecture`), documenting an accepted decision (use `architecture-decision-records`), or framework-specific implementation work. Do NOT use for audit installed packages for duplication and supply-chain risk. Do NOT use for write the ADR after we chose the framework. Do NOT use for implement this feature in the framework we already selected. Do NOT use for profile a slow page and optimize bottlenecks. Do NOT use for design the full production lifecycle of a multi-agent system after the platform is chosen.
jacob-balslev/skill-graph/marketplace/skills/interaction-feedback Skill
no license1★ repoUse when designing UI feedback around user actions and system state: loading, skeletons, optimistic updates, progress, success, errors, empty states, retries, disabled/pending states, autosave, undo, and perceived latency. Do NOT use for the words inside feedback (use `microcopy`), accessibility announcement mechanics (use `a11y`), business lifecycle modeling (use `state-machine-modeling`), or performance optimization (use `performance-engineering`). Do NOT use for rewrite the toast and validation text. Do NOT use for make sure the status update is announced to screen readers. Do NOT use for model the order lifecycle and legal transitions. Do NOT use for profile the endpoint that makes this action slow. Do NOT use for the words inside feedback states (use microcopy).
jacob-balslev/skill-graph/marketplace/skills/observability-modeling Skill
no license1★ repoUse when designing telemetry semantics before or during implementation: logs, metrics, traces, events, spans, attributes, correlation IDs, SLOs, alert signals, and diagnostic questions. Do NOT use for domain/business event contracts (use `event-contract-design`), configuring an error tracker alone (use `error-tracking`), performance optimization (use `performance-engineering`), or debugging a current incident (use `debugging`). Do NOT use for set up Sentry error tracking for this app. Do NOT use for profile and optimize a slow endpoint. Do NOT use for debug the current production incident. Do NOT use for write application tests for this feature.
jacob-balslev/skill-graph/marketplace/skills/performance-budgets Skill
no license1★ repoUse when declaring, measuring, or enforcing performance thresholds as a quality contract rather than as an aspirational target. Covers the three budget axes (time, size, count), the four governing properties of a real budget (metric, threshold, percentile, consequence), the Core Web Vitals set (LCP, INP, CLS), the RAIL model, Lighthouse budgets.json, lab vs field measurement, and the discipline of treating budget breach as a build or deploy failure rather than a tracked metric. Do NOT use for the activity of profiling and optimizing a specific slow path (use performance-engineering), the choice of rendering model that bounds achievable budgets (use rendering-models), or the design of observability and telemetry signals (use observability-modeling).
jacob-balslev/skill-graph/marketplace/skills/performance-engineering Skill
no license1★ repoUse when measuring, diagnosing, budgeting, or improving performance: latency, throughput, Core Web Vitals, database queries, caching, bundle size, concurrency, resource use, and regression prevention. Do NOT use for telemetry schema design alone (use `observability-modeling`), error capture setup (use `error-tracking`), or premature micro-optimization without a measured bottleneck. Do NOT use for design logs, spans, metrics, and correlation IDs before implementation. Do NOT use for set up Sentry and error redaction. Do NOT use for make random micro-optimizations without measurements. Do NOT use for write general unit tests for this feature.
jacob-balslev/skill-graph/marketplace/skills/performance-testing Skill
no license1★ repoUse when measuring a system's non-functional properties — latency, throughput, error rate, resource utilization, saturation — by running it under controlled load and verifying against explicit SLO thresholds. Covers the five primitives (load profile, workload, latency metric, throughput metric, SLO target), load-shape taxonomy (smoke, load, stress, spike, soak, breakpoint), latency-percentile vocabulary (p50, p95, p99, p99.9), why average latency and coordinated omission mislead, tool selection (k6, JMeter, Locust, Gatling, Vegeta), and offline controlled measurement versus production observability. Do NOT use for optimization itself (use `performance-engineering`), threshold contracts (use `performance-budgets`), production runtime measurement (use `observability-modeling` or `error-tracking`), single-function microbenchmarks, fault injection, or test-suite quality measurement (use `mutation-testing`). Do NOT use for decide which modules need more unit tests and what test coverage target to enforce.
jacob-balslev/skill-graph/marketplace/skills/problem-locating-solving Skill
no license1★ repoUse when locating a bug in an unfamiliar codebase, tracing a failure from symptom to source, or choosing between candidate fixes after the symptom is observed but before a patch lands. Covers the locate-to-solve workflow: problem-statement contract, search-space reduction, boundary-based fault localization, good-vs-bad path comparison, binary search through a call chain, minimal repro, root-cause isolation, fix option comparison, blast-radius review, and post-fix verification. Do NOT use for broad task planning once the bug is localized, test-pyramid design, or performance forensics. Do NOT use for plan the next 6 weeks of work for the team. Do NOT use for review this PR for code quality. Do NOT use for this endpoint is slow under load — find the bottleneck. Do NOT use for scan this repo for OWASP top 10 vulnerabilities. Do NOT use for run scientific-method debugging on this stack trace. Do NOT use for I see the symptom but cannot find the root cause of this nil panic.
jacob-balslev/skill-graph/marketplace/skills/query-optimization Skill
no license1★ repoDiagnosing and tuning a specific slow relational-database query from plan evidence: workload impact, exact query context, EXPLAIN / actual execution plans, row-estimate accuracy, access path choice, join order, sort/hash spills, JIT/planning overhead, parameter-sensitive plans, plan regressions, statistics, and rewrite-vs-index-vs-operational response selection. Start from the actual plan and runtime evidence, not from the reflex to add an index; modern engine features such as Query Store, PSP/OPPO, SQL Plan Management, pg_stat_statements, auto_explain, MySQL histograms, Oracle DBMS_XPLAN, and PostgreSQL planner improvements are evidence sources and response tools, not replacements for diagnosis. Do NOT use for designing the durable index portfolio (use indexing-strategy), schema design (use entity-relationship-modeling), distributed partitioning (use sharding-strategy), isolation-level correctness (use transaction-isolation), or whole-system load testing (use performance-testing).
jacob-balslev/skill-graph/marketplace/skills/sharding-strategy Skill
no license1★ repoUse when reasoning about horizontal partitioning of data across nodes for storage capacity and write throughput beyond a single node: the three foundational partitioning schemes (range, hash, directory/lookup), the shard-key choice that determines whether the system scales or hotspots, the resharding problem and how consistent hashing addresses it, cross-shard queries and the joins-and-transactions trade-off, the relationship to replication (sharding partitions data; replication copies each shard), and the failure modes (hot shard, skewed distribution, cross-shard transactions, range-end overload). Do NOT use for replicating the same data across nodes (use replication-patterns), the CAP/PACELC frame (use cap-theorem-tradeoffs), single-node performance tuning (use query-optimization), or indexing within a shard (use indexing-strategy).