Skill UI

Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.

Documenting backend architecture patterns, API design, database optimization, caching, and error-handling best practices tailored for scalable Node.js, Express, and Next.js API routes.

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.

Chroma is an open-source, AI-native embedding database designed for building sophisticated LLM applications. It allows users to store high-dimensional embeddings and associated metadata, facilitating powerful vector search and full-text filtering. Ideal for implementing Retrieval-Augmented Generation (RAG) systems, semantic search, and document retrieval in local or self-hosted environments, making it perfect for open-source AI projects and prototyping.

Guidelines for building Convex backends with TypeScript, detailing syntax, validators, schema design, queries, mutations, actions, scheduling, and file storage so you can implement Convex database operations, real-time updates, and cron jobs consistently.

Provides automated guidance for designing and implementing cron job schedulers in backend projects, covering best practices, production-ready code, and validation for node.js, Python, Go, databases, and microservices patterns.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

An expert architect specializing in designing, optimizing, and scaling entire data layers from inception (greenfield) to re-architecture. Proficient in selecting the optimal database technology (SQL, NoSQL, Graph, Time-series), designing robust schemas, implementing sophisticated indexing strategies, and planning complex migration paths. Suitable for defining data storage solutions that meet high performance, scalability, and data integrity requirements.

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 skill for designing, optimizing, and migrating complex database schemas. It provides expert-level analysis covering normalization (1NF to BCNF), advanced indexing strategies, and zero-downtime migration patterns. Use this skill to model data relationships, choose between SQL and NoSQL, or restructure existing databases for maximum performance and scalability.

Automates database schema design guidance for backend projects, activating whenever you ask about schema patterns, best practices, or implementation in node.js, Python, Go, microservices, caching, or messaging contexts.