Agent Skills 排行榜 · 关键词 + 语义搜索

/ 聚焦搜索框
正在使用 AI 进行语义搜索...
21,286
总 Skills
33.7M
总安装量
2,437
贡献者
# Skill 仓库 描述 安装量
15551 health-check laurigates/claude-plugins
/health:check Run a comprehensive diagnostic scan of your Claude Code environment. Identifies issues with plugin registry, settings files, hooks configuration, and MCP servers. When to Use This Skill Use this skill when... Use another approach when... Running comprehensive Claude Code diagnostics Checking specific component only (use /health:plugins , /health:settings ) Troubleshooting general Claude Code issues Plugin registry issues only (use /health:plugins --fix ) Validating environment conf...
53
15552 python-packaging laurigates/claude-plugins
Python Packaging Comprehensive guide to creating, structuring, and distributing Python packages using modern packaging tools, pyproject.toml, and publishing to PyPI. When to Use This Skill Creating Python libraries for distribution Building command-line tools with entry points Publishing packages to PyPI or private repositories Setting up Python project structure Creating installable packages with dependencies Building wheels and source distributions Versioning and releasing Python packages Crea...
53
15553 upgrade-cairo-contracts openzeppelin/openzeppelin-skills
Cairo Upgrades Contents Starknet Upgrade Model Using the OpenZeppelin Upgradeable Component Access Control Upgrade Safety Starknet Upgrade Model Starknet separates contract instances from contract classes . A class is the compiled program (identified by its class hash); a contract is a deployed instance pointing to a class. Multiple contracts can share the same class. Upgrading a contract means replacing its class hash so it points to a new class. The contract keeps its address, storage, and non...
53
15554 motion-one dylantarre/animation-principles
Motion One Animation Principles Implement all 12 Disney animation principles using Motion One's performant Web Animations API wrapper. 1. Squash and Stretch import { animate } from "motion"; animate(".ball", { scaleX: [1, 1.2, 1], scaleY: [1, 0.8, 1] }, { duration: 0.3, easing: "ease-in-out" } ); 2. Anticipation import { timeline } from "motion"; timeline([ [".character", { y: 10, scaleY: 0.9 }, { duration: 0.2 }], [".character", { y: -200 }, { duration: 0.4, easing: "ease-out" }] ]...
53
15555 prometheus-go-code-review existential-birds/beagle
Prometheus Go Code Review Review Checklist Metric types match measurement semantics (Counter/Gauge/Histogram) Labels have low cardinality (no user IDs, timestamps, paths) Metric names follow conventions (snake_case, unit suffix) Histograms use appropriate bucket boundaries Metrics registered once, not per-request Collectors don't panic on race conditions /metrics endpoint exposed and accessible Metric Type Selection Measurement Type Example Requests processed Counter requests_total Items ...
53
15556 ln-821-npm-upgrader levnikolaevich/claude-code-skills
Paths: File paths ( shared/ , references/ , ../ln-* ) are relative to skills repo root. If not found at CWD, locate this SKILL.md directory and go up one level for repo root. ln-821-npm-upgrader Type: L3 Worker Category: 8XX Optimization Parent: ln-820-dependency-optimization-coordinator Upgrades Node.js dependencies using npm, yarn, or pnpm with automatic breaking change detection and migration. Overview Aspect Details Input Project path, package manager type Output Updated package.json, lock f...
53
15557 compact catlog22/claude-code-workflow
Memory Compact Command (/memory:compact) 1. Overview The memory:compact command compresses current session working memory into structured text optimized for session recovery , extracts critical information, and saves it to persistent storage via MCP core_memory tool. Core Philosophy : Session Recovery First : Capture everything needed to resume work seamlessly Minimize Re-exploration : Include file paths, decisions, and state to avoid redundant analysis Preserve Train of Thought : Keep notes and...
53
15558 chrome-ext pproenca/dot-skills
Chrome Developer Relations Chrome Extensions Best Practices Comprehensive performance optimization guide for Chrome Extensions (Manifest V3), maintained by Chrome Developer Relations. Contains 40+ rules across 8 categories, prioritized by impact to guide automated refactoring and code generation. When to Apply Reference these guidelines when: Writing new Chrome extension code Migrating from Manifest V2 to Manifest V3 Optimizing service worker lifecycle and state management Implementing conte...
53
15559 inertia-rails-setup inertia-rails/skills
Inertia Rails Project Setup Detect stack, offer recommended deps, generate CLAUDE.md configuration. Run once per project. Re-run when the stack changes. NEVER: Run setup without inertia_rails gem in Gemfile — all skills assume it exists. If missing, tell the user to install it first. Overwrite existing Inertia Rails Stack in CLAUDE.md without reading it — the user may have manual customizations. Replace only the auto-generated block. Add @/ resolve aliases to vite.config.ts — vite-plugin-ruby a...
53
15560 asyncreview asyncfuncai/asyncreview
AsyncReview CLI When to use this skill Use this skill when the user: Asks to review a GitHub pull request Wants AI feedback on code changes in a PR Needs to check if a PR breaks existing functionality Asks questions about a GitHub issue or PR Wants to verify if something was missed in a code change How to use this skill Check prerequisites — Verify GEMINI_API_KEY is set Check if repo is private — Use gh repo view to determine if GITHUB_TOKEN is required Set GITHUB_TOKEN if needed — Use gh auth t...
53
15561 copywriting cyrwheelninja/copywriting-skill
Copywriting You are an expert conversion copywriter. Your goal is to write marketing copy that is clear, compelling, and drives action. Before Writing Check for product marketing context first: If .agents/product-marketing-context.md exists (or .claude/product-marketing-context.md in older setups), read it before asking questions. Use that context and only ask for information not already covered or specific to this task. Gather this context (ask if not provided): 1. Page Purpose What type of pag...
53
15562 dust-test dust-tt/dust
Creating automated tests for Dust codebases Write focused, practical tests for the current file following the 80/20 principle. Instructions When writing tests for a file: Identify the core functionality : Focus on the most important paths and edge cases that provide 80% of the value Keep it simple : Write straightforward tests that are easy to understand and maintain Minimal mocking : DO NOT mock the database Only mock external services (APIs, third-party services) Prefer real implementations wh...
53
15563 competitor-content-analyzer onewave-ai/claude-skills
Competitor Content Analyzer Track competitor blog posts, whitepapers, and content strategy. Identify content gaps in your strategy. Instructions You are an expert at competitive content analysis and content strategy. Analyze competitor content, identify gaps and opportunities, provide strategic recommendations. Output Format Competitor Content Analyzer Output Generated: {timestamp} --- Results [Your formatted output here] --- Recommendations [Actionable next steps] Best Practices...
53
15564 kubernetes-flux oimiragieo/agent-studio
Kubernetes Flux Skill Installation The skill invokes the Flux CLI. Install: macOS/Linux (Homebrew) : brew install fluxcd/tap/flux macOS/Linux (script) : curl -s https://fluxcd.io/install.sh | sudo bash Windows (winget) : winget install -e --id FluxCD.Flux Windows (Chocolatey) : choco install flux Custom dir : curl -s https://fluxcd.io/install.sh | bash -s ~/.local/bin Verify: flux --version . Then use flux bootstrap to deploy controllers if needed. Cheat Sheet & Best Practices Bootstrap: flux bo...
53
15565 review-feedback-schema existential-birds/beagle
Review Feedback Schema Purpose Structured format for logging code review outcomes. This data enables: Identifying rules that produce false positives Tracking skill accuracy over time Automated skill improvement via pattern analysis Schema date,file,line,rule_source,category,severity,issue,verdict,rationale Field Type Description Example Values date ISO date When review occurred 2025-12-23 file path Relative file path amelia/agents/developer.py line string Line number(s) 128, 190-191 rule_sour...
53
15566 eachlabs-face-swap eachlabs/skills
EachLabs Face Swap Swap faces between images and videos using the EachLabs Predictions API. Authentication Header: X-API-Key: <your-api-key> Set the EACHLABS_API_KEY environment variable. Get your key at eachlabs.ai . Available Models Model Slug Best For AI Face Swap V1 aifaceswap-face-swap Image face swap Eachlabs Face Swap each-faceswap-v1 Image face swap Face Swap (legacy) face-swap-new Image face swap Faceswap Video faceswap-video Video face swap Examples Image Face Swap with AI Face Swap V1...
53
15567 github-ai-features-2025 josiahsiegel/claude-plugin-marketplace
🚨 CRITICAL GUIDELINES Windows File Path Requirements MANDATORY: Always Use Backslashes on Windows for File Paths When using Edit or Write tools on Windows, you MUST use backslashes (\) in file paths, NOT forward slashes (/). Examples: ❌ WRONG: D:/repos/project/file.tsx ✅ CORRECT: D:\repos\project\file.tsx This applies to: Edit tool file_path parameter Write tool file_path parameter All file operations on Windows systems Documentation Guidelines NEVER create new documentation files unless ...
53
15568 upgrade-stylus-contracts openzeppelin/openzeppelin-skills
Stylus Upgrades Contents Stylus Upgrade Model Proxy Patterns Access Control Upgrade Safety Stylus Upgrade Model Stylus contracts run on Arbitrum as WebAssembly (WASM) programs alongside the EVM. They share the same state trie, storage model, and account system as Solidity contracts. Because of this, EVM proxy patterns work identically for Stylus — a Solidity proxy can delegate to a Stylus implementation and vice versa. Stylus Solidity Proxy mechanism Same — delegatecall to implementation contrac...
53
15569 sparc-methodology ruvnet/claude-flow
SPARC Methodology - Comprehensive Development Framework Overview SPARC (Specification, Pseudocode, Architecture, Refinement, Completion) is a systematic development methodology integrated with this framework's multi-agent orchestration capabilities. It provides 17 specialized modes for comprehensive software development, from initial research through deployment and monitoring. In agent-studio: When the mcp__claude-flow__* or npx claude-flow examples below are not available, use the Task tool to ...
53
15570 seo analyst eddiebe147/claude-settings
SEO Analyst Expert SEO analysis agent that conducts comprehensive search optimization research, analyzes performance, identifies opportunities, and develops data-driven strategies. Specializes in keyword research, technical SEO audits, content optimization, competitor analysis, and ranking strategies. This skill applies rigorous SEO methodologies, search algorithms understanding, and data analysis to improve organic search visibility and traffic. Perfect for content strategy, website optimizatio...
53
15571 icon designer eddiebe147/claude-settings
Icon Designer An icon design expert that creates cohesive, scalable icon sets for interfaces and brands. This skill combines visual design principles, icon design best practices, and SVG optimization to produce crisp, consistent iconography that enhances user interfaces. Whether you need a complete icon system for a product, custom icons for a specific feature, or guidance on icon selection and usage, this skill ensures your icons are both beautiful and functional. Core Workflows Workflow 1: Cus...
53
15572 wish-ssh-code-review existential-birds/beagle
Wish SSH Code Review Quick Reference Issue Type Reference Server setup, middleware references/server.md Session handling, security references/sessions.md Review Checklist Host keys are loaded from file or generated securely Middleware order is correct (logging first, auth early) Session context is used for per-connection state Graceful shutdown handles active sessions PTY requests are handled for terminal apps Connection limits prevent resource exhaustion Timeout middleware prevents hung ...
53
15573 problem-space open-horizon-labs/skills
/problem-space Map the terrain where solutions live. What are we optimizing? What constraints do we treat as real? Which constraints can be questioned? Problem space exploration precedes solution space. Understanding the terrain is the work. Jump to code too early and you'll build the wrong thing fast. When to Use Invoke /problem-space when: Starting new work - Before jumping to implementation, understand what you're actually solving Hitting repeated blockers - The same problems keep appear...
53
15574 akshare nicepkg/ai-workflow
AkShare - Chinese Financial Data Overview AkShare is a free, open-source Python library for accessing Chinese financial market data. This skill provides guidance for fetching data from Chinese exchanges including Shanghai Stock Exchange, Shenzhen Stock Exchange, Hong Kong Exchange, and more. Quick Start Install AkShare: pip install akshare Basic stock quote: import akshare as ak df = ak . stock_zh_a_spot_em ( ) Real-time A-share data Stock Data A-Shares (A股) Real-time quotes: All A-shares real...
53
15575 workflow-checkpoint-refactor laurigates/claude-plugins
/workflow:checkpoint-refactor Multi-phase refactoring with persistent state that survives context limits and session boundaries. When to Use This Skill Use this skill when... Use direct refactoring instead when... Refactoring spans 10+ files Changing 1-5 files Work will exceed context limits Small, focused change Need to resume across sessions Single-session task Multiple dependent phases Independent file changes Team coordination on large refactor Solo quick fix Context Repo root: ! git rev-par...
53
15576 learning-development-plan dengineproblem/agents-monorepo
Learning Development Plan Designer Expert in creating comprehensive, personalized learning development plans with skills assessment, goal setting, and progress tracking frameworks. Core Principles Competency-Based Frameworks Map competencies to proficiency levels (Novice → Expert) Align with role requirements and career paths Define behavioral indicators for each level Establish prerequisite relationships between competencies Adult Learning Theory Apply 70-20-10 model (experiential, social, form...
53
15577 fintech-banking dylantarre/animation-principles
Apply Disney's 12 principles to create trustworthy, secure-feeling experiences that handle money with appropriate gravitas. The 12 Principles Applied 1. Squash & Stretch - Restrained Use: Money is serious, avoid playful squash - Number Counters: Subtle stretch as values update - Card Flip: Slight flex when revealing card details 2. Anticipation - Transaction Submit: Brief pause before processing - Balance Updates: Moment of preparation before reveal - Security Checks: Visual preparat...
53
15578 resumable-ai-streams andrelandgraf/fullstackrecipes
Resumable AI Response Streams To set up Resumable AI Response Streams, refer to the fullstackrecipes MCP server resource: Resource URI: recipe://fullstackrecipes.com/resumable-ai-streams If the MCP server is not configured, fetch the recipe directly: curl -H "Accept: text/plain" https://fullstackrecipes.com/api/recipes/resumable-ai-streams
53
15579 dribbble-ui-skills ihlamury/design-skills
Dribbble UI Skills Opinionated constraints for building Dribbble-style interfaces with AI agents. When to Apply Reference these guidelines when: Building light-mode interfaces Creating Dribbble-inspired design systems Implementing UIs with Inter font and 4px grid Colors SHOULD use light backgrounds for primary surfaces MUST use 000000 as page background ( surface-base ) MUST use F2B5D7 for primary actions and focus states ( accent ) SHOULD reduce color palette (currently 40 colors detected) MUST...
53
15580 ab-test-setup kimny1143/claude-code-template
A/B Test Setup You are an expert in experimentation and A/B testing. Your goal is to help design tests that produce statistically valid, actionable results. Initial Assessment Check for product marketing context first: If .agents/product-marketing-context.md exists (or .claude/product-marketing-context.md in older setups), read it before asking questions. Use that context and only ask for information not already covered or specific to this task. Before designing a test, understand: Test Context ...
53
15581 event-management groeimetai/snow-flow
Event Management for ServiceNow Event Management consolidates events from monitoring tools, correlates them, and creates actionable alerts. Event Flow Monitoring Tools (Nagios, SCOM, etc.) ↓ Events (em_event) ↓ Event Rules Alerts (em_alert) ↓ Alert Management Rules Incidents/Changes Key Tables Table Purpose em_event Raw events from sources em_alert Processed alerts em_event_rule Event processing rules em_alert_correlation_rule Alert correlation em_connector Event source connectors...
53
15582 data-analysis jinfanzheng/kode-sdk-csharp
Data Analysis When to use this skill Data exploration : Understand a new dataset Report generation : Derive data-driven insights Quality validation : Check data consistency Decision support : Make data-driven recommendations Instructions Step 1: Load and explore data Python (Pandas) : import pandas as pd import numpy as np Load CSV df = pd . read_csv ( 'data.csv' ) Basic info print ( df . info ( ) ) print ( df . describe ( ) ) print ( df . head ( 10 ) ) Check missing values print ( df . isnul...
53
15583 proposal designer eddiebe147/claude-settings
Proposal Designer Create visually compelling proposals that win clients and close deals When to Use This Skill Use this skill when you need to: Create visual assets and layouts Improve user experience Develop design systems Not recommended for: Tasks requiring copywriting data analysis Quick Reference Action Command/Trigger Create proposal designer design proposal Review and optimize review proposal designer Get best practices proposal designer best practices Core Workflows Workflow 1: Initial P...
53
15584 pushinator vm0-ai/vm0-skills
Pushinator API Use the Pushinator API via direct curl calls to send push notifications to mobile devices. Official docs: https://pushinator.com/api When to Use Use this skill when you need to: Send push notifications to mobile devices Alert users about events, deployments, or updates Integrate notifications into CI/CD pipelines Notify yourself when long-running tasks complete Prerequisites Sign up at Pushinator Download the Pushinator app on your mobile device Create a channel in the Console Gen...
53
15585 load-test-builder patricio0312rev/skills
Load Test Builder Validate system performance under realistic and stress conditions. Core Workflow Define scenarios: User journeys and load patterns Set thresholds: Performance requirements Configure load: Ramp-up, peak, duration Run tests: Execute load scenarios Analyze results: Metrics and bottlenecks Integrate CI: Automated performance gates k6 Load Testing Installation macOS brew install k6 Docker docker pull grafana/k6 Basic Load Test // load-tests/basic.js import http from 'k6/http';...
53
15586 linear-create finesssee/linear-cli
Create Issues Basic linear-cli i create "Title" -t TEAM With options linear-cli i create "Bug" -t ENG -p 1 Priority (1=urgent) linear-cli i create "Task" -t ENG -a me Assign to self linear-cli i create "Fix" -t ENG -l bug With label linear-cli i create "Due" -t ENG --due +3d Due date Agent patterns linear-cli i create "Bug" -t ENG --id-only Return ID only linear-cli i create "Test" -t ENG --dry-run Preview cat desc.md | linear-cli i create "Title" -t ENG -d - Priority 1 =Urgent, 2 =High...
53
15587 setup-stylus-contracts openzeppelin/openzeppelin-skills
Stylus Setup Rust & Cargo Stylus Setup Install the Rust toolchain and WASM target: curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh rustup target add wasm32-unknown-unknown Install the Cargo Stylus CLI: cargo install --force cargo-stylus Create a new Stylus project: cargo stylus new my_project A Rust nightly toolchain is required. The project should include a rust-toolchain.toml specifying the nightly channel, rust-src component, and wasm32-unknown-unknown target. Check the rust-co...
53
15588 account-based-marketing-agent dengineproblem/agents-monorepo
Account-Based Marketing Agent AI-powered автоматизация и оркестрация ABM кампаний для B2B маркетинга. Core Capabilities Agent Functions abm_agent_capabilities : account_intelligence : - Company research automation - Technographic data gathering - Intent signal detection - Buying committee mapping - Competitive intelligence personalization : - Dynamic content generation - Account - specific messaging - Multi - stakeholder personalization - Journey orchestration campaign_automation : - Multi - cha...
53
15589 evaluating-code-models orchestra-research/ai-research-skills
BigCode Evaluation Harness - Code Model Benchmarking Quick Start BigCode Evaluation Harness evaluates code generation models across 15+ benchmarks including HumanEval, MBPP, and MultiPL-E (18 languages). Installation: git clone https://github.com/bigcode-project/bigcode-evaluation-harness.git cd bigcode-evaluation-harness pip install -e . accelerate config Evaluate on HumanEval: accelerate launch main.py \ --model bigcode/starcoder2-7b \ --tasks humaneval \ --max_length_generation 51...
53
15590 voiceserver danielmiessler/personal_ai_infrastructure
Before executing, check for user customizations at: `~/.claude/skills/CORE/USER/SKILLCUSTOMIZATIONS/VoiceServer/` If this directory exists, load and apply any PREFERENCES.md, configurations, or resources found there. These override default behavior. If the directory does not exist, proceed with skill defaults. 🚨 MANDATORY: Voice Notification (REQUIRED BEFORE ANY ACTION) You MUST send this notification BEFORE doing anything else when this skill is invoked. - Send voice notification: ``` cu...
53
15591 remotion-asset-coordinator ncklrs/startup-os-skills
Remotion Asset Coordinator Streamlines the asset preparation workflow from motion design specs to production-ready files. Identifies requirements, recommends sources, guides optimization, and generates proper import code. What This Skill Does Coordinates the complete asset lifecycle: Requirement extraction — Parse specs for all asset needs Source recommendations — Suggest free/paid asset sources Format guidance — Recommend optimal formats for each asset type Preparation workflows — Step-by-step ...
53
15592 swarm-advanced ruvnet/claude-flow
Advanced Swarm Orchestration Master advanced swarm patterns for distributed research, development, and testing workflows. This skill covers comprehensive orchestration strategies using both MCP tools and CLI commands. Quick Start Prerequisites Ensure Claude Flow is installed npm install -g claude-flow@alpha Add MCP server (if using MCP tools) claude mcp add claude-flow npx claude-flow@alpha mcp start Basic Pattern // 1. Initialize swarm topology mcp__claude - flow__swarm_init ( { topology : "m...
53
15593 review-skill-improver existential-birds/beagle
Review Skill Improver Purpose Analyzes structured feedback logs to: Identify rules that produce false positives (high REJECT rate) Identify missing rules (issues that should have been caught) Suggest specific skill modifications Input Feedback log in enhanced schema format (see review-feedback-schema skill). Analysis Process Step 1: Aggregate by Rule Source For each unique rule_source: - Count total issues flagged - Count ACCEPT vs REJECT - Calculate rejection rate - Extract rejectio...
53
15594 myclaw-backup leoyeai/openclaw-backup
MyClaw Backup Built on MyClaw.ai — the AI personal assistant platform that gives every user a full server with complete code control, networking, and tool access. This skill is part of the MyClaw.ai open skills ecosystem. Backs up all critical OpenClaw data to a single .tar.gz archive and restores it to any OpenClaw instance. Includes a built-in HTTP server for browser-based backup management. ⚠️ Trust Boundary & Security Model This skill handles highly sensitive data : bot tokens, API keys, cha...
53
15595 paiupgrade danielmiessler/personal_ai_infrastructure
Before executing, check for user customizations at: `~/.claude/skills/CORE/USER/SKILLCUSTOMIZATIONS/PAIUpgrade/` If this directory exists, load and apply any PREFERENCES.md, configurations, or resources found there. These override default behavior. If the directory does not exist, proceed with skill defaults. PAIUpgrade Skill Universal system upgrade skill with two modes: - Analysis Mode - Analyze ANY content to identify system improvement opportunities - Monitoring Mode - Proactively moni...
53
15596 gogcli michalvavra/agents
CLI for Google Workspace via [steipete/gogcli](https://github.com/steipete/gogcli). Examples ``` gog gmail search 'newer_than:7d from:x@example.com' gog gmail thread <threadId> gog gmail send --to x@example.com --subject "Hi" --body "Text" gog calendar events primary --from 2025-01-15T00:00:00Z --to 2025-01-16T00:00:00Z gog calendar create primary --summary "Meeting" --from <RFC3339> --to <RFC3339> gog drive search "quarterly report" gog drive upload ./file.pdf --parent <folderId> gog drive...
53
15597 aws-expert personamanagmentlayer/pcl
You are an expert in AWS (Amazon Web Services) with deep knowledge of cloud architecture, core services, security, cost optimization, and production operations. You design and manage scalable, reliable, and cost-effective AWS infrastructure following AWS Well-Architected Framework principles. Core Expertise Compute Services EC2 (Elastic Compute Cloud): ``` Launch EC2 instance aws ec2 run-instances \ --image-id ami-0c55b159cbfafe1f0 \ --instance-type t3.micro \ --key-name my-ke...
53
15598 charts-flow vladm3105/aidoc-flow-framework
charts-flow Purpose The charts-flow skill automates creation and management of Mermaid diagrams for technical documentation. It separates diagram source files from main documents to improve rendering performance, provides automatic SVG conversion for human viewing, and maintains traceability between parent documents and diagram files. Key Benefits: Performance: Separate diagram files load faster in documentation viewers Dual Format: Mermaid source for AI assistants, SVG preview for humans Tra...
53
15599 b2c-sites salesforcecommercecloud/b2c-developer-tooling
B2C Sites Skill Use the b2c CLI plugin to list and inspect storefront sites on Salesforce B2C Commerce instances. Tip: If b2c is not installed globally, use npx @salesforce/b2c-cli instead (e.g., npx @salesforce/b2c-cli sites list ). Examples List Sites list all sites on the configured instance b2c sites list list sites on a specific server b2c sites list --server my-sandbox.demandware.net list sites with JSON output (useful for parsing/automation) b2c sites list --json use a specific instan...
53
15600 advanced-patterns josiahsiegel/claude-plugin-marketplace
Advanced T-SQL Patterns Advanced techniques for complex SQL Server scenarios. Quick Reference Pattern Selection Guide Task Pattern Hierarchical data Recursive CTE Top N per group ROW_NUMBER + CTE Correlated subquery alternative CROSS/OUTER APPLY Upsert (insert or update) MERGE Capture modified rows OUTPUT clause Historical data tracking Temporal tables High-throughput OLTP In-Memory OLTP Multiple aggregation levels ROLLUP/CUBE/GROUPING SETS Common Table Expressions (CTEs) Basic CTE WITH Recent...
53