Skill UI

A comprehensive diagnostic utility designed to collect all necessary evidence when troubleshooting Attio API connectivity issues or preparing a support ticket. It checks API authentication, object schema definitions, rate limit status, and general endpoint health using shell scripting and cURL.

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.

This comprehensive checklist guides users through critical operational readiness steps for a ClickHouse production deployment. It covers server tuning (config.xml), schema design best practices, robust backup strategies (S3), detailed monitoring setup (Prometheus/Grafana), security hardening, and application integration verification. Use this document before go-live, during major upgrades, or when auditing production systems to ensure maximum stability and performance.

Provides a comprehensive, production-ready reference architecture for building advanced analytics platforms powered by ClickHouse. It details everything from project layout (TypeScript/Node.js structure) and data ingestion pipelines (Kafka, Webhooks) to the optimal 3-layer schema design (Raw, Hourly, Daily) and multi-tenancy patterns, ensuring scalable and efficient OLAP query performance.

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.

A comprehensive guide for building scalable and performant GraphQL APIs using Golang. Covers best practices including defining schema (SDL), implementing robust resolver patterns, handling pagination with Relay cursors, and critically, utilizing DataLoaders to prevent N+1 database query issues. Essential for backend engineers designing high-quality services.

A comprehensive guide to production-grade patterns and common pitfalls when using Prisma ORM with TypeScript backends. Covers optimizing schema design, implementing complex queries, managing transactions, handling pagination strategies, and addressing critical traps like connection exhaustion in serverless environments.

An internal utility designed for deep analysis of Python tracebacks. It performs Python-specific root-cause checks, provides guidance for minimal reproducible examples using pytest, and identifies precise targets for implementing defensive coding practices (like guard clauses or schema validation). Ideal for advanced debugging scenarios.

Guidance for designing, building, refreshing, and reviewing Power BI / Analysis Services tabular models from the terminal. Covers star schema, relationships, measures, calculation groups, roles, storage modes, incremental refresh, and model optimization. Routes every operation to the narrowest capable tool: te CLI first, then TOM or MCP, then TMDL. Ensures model quality, performance, and readiness for Copilot/AI.

Aria functions as a System Architect, responsible for establishing the definitive structural foundation of the entire system. She designs comprehensive blueprints covering the data model (schema, relationships, constraints), API contract specifications (endpoints, auth, pagination), modular file structure, and selection of core architectural design patterns. Her output ensures that no code is written without a rigorously defined, approved architectural plan, minimizing ambiguity and technical debt.

This skill transforms vague or high-level project ideas into eight comprehensive, interconnected planning documents (PRD, TechSpec, Design, Schema, etc.). It establishes a definitive, persistent source of truth for the project's scope, architecture, and design guidelines before a single line of code is written. Ideal for initiating brand-new software projects to prevent scope creep and planning gaps.