Skill UI

Enables Claude to examine EXPLAIN plans, spot slow queries or missing indexes, and deliver concrete optimization steps—ideal for improving database query speed and resource usage when performance issues arise.

This guide provides comprehensive patterns and best practices for working with ClickHouse, a high-performance OLAP database. It covers advanced topics such as MergeTree engine design, efficient query optimization (filtering, aggregations, window functions), bulk/streaming data ingestion, materialized view creation, and performance monitoring techniques, ensuring optimal performance for large-scale analytical workloads.

Guides ClickHouse database architects through schema designs, query optimization, ingestion strategies, and monitoring techniques tailored for high-performance analytical workloads.

This comprehensive workflow guides the entire database lifecycle, from initial architecture design (covering both SQL and NoSQL) to advanced implementation, optimization, and maintenance. It covers crucial stages like schema design, implementing migrations, optimizing query performance, developing robust data pipelines (using tools like Airflow and dbt), and managing data quality and operations. Ideal for engineers building complex, production-grade data systems.

Provides a practical checklist and principles for designing database schemas, indexing strategies, query optimization, and migration planning for both SQL and NoSQL systems, plus guidance on spotting and fixing N+1 issues and denormalization trade-offs.

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

A comprehensive guide to optimizing costs when using the Exa API. This skill teaches techniques like implementing query-level caching (LRU/Redis), strategically selecting search types (keyword vs. neural), query deduplication for batch jobs, and setting up usage monitoring and budget alerts. Use this when managing Exa billing or reducing API expenditure in RAG applications.

Implements multi-tier database caching using Redis, in-memory stores, and CDN integration to reduce load, lower query latency, and support scalable cache-aside, write-through, or read-through workflows when users ask for caching optimizations.

A comprehensive guide and expert skill for mastering Atlassian Jira. Covers project setup, advanced JQL querying, workflow design, issue tracking, automation rules, reporting, and dashboard creation. Essential for technical configuration and operational optimization of Jira instances.

Analyzes SQL statements, identifies bottlenecks, suggests indexes and rewrites, and leverages the sql-query-optimizer plugin so you can improve database responsiveness when queries run slowly.

This guide provides advanced strategies for developers to significantly reduce Perplexity Sonar API billing costs. It covers key techniques including model routing (selecting the right model by query type), setting maximum output tokens, implementing robust query caching, and utilizing domain filters to minimize per-request charges. Essential for building cost-effective, high-volume AI applications.

Provides PostgreSQL optimization advice covering index design, query plan inspection, partitioning, JSONB tweaks, connection pooling, and tuning checkpoints to stabilize OLTP workloads.