Skill UI

A guide and tooling strategy to optimize programmatic interaction with the Notion API. It helps developers minimize costly rate-limit pressure, reduce engineering overhead, and maximize data throughput by identifying redundant calls, implementing efficient caching, and restructuring database queries. Essential for applications that rely heavily on Notion data synchronization and retrieval.

This guide provides detailed strategies for optimizing Qdrant's operational performance. It covers critical areas such as search speed (latency and throughput), efficient vector indexing strategies, and advanced memory management techniques. Use this when you need to improve the speed, scalability, and resource efficiency of your vector database deployment.

This skill generates comprehensive, production-ready database schema documents. It covers Entity-Relationship (ER) diagrams, detailed SQL DDL definitions, constraint analysis, index strategies, and access pattern optimization. Use it when designing a new database, documenting an existing one, or modeling complex data relationships for engineering review.

A comprehensive guide covering scalable backend architecture patterns, including Repository, Service, and Middleware design. It details best practices for building robust APIs using Node.js, Express, and Next.js. Topics covered include RESTful API structuring, database query optimization (preventing N+1 issues), implementing database transactions, and integrating caching strategies like Redis. This guide is essential for developing high-performance, maintainable server-side applications.

A comprehensive guide to high-performance analytical database patterns using ClickHouse. Covers advanced topics including MergeTree engine types (Replacing, Aggregating), efficient query optimization techniques (filtering, window functions), bulk data insertion strategies, and setting up materialized views for real-time analytics. Ideal for data engineers and analysts building OLAP systems.

Reference patterns and best practices for MySQL, covering schema design, indexing strategy, query optimization and common SQL pitfalls. Useful when building or reviewing database layers in applications.

Optimize end-to-end application performance through comprehensive profiling, observability, and tuning across backend, frontend, and infrastructure layers. Use this skill for coordinating performance improvements, establishing baselines, designing load tests, and ensuring scalability. It covers database optimization, API tuning, and distributed system enhancements to address real bottlenecks.

This skill covers backend architecture patterns, API design, and database optimization specifically for Node.js, Express, and Next.js. It provides server-side best practices for building scalable applications. Use this for designing robust backend systems and optimizing performance in modern web development environments.

ClickHouse database patterns for high-performance analytics, including table design, query optimization, bulk inserts, materialized views, and performance monitoring.

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.

Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. Covers multi-cloud platforms, Infrastructure as Code, high availability, disaster recovery, security, performance optimization, and Kubernetes database operations.

This skill simulates a cloud cost optimization expert specializing in reducing infrastructure expenses across AWS, Azure, and GCP. It analyzes complex cloud spending patterns, identifies waste, overprovisioning, and potential savings opportunities. It provides actionable recommendations, implements cost controls, and proposes cost-effective, reliable architectures, ensuring cost efficiency without sacrificing performance or reliability.