Skill UI

An end-to-end toolkit designed for analyzing high-density Neuropixels electrophysiology recordings. It implements best practices using SpikeInterface, covering the entire workflow: data loading (SpikeGLX, NWB), preprocessing, motion/drift correction, advanced spike sorting (Kilosort4), quality metric computation, and unit curation (including AI-assisted review). Ideal for neuroscience research.

A meta-skill dedicated to creating high-quality, publication-ready scientific figures. It guides users on best practices for journal submission, including multi-panel layouts, precise error bar inclusion, colorblind-safe palette usage, and adherence to specific journal styles (Nature, Science). It orchestrates libraries like matplotlib, seaborn, and plotly to ensure optimal resolution and format export (PDF, EPS, TIFF).

A comprehensive guide and implementation template for building robust data ingestion pipelines into ClickHouse. Supports multiple sources including HTTP webhooks (with batching), Kafka streams, S3, and direct SQL inserts. Demonstrates best practices for data handling, such as deduplication using ReplacingMergeTree and monitoring query logs, ensuring reliable, scalable data analytics.

This reference architecture provides a comprehensive blueprint for building a robust revenue intelligence data platform integrated with Clari. It covers the entire data lifecycle, including API data extraction (ETL pipeline), data warehousing design (Snowflake/BQ), change detection logic, and advanced analytics/alerting layers. Use this guide when designing a scalable forecast tracking system, planning complex data integrations, or establishing best practices for enterprise revenue analytics.

This comprehensive checklist guides users through critical operational readiness steps for a ClickHouse production deployment. It covers server tuning (config.xml), schema design best practices, robust backup strategies (S3), detailed monitoring setup (Prometheus/Grafana), security hardening, and application integration verification. Use this document before go-live, during major upgrades, or when auditing production systems to ensure maximum stability and performance.

This comprehensive guide details best practices for securing a ClickHouse deployment. It covers essential security measures including role-based access control (RBAC) for granular user permissions, implementing row-level security for multi-tenancy, configuring network IP restrictions, enabling TLS encryption, and setting up detailed audit logging. Use this when hardening a production ClickHouse instance or enforcing strict data governance.

Provides a comprehensive checklist for deploying Hex data analytics integrations into production. It covers critical operational best practices, including API key management, rate limit handling, error resilience (circuit breakers, exponential backoff), and robust monitoring strategies. This guide ensures that data pipelines are deployed reliably, minimizing downtime and guaranteeing consistent, high-quality data reporting for go-live scenarios.

This guide provides comprehensive technical instructions for optimizing Palantir Foundry costs. Learn to use incremental transforms to drastically reduce compute rebuilds, right-size Spark profiles based on data volume, and migrate from expensive API polling to efficient, event-driven webhooks, ensuring both cost efficiency and system stability.

This guide provides a comprehensive reference architecture for building production-ready, enterprise-grade applications on Palantir Foundry. It covers the entire data lifecycle, detailing best practices for the standard data pipeline (Raw > Clean > Model), Ontology design, external API integration patterns, and robust multi-layered security models. Use it when designing, planning, or optimizing complex data infrastructure within Foundry.

This skill allows for the generation and execution of complex, optimized SQL queries to derive deep business insights. It supports sophisticated data workflows, including multi-table joins, multi-dimensional analysis (e.g., trend analysis, attribution modeling, comparative analysis), and subsequent recommendations for appropriate data visualizations (e.g., line charts, waterfall charts). It goes beyond simple SELECT statements by planning the query structure, handling schema relationships, and ensuring adherence to best practices.

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.

This comprehensive checklist guides the deployment of Snowflake data pipelines and integrations into a production environment. It covers critical areas such as authentication best practices, warehouse configuration, data pipeline readiness, access control, monitoring setup, and disaster recovery planning. Use it when preparing for a go-live or validating the stability of your production Snowflake setup.