Skill UI

An expert guide for performing complex data analysis, cleaning, and transformation using pandas DataFrames. This skill covers advanced techniques such as vectorized operations, efficient merging, time series resampling, group-by aggregations, and memory optimization, ensuring production-grade code and robust data validation.

Provides comprehensive security best practices for integrating the Perplexity API. This guide covers secure API key management using environment variables, critical query sanitization (stripping PII like emails, phone numbers, and credit cards), and implementing domain filters for compliance. Essential for developers building production applications that handle sensitive user data.

Phoenix is an open-source observability platform for tracing, evaluating, and monitoring LLM applications; use it to debug prompts, run dataset evaluations, build experiment pipelines, and watch production inference in real time.

Fully managed, auto-scaling vector database tailored for production AI workloads such as RAG, recommendations, and semantic search, offering hybrid dense+sparse search, namespaces, metadata filters, and <100ms latency on serverless infrastructure.

A specialized, comprehensive workflow designed for optimizing PostgreSQL databases. It guides users through performance assessment, advanced query tuning (using EXPLAIN ANALYZE), defining optimal indexing strategies, fine-tuning configuration parameters (like shared_buffers), and setting up robust maintenance and monitoring practices for production environments.

This comprehensive guide details how to properly set up PostHog for multiple environments (development, staging, production). It emphasizes data isolation by utilizing separate projects, allowing granular control over critical analytics features such as session recording rates, autocapture, and feature flag rollout percentages. This ensures accurate and reliable data tracking across all deployment stages, preventing test data from polluting production analytics.

This comprehensive guide outlines advanced strategies for optimizing PostHog in production environments. Key techniques covered include implementing local feature flag evaluation to eliminate network latency, optimizing event batching for network efficiency, utilizing strategic event sampling, and writing efficient HogQL queries. Master these methods to dramatically improve data collection reliability and query speed.

This guide provides robust, production-ready strategies for integrating with the PostHog API. It teaches developers how to handle API rate limits (429 errors) gracefully using exponential backoff and retry logic. Furthermore, it covers implementing request queuing for burst protection, optimizing with data caching, and monitoring rate limit headers, ensuring stable and reliable data ingestion regardless of traffic volume.

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.

Guides and automates Prefect Flow Builder tasks for data pipelines, offering best-practice patterns, production-ready code, configuration templates, and validation advice whenever you mention the tool or request pipeline help.

An end-to-end workflow for building robust, production-ready Python backend APIs. This guide covers all stages, including project scaffolding, SQLAlchemy database integration, Pydantic validation, implementing JWT/OAuth2 authentication, comprehensive error handling, unit testing, and Docker deployment for modern microservices.

A comprehensive guide for profiling, analyzing, and optimizing Python code. It addresses identifying performance bottlenecks related to CPU usage, excessive memory consumption, I/O operations, and slow data processing. Use this skill to improve application speed and efficiency in production environments.