Skill UI

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.

An expert developer specializing in secure backend coding practices, vulnerability mitigation, and robust API design. Proficient in preventing common attacks such as SQL injection, XSS, and CSRF. Covers comprehensive areas including input validation, authentication mechanisms (OAuth 2.0, MFA), database security, and implementing necessary security headers (CSP, HSTS) for building secure-by-design applications. Ideal for implementing security fixes or building new, hardened backend services.

Automated assistant that walks through backend background worker setup, covering node.js, Python, Go, databases, caching, messaging, and microservices best practices.

This skill provides comprehensive guidance on using LibreOffice Base for full-cycle database management. Users can create ODB databases, define schemas, manage tables, and establish relationships. It supports connecting to various external databases (MySQL, PostgreSQL, etc.), performing complex data operations, and automating professional reports and forms using SQL and Python scripting (UNO). Ideal for building data-driven applications.

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.

A comprehensive guide for migrating user authentication systems from major providers like Auth0, Firebase, Supabase, or NextAuth to Clerk. It covers essential steps including user data export, bulk import, updating database references, and replacing client and server-side authentication code for a smooth, phased transition.

Learn how to configure and implement robust backend endpoints to handle webhooks from Clerk. This guide covers processing user lifecycle events (creation, update, deletion) and organization events, ensuring seamless data synchronization to your external database. It emphasizes secure practices like Svix signature verification and idempotency protection.

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.

Automates CodeQL database builds, suite selection, and taint-aware scans to surface security and quality issues across supported languages, handling output directories, SARIF results, and extensions in one workflow.

This comprehensive template provides a production-grade reference architecture for CodeRabbit AI code reviews. It is designed to guide teams in establishing rigorous coding standards by defining specific, best-practice instructions for various layers (API, Database, Authentication, Frontend, CI/CD, Infrastructure). Use this as a robust starting point to build a comprehensive, automated, and secure code quality review process.

This skill provides a comprehensive guide to configuring CodeRabbit for advanced, security-focused code reviews. It teaches how to implement rules for detecting hardcoded secrets, common vulnerabilities (like SQL injection and XSS), and enforcing secure coding standards across APIs, databases, and infrastructure code. Use this when hardening a codebase's security posture or ensuring compliance with industry standards.