Skill UI

A comprehensive skill for managing Shopify's unique rate limiting systems, covering both the REST API's leaky bucket mechanism and the GraphQL API's calculated query cost. It provides robust techniques for handling 429 errors, implementing exponential backoff, and optimizing queries to ensure stable, high-throughput e-commerce integrations.

A comprehensive guide to optimizing query performance in Snowflake. Learn advanced techniques such as implementing clustering keys, utilizing materialized views, leveraging result caching, and analyzing query profiles. This guide also covers best practices for warehouse tuning and optimizing common SQL anti-patterns to ensure efficient data querying and cost management.

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.

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.

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.