Database
Database management and queries
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-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.
smolagents
by svngoku
Build AI agents with Hugging Face's SmolAgents framework. Use when creating code-executing agents, tool-calling agents, multi-agent systems, agentic RAG, text-to-SQL pipelines, web browsing agents, or any multi-step AI workflows. Covers CodeAgent, ToolCallingAgent, custom tools, MCP integration, memory management, secure code execution (E2B, Docker, Blaxel), and model configuration (HF Inference, LiteLLM, Transformers, Ollama).
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-schema
by Altinity
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
tree-sitter
by ssiumha
AST parsing, S-expression queries, tag extraction via tree-sitter CLI. Use when parsing code into AST, extracting tags, visualizing syntax trees, or performing structural analysis beyond ast-grep.
laravel-migrations-and-factories
by noartem
Safe database change patterns; when to modify vs add migrations; always pair models with migrations and factories; seeding guidance
database
by Demerzels-lab
Database management and queries. Connect to SQL and NoSQL databases, run queries, and manage schemas.
implementation-guide
by nbbaier
Generate comprehensive implementation guides for coding tasks instead of writing code directly. Use when the user requests detailed implementation documentation, step-by-step development guides, or when they want to implement features themselves using tools like Cursor. Creates exhaustive guides with background context, architecture decisions, milestones with verification points, and rationale for a "build-it-yourself" workflow.
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.
vcp-init
by Z-M-Huang
Initialize VCP configuration for this project. Creates global config (~/.vcp/config.json) if it doesn't exist, then creates project config (.vcp/config.json). Detects frameworks, scopes, and discovers the plugin path. Run this once when setting up VCP for a new project.
nestjs-best-practices
by koolamusic
NestJS best practices and architecture patterns for building production-ready applications. This skill should be used when writing, reviewing, or refactoring NestJS code to ensure proper patterns for modules, dependency injection, security, and performance.
claude-agent-sdk
by ssiumha
Builds Claude Agent SDK agents in Python. Use when creating custom tools, hooks, sub-agents, or MCP integrations with the Agent SDK. Python 에이전트 구축 시 사용.
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.
deployment
by ssiumha
Automates deployments and infrastructure management. Use for PM2, Helmfile/K8s, Ansible playbooks, database config, monitoring setup, or multi-server automation.
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
ascii-diagram
by ssiumha
복잡도에 따라 ASCII art 또는 Mermaid 다이어그램을 선택하여 생성. Use when visualizing architecture, drawing diagrams, explaining structure visually, or 도식화/다이어그램 요청 시. 중간 복잡도는 ASCII art 우선.
altinity-expert-clickhouse-caches
by Altinity
Analyze ClickHouse cache systems including mark cache, uncompressed cache, and query cache. Use for cache hit ratio issues and cache tuning.
binance
by Demerzels-lab
Binance exchange integration. Trade spot, futures, and manage portfolio on the world's largest crypto exchange.
sqlalchemy-postgres
by cfircoo
Expert guidance for SQLAlchemy 2.0 + Pydantic + PostgreSQL. Use when setting up database layers, defining models, creating migrations, or any database-related work. Automatically activated for DB tasks.