Skill UI

A comprehensive guide for optimizing SEO indexing and managing crawl budget specifically for Next.js applications. Covers fixing Google Search Console coverage errors, implementing proper canonical tags, auditing sitemaps, managing static rendering, and optimizing internal linking for maximum search visibility.

A comprehensive guide and methodology for identifying, measuring, and fixing performance bottlenecks across the entire stack. This skill covers optimizing database queries (e.g., N+1 problems, missing indexes), improving API efficiency (caching, parallel processing), and enhancing frontend performance (memoization, code splitting, image optimization). It emphasizes the critical 'Measure First' principle to ensure all optimizations are data-driven and effective.

Maps each downstream consumer — LLM, RAG indexer, parser, archive, or web renderer — to the right xberg --format and --content-format pair. Includes a decision tree, CLI examples, and token-reduction guidance for extracted documents.

Design efficient PostgreSQL schemas using best practices for data types, indexing, and constraints. Covers normalization, partitioning, and performance optimization for scalable database systems.

A guide to building robust projections and read models from continuous event streams. This pattern is essential for implementing CQRS read sides, creating materialized views, optimizing query performance, and building complex search indexes in event-sourced architectures. Use it when data needs to be transformed and aggregated from raw events into optimized query structures.

A comprehensive technical guide covering the entire lifecycle of Python packaging. It teaches developers how to structure, build, test, and distribute robust Python libraries using modern standards like pyproject.toml, generating wheels, and publishing artifacts reliably to PyPI or private package indexes. Ideal for creating reusable, professional-grade Python code.

Diagnose slow SQL queries using execution plans, preserve results, and validate indexing or query modifications against representative data. This skill helps debug performance issues, design efficient schemas, reduce database load, and improve application scalability for growing datasets.

This skill provides comprehensive guidelines for optimizing Postgres database performance and security. It covers query optimization, schema design, connection management, Row-Level Security, and concurrency handling. Use it when writing SQL, reviewing database configurations, or implementing indexes. Based on Supabase best practices to ensure efficient and secure database operations for production environments.

LWC is a durable memory system for coding agents that preserves project decisions, code structure, and verified context across sessions. It utilizes a physical Wiki document graph and a CodeGraph index to enable source-grounded recall. This tool helps agents search, update, and maintain knowledge without losing critical information during future coding-agent interactions.

This comprehensive guide outlines best practices for optimizing vector indexes for production systems. It covers critical techniques such as tuning HNSW parameters, implementing quantization strategies, and optimizing memory usage. Use this when you need to balance search latency, recall, and scalability for large-scale vector databases.