Skill UI

Quick reference of PostgreSQL best practices covering indexing cheatsheets, data type choices, security policies, and configuration templates to guide optimization and troubleshooting workflows.

This comprehensive guide provides solutions for common PostHog integration issues, helping developers diagnose and fix tracking failures. It covers critical topics including event capture problems, feature flag misbehavior, API authentication errors (401/429), and user identity fragmentation. Learn best practices for robust data analytics implementation.

This skill guides the complete setup and configuration of PostHog SDKs for modern applications. It covers best practices for implementing client-side (browser) and server-side (Node.js/Python) event tracking. Users will learn how to install the necessary SDKs via npm or pip, manage environment variables for both Project API Keys and secure Personal API Keys, and initialize the tracking service correctly to ensure accurate and reliable event capture in PostHog.

This guide provides a comprehensive, production-grade architecture for implementing analytics using PostHog. It covers best practices for event taxonomy design, SDK layering (client and server), feature flag management, and integrating the data pipeline (CDP). Ideal for tracking user lifecycle, feature adoption, and revenue in complex web applications.

This guide outlines best practices for securing PostHog API keys. It differentiates between low-risk Project keys and high-privilege Personal keys, detailing methods for implementing least-privilege access, scoped key creation, secure rotation procedures, and leak prevention using environment variables, pre-commit hooks, and server-side isolation.

This comprehensive guide teaches the best practices for writing effective, blameless postmortem reports following technical incidents. It provides a structured approach to documenting timelines, conducting root cause analysis (RCA), identifying systemic failures, and creating actionable follow-up items. Mastering this skill is crucial for fostering organizational learning and preventing future service disruptions.

A comprehensive guide covering critical pitfalls and best practices for writing robust PowerShell scripts on Windows. It details essential rules for operator syntax (parentheses), safe path handling, null checking, advanced error management (try/catch), and correct JSON serialization, ensuring your automation code is highly reliable and maintainable.

Automates the steps for configuring pre-commit hooks, guiding through best practices, generating configs, and validating results for DevOps or version-control workflows.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

Generates Prometheus configuration files on demand, guiding DevOps engineers through best practices for Kubernetes, Terraform, CI/CD, and monitoring while validating outputs against common standards.

Automated guidance for configuring Pub/Sub subscriptions within GCP, offering step-by-step best practices, production-ready configurations, and validation against common standards whenever you mention subscription config requests.

Automates Google Cloud Pubsub topic setup with step-by-step guidance, best practices, production-ready configurations, and validation tailored for GCP skills workflows.