Skill UI

A specialized skill for optimizing database performance and scalability across PostgreSQL and MySQL. It guides users through analyzing slow queries, interpreting execution plans (EXPLAIN ANALYZE), designing optimal indexing strategies, tuning configuration parameters, and resolving bottlenecks like lock contention. Essential for DevOps engineers, database administrators, and backend developers.

FAISS (Facebook AI Similarity Search) is a library designed for efficient similarity search and clustering of dense vectors. It supports indexing and searching on billions of vectors at scale, featuring GPU acceleration and multiple index types (Flat, IVF, HNSW, PQ) to balance speed and accuracy. It is essential for building high-performance, large-scale applications requiring fast k-NN retrieval or pure vector similarity matching, especially in fields like RAG and recommendation systems.

A comprehensive pipeline for processing, validating, and optimizing scraped web content from Firecrawl. This tool handles markdown cleaning, structured data extraction using Zod validation, content deduplication, and chunking tailored for Large Language Models (LLMs) and Retrieval-Augmented Generation (RAG) systems. It ensures crawled data is standardized, clean, and ready for downstream consumption or knowledge base indexing.

Comprehensive reference for designing Spring Boot entities, repositories, transactions, pagination, and pooling with JPA/Hibernate patterns plus auditing, indexing, and caching strategies.

Quick reference of PostgreSQL best practices covering indexing cheatsheets, data type choices, security policies, and configuration templates to guide optimization and troubleshooting workflows.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

A specialized, comprehensive workflow designed for optimizing PostgreSQL databases. It guides users through performance assessment, advanced query tuning (using EXPLAIN ANALYZE), defining optimal indexing strategies, fine-tuning configuration parameters (like shared_buffers), and setting up robust maintenance and monitoring practices for production environments.

Blueprint for building SEO-optimized pages at scale using data-driven templates, focused on unique value, clean architecture, indexing, and quality governance. Ideal for teams creating directory, comparison, or location landing pages.

Provides structured guidance to audit site crawlability, indexing, technical foundations, on-page elements, and content quality so you can diagnose SEO issues, prioritize fixes, and improve organic visibility for marketing or product sites.

A specialized tool for comprehensive content optimization and SEO strategy. It analyzes existing content to calculate keyword density, identify primary and secondary targets, and generate relevant LSI (Latent Semantic Indexing) keywords and semantic variations. Use this skill proactively to improve topical authority and ensure natural, high-ranking content structure.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.