mongodb-query-optimizer 是做什么的?
帮助优化 MongoDB 查询和索引。仅在用户询问优化或性能问题时使用:例如“如何优化这个查询?”“如何创建索引?”“为什么这个查询慢?”“能修复我的慢查询吗?”“集群中有哪些慢查询?”等。除非用户明确要求性能或索引帮助,否则不要为常规 MongoDB 查询编写而调用。优先选择索引化作为优化策略。在可用时使用 MongoDB MCP。
帮助优化 MongoDB 查询和索引,仅在用户需要性能或索引协助时启用。
该技能专注于 MongoDB 查询优化与索引策略,旨在帮助性能问题排查。当用户提出类似“如何优化此查询”“为什么查询慢”等涉及性能或索引的问题时,此技能会被激活。它倾向于优先通过索引化来实现优化,避免被用于常规查询编写。技能支持在含有 MongoDB MCP(模型上下文协议)的环境中运行,自动利用可用工具进行分析。其核心价值在于精准定位慢查询,并提供具体、可操作的优化建议,从而提升数据库整体响应效率。
npx skills add https://github.com/mongodb/agent-skills/tree/main/skills/mongodb-query-optimizerInstalled? Explore more 生产力与协作 skills: steipete/gemini, steipete/gh-issues, steipete/skill-creator · View all 6 →
帮助优化 MongoDB 查询和索引。仅在用户询问优化或性能问题时使用:例如“如何优化这个查询?”“如何创建索引?”“为什么这个查询慢?”“能修复我的慢查询吗?”“集群中有哪些慢查询?”等。除非用户明确要求性能或索引帮助,否则不要为常规 MongoDB 查询编写而调用。优先选择索引化作为优化策略。在可用时使用 MongoDB MCP。
This repo contains 5 individual skills — each has its own dedicated page.
Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
Guide users through configuring key MongoDB MCP server options. Use this skill when a user has the MongoDB MCP server installed but hasn't configured the required environment variables, or when they ask about connecting to MongoDB/Atlas and don't have the credentials set up.
Generate read-only MongoDB queries (find) or aggregation pipelines using natural language, with collection schema context and sample documents. Use this skill whenever the user asks to write, create, or generate MongoDB queries, wants to filter/query/aggregate data in MongoDB, asks "how do I query...", needs help with query syntax, or discusses finding/filtering/grouping MongoDB documents. Also use for translating SQL-like requests to MongoDB syntax. Does NOT handle Atlas Search ($search operator), vector/semantic search ($vectorSearch operator), fuzzy matching, autocomplete indexes, or relevance scoring - use search-and-ai for those. Does NOT analyze or optimize existing queries - use mongodb-query-optimizer for that. Does NOT handle aggregation pipelines that involve write operations. Requires MongoDB MCP server.
MongoDB schema design patterns and anti-patterns. Use when designing data models, reviewing schemas, migrating from SQL, or troubleshooting performance issues caused by schema problems. Triggers on "design schema", "embed vs reference", "MongoDB data model", "schema review", "unbounded arrays", "one-to-many", "tree structure", "16MB limit", "schema validation", "JSON Schema", "time series", "schema migration", "polymorphic", "TTL", "data lifecycle", "archive", "index explosion", "unnecessary indexes", "approximation pattern", "document versioning".
Guides MongoDB users through implementing and optimizing Atlas Search (full-text), Vector Search (semantic), and Hybrid Search solutions. Use this skill when users need to build search functionality for text-based queries (autocomplete, fuzzy matching, faceted search), semantic similarity (embeddings, RAG applications), or combined approaches. Also use when users need text containment, substring matching ('contains', 'includes', 'appears in'), case-insensitive or multi-field text search, or filtering across many fields with variable combinations. Provides workflows for selecting the right search type, creating indexes, constructing queries, and optimizing performance using the MongoDB MCP server.
Gemini CLI one-shot prompts, summaries, generation, skills, hooks, MCP, or Gemma routing.
Fetch GitHub issues, select candidates, spawn background fix agents, open PRs, and optionally process PR review comments.
Create, edit, audit, tidy, validate, or restructure AgentSkills and SKILL.md files.
Search, install, update, sync, or publish agent skills with the ClawHub CLI and registry.
Delegate coding work to Codex, Claude Code, or OpenCode as background workers; not simple edits or read-only code lookup.
List, configure, authenticate, call, and inspect MCP servers/tools with mcporter over HTTP or stdio.