Skill UI

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.

A comprehensive guide detailing modern architectural patterns for building high-performance user interfaces with React and Next.js. Covers advanced techniques including Compound Components, Render Props, custom state hooks (like useQuery and useDebounce), advanced state management (Context + Reducer), and performance optimization strategies like memoization and code splitting.

A comprehensive guide to best practices for data access and persistence in Spring Boot using JPA and Hibernate. Covers critical topics such as entity modeling, relationship management (preventing N+1), transaction handling, query optimization, indexing strategies, and connection pooling.

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.

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.

This skill helps audit Django code for critical performance issues like N+1 queries, unbounded querysets, and missing indexes. It ensures verified findings on ORM efficiency and database bottlenecks before reporting, focusing on scalable web application optimization.

Master Firebase backend services including Authentication, Firestore, Realtime Database, Cloud Functions, Storage, and Hosting. Learn security rules, data modeling for read-heavy workloads, and cost optimization to avoid pitfalls like expensive reads and query limitations.

Expert in Prisma ORM covering schema design, migrations, query optimization, relations modeling, and database operations for PostgreSQL, MySQL, and SQLite. Provides diagnostics, best practices, and prioritized fixes for common issues.

This comprehensive workflow guides the development of modern, scalable full-stack applications using Next.js 14+, React, and TypeScript. It covers all phases, from project setup and component architecture to advanced data fetching (Server Components, React Query), styling with Tailwind CSS, robust testing (E2E via Playwright), and deployment optimization. Ideal for building complex, production-grade web interfaces.

This skill empowers expert-level web research using advanced search techniques, query optimization, and domain filtering. It assists in synthesizing information from multiple sources, verifying facts, and providing actionable insights with credibility assessments. Ideal for data gathering, trend analysis, and compiling structured research summaries efficiently.

Diagnose slow SQL queries using execution plans, preserve results, and validate indexing or query modifications against representative data. This skill helps debug performance issues, design efficient schemas, reduce database load, and improve application scalability for growing datasets.