Skill UI

This guide provides proven architectural patterns for building complex, reliable, and scalable workflows using n8n. It covers core patterns like Webhook processing, HTTP API integration, database synchronization, AI agent design, and scheduled tasks. Learn how to select the right pattern and utilize advanced components for robust automation.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

This skill is designed for understanding complex database structures. It allows users to list all available tables, intelligently filter relevant tables based on natural language queries, retrieve detailed schemas (columns, types, primary/foreign keys), and map inter-table relationships. It culminates in generating the M-Schema format, which is essential for accurately preparing the context needed for advanced SQL query generation.

A comprehensive, production-ready reference architecture for building robust, scalable transcription services using AssemblyAI. This guide demonstrates best practices for layered system design, covering API endpoints, service logic, client management, and infrastructure integration (webhooks, database). It is ideal for designing new high-throughput speech-to-text applications.

This comprehensive guide provides a production-ready reference architecture for implementing scalable search using Algolia. It details best practices for index design (including multi-index strategies), establishing robust data pipelines from source databases, structuring the service layer (search, indexing, settings), and integrating the frontend for optimal performance.

This skill provides expert guidance on building and maintaining applications using Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers critical areas including schema management, multi-tenant architecture, IAM authentication, and safe data migrations (e.g., MySQL to DSQL). Users can execute direct queries, analyze performance bottlenecks using query plan explainability, and adhere to industry best practices for robust, scalable database design.

This plugin allows developers to build Framer components by syncing data from external data sources (such as APIs or databases) into Framer's Managed Collections. It serves as the primary integration pattern, handling both schema creation and item population. Use this when your design requires displaying dynamic content driven by external systems.

A comprehensive guide detailing five validated architecture patterns for utilizing Notion as a powerful backend database. Use cases include: Headless CMS for blogging, task tracking for project management, building knowledge bases (wikis), handling form submissions, and serving as a data pipeline source. Includes schema design and code examples using TypeScript and Python.

Provides a comprehensive, production-ready standard 3-tier reference architecture for Oracle Cloud Infrastructure (OCI). The design covers essential components like VCN, public/private subnets, Internet Gateway, NAT Gateway, Service Gateway, and Autonomous Database. It includes deployment steps using Terraform and OCI SDK Python code, making it ideal for designing new cloud environments or migrating existing patterns from other major cloud providers.

This comprehensive guide details advanced strategies for managing time-series data and data retention in vector databases (like Qdrant). It is designed for scenarios where only recent data is relevant (e.g., social media feeds, news articles). Three core methods are presented: Shard Rotation (recommended for natural time boundaries), Collection Rotation (for per-period configuration needs), and Filter-and-Delete (for simple cleanup). The guide also covers hot/cold tiering to optimize performance.

MockHunter is an advanced skill designed to audit live web pages, providing a comprehensive reality check on visible data. It analyzes every element to determine its true source: whether it is REAL (from the database), MOCK (simulated data), LLM-generated, HARDCODED, BROKEN (broken endpoints), or UNKNOWN. Ideal for auditing AI-generated UIs or reviewing proof-of-concept MVPs before customer sign-off.

Flox is a declarative, Nix-based environment manager designed to create perfectly reproducible development environments. It handles system-level dependencies (like compilers, databases, and native libraries) and ensures that complex toolchains across multiple languages (Python, Node.js, Go, etc.) function identically across macOS and Linux. Ideal for solving 'works on my machine' issues and onboarding new team members instantly.