mongodb-query-optimizer

Solid

Help with MongoDB query optimization and indexing. Use only when the user asks for optimization or performance: "How do I optimize this query?", "How do I index this?", "Why is this query slow?", "Can you fix my slow queries?", "What are the slow queries on my cluster?", etc. Do not invoke for general MongoDB query writing unless user asks for performance or index help. Prefer indexing as optimization strategy. Use MongoDB MCP when available.

API & Backend 713 stars 60 forks Updated 3 days ago Apache-2.0

Install

View on GitHub

Quality Score: 95/100

Stars 20%
95
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# MongoDB Query Optimizer ## When this skill is invoked Invoke **only** when the user wants: - Query/index **optimization** or **performance** help - **Why** a query is slow or **how to speed it up** - **Slow queries** on their cluster and/or **how to optimize them** Do **not** invoke for routine query authoring unless the user has requested help with optimization, slow queries, or indexing. ## High Level Workflow ### General Performance Help If the user wants to examine slow queries, or is looking for general performance suggestions (not regarding any particular query): - Use MongoDB MCP server **atlas-get-performance-advisor** tool to fetch slow query logs and performance advisor output - Make suggestions based on this information If Atlas MCP Server for Atlas is not configured or you don’t have enough information to run **atlas-get-performance-advisor** against the correct cluster, tell the user that general performance analysis requires Atlas MCP Server configuration with API credentials, and suggest they configure it or ask about a specific query instead. ### Help with a Specific Query If the user is asking about a particular query: - Use **collection-indexes**, **explain**, and **find** MCP tools to get existing indexes on the collection, explain() output for the query, and a sample document from the collection - Use **atlas-get-performance-advisor MCP** tool to fetch slow query logs and performance advisor output Then make an optimization suggestio...

Details

Author
fcakyon
Repository
fcakyon/claude-codex-settings
Created
10 months ago
Last Updated
3 days ago
Language
Python
License
Apache-2.0

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

API & Backend Listed

mongodb-atlas-cli

Comprehensive MongoDB Atlas + mongosh skill for performance auditing, all index types (b-tree/text/2dsphere/hashed/TTL/partial/wildcard/Atlas-Search/Vector-Search), Performance Advisor analysis, query explain, schema advice, backup status, alerts, week-over-week diffs, and additive index creation. Read-only by default; create-index ops gated behind explicit `--confirm`. Hard-blocks any destructive op (delete, drop, restore, pause, terminate, kill, dbuser write, network change). Works against Atlas Cloud (full feature set) and self-hosted/local mongo (mongosh-based subset).

24 Updated 2 days ago
georgekhananaev
AI & Automation Solid

optimizing-sql-queries

This skill analyzes and optimizes SQL queries for improved performance. It identifies potential bottlenecks, suggests optimal indexes, and proposes query rewrites. Use this when the user mentions "optimize SQL query", "improve SQL performance", "SQL query optimization", "slow SQL query", or asks for help with "SQL indexing". The skill helps enhance database efficiency by analyzing query structure, recommending indexes, and reviewing execution plans.

2,274 Updated today
jeremylongshore
API & Backend Listed

query-optimizer

Analyze and optimize SQL queries for better performance and efficiency.

335 Updated today
aiskillstore
API & Backend Solid

database-optimizer

Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.

9,537 Updated 1 weeks ago
Jeffallan
AI & Automation Listed

database-optimizer

Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.

2 Updated today
zacklecon