Elasticsearch

elasticsearch

Elasticsearch DBA skill for index/mapping design, query tuning, cluster sizing and operations, shard/replica strategy, ILM, monitoring, troubleshooting (hot nodes, GC, rejected requests), and safe reindexing/upgrades. Use for tasks like designing search schemas, diagnosing performance issues, and...

muzhicaomingwang/ai-ideas·0installs3stars

SKILL.md

Full skill instructions

elasticsearch

Use this skill for Elasticsearch（ES）相关设计、性能与运维（DBA/中间件）任务。

Defaults / assumptions to confirm

ES version and deployment (self-hosted / managed)
Cluster topology (nodes, roles, storage type)
Data volume and retention requirements
Query patterns (search vs analytics) and latency SLO

Workflow

Understand use-cases and query patterns

Primary user journeys: keyword search, filtering, aggregations, sorting.
Write patterns: append-only logs vs frequent updates.
Required consistency and freshness (near real-time delay tolerance).

Index & mapping design

Define index naming convention and templates.
Choose correct field types (keyword vs text, date, long, scaled_float).
Analyze/analyzer strategy for language (e.g., Chinese tokenizer) if needed.
Avoid mapping explosion; control dynamic mappings.
Plan _source and stored fields usage; consider doc values.

Shards and replicas

Pick shard count with future growth and reindex cost in mind.
Avoid too many small shards; target shard size range (e.g., 10–50GB) depending on workload.
Set replicas for availability and read scaling.

Query tuning

Use profile and slow logs to find bottlenecks.
Reduce heavy aggregations; precompute when possible.
Use filters with keyword fields; cache-friendly queries.
Pagination: prefer search_after for deep pages; avoid large from+size.

Lifecycle management

Use ILM (hot-warm-cold-delete) for time-series data.
Rollover policies by size/time; manage retention.

Cluster operations & stability

Monitor heap, GC, CPU, disk watermarks, thread pool rejections.
Detect hot keys/indices; rebalance shards carefully.
Snapshot/restore; restore drills; retention policy.

Safe changes

Mapping changes often require reindex; plan alias-based migrations.
Use index aliases for zero-downtime cutover.
Upgrade runbook: compatibility, rolling upgrade, backout plan.

Outputs

Mapping/index template proposal + rationale.
Shard/replica sizing plan + expected capacity.
Performance diagnosis report (evidence → root cause → fixes).
Migration plan (reindex + alias cutover + verification).

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/muzhicaomingwang/ai-ideas --skill ES

View on GitHub

.project/ai/DBA/skills/ES/SKILL.md

python
Build, review, and refactor Python backend services. Use for tasks like FastAPI/Flask service setup, API design, request/response schemas, database access (PostgreSQL), migrations, background jobs, observability (logging/metrics/tracing), authentication, configuration, testing, and production har...
0 installs
ios
Build, review, and refactor iOS mobile apps (Swift) using modern iOS patterns. Use for tasks like SwiftUI UI, navigation, state management, networking (URLSession), persistence (Core Data/SwiftData/Keychain), dependency injection, modularization (SPM), testing, performance, accessibility, and App...
0 installs
data-analyse
Product management data analysis skill for defining metrics, building funnels/cohorts, diagnosing growth/retention, designing experiments, and translating insights into product actions. Use for tasks like metric trees, event taxonomy, dashboard requirements, SQL-style analysis plans, and decision...
0 installs
wechat-minware
Build, review, and refactor WeChat Mini Program (微信小程序) frontends. Use for tasks like WXML/WXSS/JS/TS structure, page routing, componentization, state management patterns, API requests, login/openid flows integration points, performance optimization (setData), security/privacy compliance, and rel...
0 installs

More skills from muzhicaomingwang

muzhicaomingwang/ai-ideas

feishu-messaging

飞书消息发送与文档创建工作流。触发场景：用户提到"发飞书消息"、"飞书文档"、"通知某人"、"发送到飞书"、"飞书通知"。适用于：发送飞书消息、创建飞书文档、操作多维表格、管理知识库。

3 0

View

muzhicaomingwang/ai-ideas

notion-docs-enhancer

使用 Playwright 浏览器自动化快速创建和完善 Notion 文档。触发场景：用户提到"Notion"、"完善文档"、"创建页面"、"填充内容"、"notion文档"。适用于：创建新页面、修改标题、粘贴 Markdown 内容、格式化文档。

3 0

View

muzhicaomingwang/ai-ideas

hrbp

HRBP skill for organizational planning, hiring support, performance and talent reviews, employee relations, and people-process playbooks. Use for tasks like role design, competency models, interview rubrics, onboarding plans, performance cycles, and sensitive communication templates.

3 0

View

muzhicaomingwang/ai-ideas

strategy

Product strategy skill for defining positioning, ICP/JTBD, competitive analysis, moat hypotheses, pricing/packaging, GTM planning, and roadmap prioritization. Use for tasks like turning ideas into a strategy memo, writing OKRs, creating TAM/SAM/SOM, and making trade-off decisions.

3 0

View

muzhicaomingwang/ai-ideas

teamventure-architecture-migration

Use when refactoring TeamVenture domains/architecture; enforces migration order (Planning→Authorization→Identity→Infrastructure) and preferred steps (split classes before moving packages).

3 0

View

muzhicaomingwang/ai-ideas

nextjs

Build, review, and refactor Next.js (App Router) frontend projects with TypeScript. Use for tasks like creating pages/layouts, routing, server components vs client components, data fetching patterns, UI component structure, forms/validation, auth integration points, env vars, linting/testing, and...

3 0

View

muzhicaomingwang/ai-ideas

research-by-reddit

基于 Reddit API 进行深度调研并生成研究报告。支持搜索、获取帖子、评论分析、情感分析等功能

3 0

View

muzhicaomingwang/ai-ideas

zhimeng-agent 自动化任务技能

> 个人自动化任务集合，通过 macOS launchd 定时调度，自动执行日常任务并同步到多个平台。

3 0

View

muzhicaomingwang/ai-ideas

java

Build, review, and refactor Java backend services (Spring Boot). Use for tasks like REST API design, controllers/services/repositories, PostgreSQL persistence (JPA/MyBatis), migrations, configuration, security (Spring Security), observability, testing, performance tuning, and production hardening.

3 0

View

muzhicaomingwang/ai-ideas

arch-ddd

Apply Domain-Driven Design (DDD) architecture to backend projects. Use for tasks like defining bounded contexts, aggregates and invariants, entities/value objects, domain services, repositories, domain events, application services, anti-corruption layers, and aligning code structure and APIs with...

3 0

View

muzhicaomingwang/ai-ideas

miniapp-design

小程序页面设计与代码生成工作流。触发场景：用户提到"修改页面"、"更新UI"、"添加组件"、"调整布局"、"生成代码"、"小程序设计"。适用于：TeamVenture 小程序的页面设计迭代、UI 组件开发、样式调整。

3 0

View

muzhicaomingwang/ai-ideas

mysql

MySQL DBA skill for schema design review, indexing, query performance tuning (EXPLAIN), transaction/isolation issues, replication/high availability, backup/restore, and operational checklists. Use for tasks like diagnosing slow queries, designing keys/indexes, partitioning strategy, and safe onli...

3 0

View