Writing efficient database queries requires deep knowledge of SQL and NoSQL patterns. This skill generates optimized queries with proper parameterization and explains execution strategies for better performance.

JSON data often comes in complex nested structures that are hard to work with. This skill provides expert guidance for parsing, transforming, validating, and converting JSON for any use case.

Poor data quality leads to system failures and bad decisions. This skill validates data against JSON schemas, database schemas, and custom business rules to catch errors early. It also detects duplicates, outliers, and format issues while generating detailed quality reports.

CSV files often contain messy data that needs cleaning and transformation. This skill provides comprehensive tools and examples for parsing, cleaning, and analyzing CSV data efficiently.

Transform raw data into compelling visual stories. Create bar charts, line graphs, scatter plots, heatmaps, and interactive dashboards with professional styling.

Database queries written with for-loops are slow and create maintenance problems. This skill provides guidelines for using SQLAlchemy bulk operations and repository patterns to write fast, maintainable database code.

Large document sets exceed context limits. Process corpora into knowledge graphs for efficient multi-hop reasoning and persistent querying across thousands of documents.

AI model names change frequently. This skill fetches current model lists from Anthropic, OpenAI, Gemini, and Ollama, then classifies them by performance tier for optimal model selection.

Working with Excel files manually is time consuming and error prone. This skill automates spreadsheet creation, editing, and formula recalculation using standard Python libraries.

Writing R code with outdated patterns wastes time and creates technical debt. This skill provides current best practices for tidyverse, rlang metaprogramming, and package development so you can write clean, efficient R code.

Marimo is a reactive Python notebook environment that guarantees consistent state between code and outputs. This skill provides expert guidance for building interactive data apps and reproducible notebooks that run as scripts and deploy as web apps.

Avoid floating-point errors in financial and scientific calculations. This skill evaluates math expressions with arbitrary precision using big.js for exact decimal results.

Growth teams struggle to align on metrics and run disciplined experiments. This skill provides proven frameworks for growth loops, PLG, and experimentation that drive measurable impact while respecting user privacy.

Database schema changes are error-prone and can break production. This skill provides battle-tested patterns for creating idempotent Supabase migrations with workspace isolation and Row Level Security policies.

Inconsistent business information across directories damages local SEO rankings and confuses customers. This skill ensures your NAP data stays perfectly synchronized across Google Business Profile, Apple Maps, Facebook, and 30+ directories with automated audits and schema markup generation.

Web scraping is difficult and time-consuming. Crawl4AI provides 6 intelligent modes for extracting content, screenshots, and PDFs from any website with anti-detection features.

Alembic generates migrations without understanding PostgreSQL performance implications. This skill provides patterns for reviewing database migrations and writing efficient queries that avoid common performance pitfalls.

Building initial molecular structures for simulations requires precise spatial constraints. Packmol automates molecule placement with overlap prevention, supporting boxes, spheres, cylinders, and planes for diverse simulation needs.

Agents lose all knowledge when sessions end. This skill provides patterns for layered memory architectures that preserve entity knowledge, track relationships, and enable temporal queries across sessions.

Building reliable LLM evaluation systems is challenging due to systematic biases. This skill provides production-ready patterns for direct scoring, pairwise comparison, and bias mitigation to create trustworthy automated assessment pipelines.