High-performance PostgreSQL patterns. Use when optimizing queries, designing for scale, or debugging performance issues.
PostgreSQL performance engineering beyond basic indexing: query plan instability, statistics staleness, EXPLAIN ANALYZE interpretation, GIN index pending list management, extended…
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.
Use when user needs PostgreSQL database administration, performance optimization, high availability setup, backup/recovery, or advanced PostgreSQL feature implementation.
Use when designing, reviewing, or hardening PostgreSQL replication and high-availability posture against stated reliability targets.
Guides agents implementing or auditing PostgreSQL Row Level Security in a multi-tenant SaaS codebase.
Use when writing or reviewing Postgres queries in a multi-tenant SaaS where every table row must be scoped to a single organization.
Use when designing, reviewing, or evolving a PostgreSQL schema for a production system. Produces normalized schema design, integrity constraints, indexing strategy, Flyway or…
PostgreSQL strictness, schema design, indexing, migration safety, and operational rules. Use when designing schemas, writing queries, reviewing migrations, tuning performance, or…
PostgreSQL internals specialist for query optimization, indexing, partitioning, and advanced featuresUse when "postgresql, postgres, slow query, index, explain analyze, vacuum,…
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from 2025Emma/vibe-coding-cn
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from bg-szy/TOP-SKILLS
PostgreSQL development best practices for schema design, query optimization, and database administration
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards.
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views.
Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer.
Queries PostgreSQL system catalogs pg_stat_activity, pg_stat_user_tables, and pg_locks to diagnose performance issues.
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.
Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE.
Analyzes PostgreSQL query performance using pg_stat_statements, pg_stat_user_tables, and EXPLAIN ANALYZE output.
Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views.
Analyzes PostgreSQL slow queries using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output and pg_stat_statements views.
Diagnoses slow PostgreSQL queries using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE output parsing.
Optimizes PostgreSQL queries using EXPLAIN ANALYZE output parsing with pg_stat_statements extension data.
Executes EXPLAIN ANALYZE BUFFERS on slow PostgreSQL queries and parses the plan tree for sequential scans, nested loop joins, and sort spills.
Analyzes PostgreSQL query execution plans using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) and the pg_stat_statements extension.
Interprets PostgreSQL EXPLAIN ANALYZE output using pg_stat_statements and auto_explain module data. Identifies sequential scan bottlenecks, index recommendations via HypoPG, and…
Queries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency.
Diagnoses PostgreSQL slow queries using pg_stat_statements extension, EXPLAIN ANALYZE output parsing, and pg_stat_user_indexes for index usage analysis.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from whatamelon/AGENT-HARNESS-BASELINE
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from majiayu000/claude-skill-registry
Automates PostgreSQL vacuum and autovacuum troubleshooting via pg_stat_user_tables, pg_locks, and pg_stat_activity views.
PostgREST integration. Manage data, records, and automate workflows. Use when the user wants to interact with PostgREST data.
Configure PostHog CI/CD with GitHub Actions: unit tests with mocked PostHog, integration tests against a dev project, and deployment annotations.
Collect PostHog debug evidence for support tickets and troubleshooting. Gathers SDK versions, API connectivity, event flow status, flag definitions, and redacted configuration…
Deploy PostHog to Vercel, Docker (self-hosted), and Cloud Run. Covers Next.js reverse proxy, server-side capture in edge functions, self-hosted PostHog setup, and…
Create a minimal working PostHog example with event capture, identify, and feature flags. Use when starting a new PostHog integration, testing your setup, or learning basic…
Configure PostHog local development with mocking, debug mode, and testing. Use when setting up a development environment, mocking PostHog for tests, or establishing a fast…
Optimize PostHog performance: local flag evaluation, client batching config, event sampling, efficient HogQL queries, and serverless flush patterns.
Handle PostHog API rate limits with exponential backoff, request queuing, and understanding PostHog's actual limit tiers (240/min analytics, 600/min flags).
Production PostHog architecture: event taxonomy, SDK layering, feature flag strategy, analytics module layout, and data pipeline integration patterns.
PostgreSQL-native identity, configuration, metering, and job queues. SQL functions that work with any language or driver.
API testing skill using Postman and Newman, covering collections, environments, pre-request scripts, test scripts, and CI/CD integration with Newman.
Comandos e automação para executar operações Postman (conversão OpenAPI, execução de testes, geração de relatórios).
Use when an agent needs project context from the context engine through MCP tools. Covers context_resolve recipes for feature, debugging, review, operations, docs, and onboarding…
Comprehensive Power BI data model design review prompt for evaluating model architecture, relationships, and optimization opportunities.
Comprehensive procedures for authoring, configuring, and maintaining Myco's PowerManager infrastructure and scheduled task system.
Generate complete Power Platform custom connector with MCP integration for Copilot Studio - includes schema generation, troubleshooting, and validation
Electrical power distribution design for infrastructure: load calculations (NEC 220), conductor sizing (NEC 310.16), transformer/UPS/PDU selection, redundancy architectures (N…
Create, manage, and deploy Power BI semantic models inside Microsoft Fabric workspaces via `az rest` CLI against Fabric and Power BI REST APIs.
Use when DAX measures need test cases, expected totals, edge cases, time-intelligence validation, RLS context checks, or reconciliation against source totals.
Use when Power BI solutions require a Fabric deployment blueprint covering workspaces, Lakehouse, Warehouse, Dataflows, semantic models, pipelines, Git, capacity, security, and…
Convert Power BI requests into implementation backlog items for Jira, Azure DevOps, Linear, or GitHub Issues.
Diagnoses current price-pack assortment, identifies white spaces and improvement opportunities. Trigger when asked to: analyze SKU portfolio, map competitive landscape by…
Monitors PPA performance in real time and triggers automatic adjustments based on early-warning alerts.
从文稿内容生成专业 PPTX 演示文稿，支持用户提供的模板/参考图风格提取、AI 配图（siliconflow-img-gen）和素材图库（pexels/pixabay）。纯 Python 生成，无需 Google/ChatGPT API。
Resilient PowerPoint generation with shell_agent primary path and python-pptx fallback
Robust PowerPoint generation with shell_agent primary and python-pptx fallback, including directory verification and error debugging
Robust PowerPoint generation with shell_agent primary approach and python-pptx fallback, including working directory verification and inline error debugging