Database
Database management and queries
altinity-expert-clickhouse-storage
by Altinity
Diagnose ClickHouse disk usage, compression efficiency, part sizes, and storage bottlenecks. Use for disk space issues and slow IO.
altinity-expert-clickhouse-memory
by Altinity
Diagnose ClickHouse RAM usage, OOM errors, memory pressure, and allocation patterns. Use for memory-related issues and out-of-memory errors.
altinity-expert-clickhouse-reporting
by Altinity
Diagnose ClickHouse SELECT query performance, analyze query patterns, identify slow queries, and find optimization opportunities. Use for query latency and timeout issues.
altinity-expert-clickhouse-kafka
by Altinity
Diagnose ClickHouse Kafka engine health, consumer status, thread pool capacity, and consumption issues. Use for Kafka lag, consumer errors, and thread starvation.
altinity-expert-clickhouse-replication
by Altinity
Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and read-only replica problems.
altinity-expert-clickhouse-ingestion
by Altinity
Diagnose ClickHouse INSERT performance, batch sizing, part creation patterns, and ingestion bottlenecks. Use for slow inserts and data pipeline issues.
altinity-expert-clickhouse-overview
by Altinity
Runs a quick overview of Clickhouse server health.
altinity-expert-clickhouse-grants
by Altinity
Diagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades.
altinity-expert-clickhouse-logs
by Altinity
Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
altinity-expert-clickhouse-index-analysis
by Altinity
Analyze whether ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indexes, projections) are being used effectively for actual query patterns. Use when investigating index effectiveness, ORDER BY key design, query-to-index alignment, or when queries scan more data than expected.
altinity-expert-clickhouse-part-log
by Altinity
Diagnose ClickHouse issues by analyzing system.part_log (part creation, merges, mutations, downloads, removals, moves). Use for too many parts / micro-batch inserts, merge backlog or slow merges, mutation storms (ALTER DELETE/UPDATE), unusual replication DownloadPart churn, unexpected RemovePart spikes, or ZooKeeper/Keeper znode growth correlated with part activity.
altinity-expert-clickhouse-mutations
by Altinity
Track and diagnose ClickHouse ALTER UPDATE, ALTER DELETE, and other mutation operations. Use for stuck mutations and mutation performance issues.
altinity-expert-clickhouse-merges
by Altinity
Diagnose ClickHouse merge performance, part backlog, and 'too many parts' errors. Use for merge issues and part management problems.
altinity-expert-clickhouse-dictionaries
by Altinity
Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.
altinity-expert-clickhouse-metrics
by Altinity
Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics. Use for load average, connections, queue monitoring, and resource saturation.
altinity-expert-clickhouse-connection
by Altinity
Should be used when doing clickhouse analysis and diagnostics review before any altinity-expert-clickhouse skill to test clickhouse connection and set general rules
json-repair
by Ven0m0
Use the json_repair Python library to fix invalid/malformed JSON, especially output from LLMs. Trigger this skill whenever you encounter broken JSON strings, need to parse unreliable JSON from model outputs, want a drop-in replacement for json.loads() that auto-repairs, or are building pipelines that consume LLM-generated JSON. Also use when the user mentions "json repair", "fix json", "malformed json", "invalid json from LLM", or needs to robustly parse JSON that may have missing quotes, trailing commas, unescaped characters, or other common LLM output defects.
frappe-reports
by lubusIN
Create reports in Frappe including Report Builder, Query Reports (SQL), and Script Reports (Python + JS). Use when building data analysis views, dashboards, or custom reporting features.
tooling-pnpm
by jasonraimondi
Node.js package manager with strict dependency resolution. Use when running pnpm specific commands, configuring workspaces, or managing dependencies with catalogs, patches, or overrides.
typescript-better-auth-best-practices
by jasonraimondi
Skill for integrating Better Auth - the comprehensive TypeScript authentication framework.
readme
by Shpigford
When the user wants to create or update a README.md file for a project. Also use when the user says "write readme," "create readme," "document this project," "project documentation," or asks for help with README.md. This skill creates absurdly thorough documentation covering local setup, architecture, and deployment.
pywayne-crypto
by wangyendt
Encryption and decryption toolkit for string and byte data. Supports Fernet (AES-128) symmetric encryption, fallback XOR encryption, custom password protection, code obfuscation, and batch processing. Use when users need to encrypt/decrypt sensitive data, protect algorithms, or obfuscate Python code.
pywayne-helper
by wangyendt
Project configuration management helper for YAML config files. Use when projects need cross-process/cross-file parameter sharing via a centralized config file. Supports automatic project root detection, nested config key management, and waiting mechanism for values set by other processes.
RAG System Configuration
by oyi77
This RAG system powers Vilona's memory. Every significant decision, lesson learned, and insight gets stored and retrieved automatically.