write-mongodb-query

Generate MongoDB queries for Navicat shell and Compass filters.

1|Updated Mar 15, 2026

Search Tags:#database #queries #aggregation #shell #mongodb #compass #navicat

Ready to run

npx skills add https://github.com/ly0o0o/lyoo-ai-productivity --skill write-mongodb-query

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: write-mongodb-query
Source: https://github.com/ly0o0o/lyoo-ai-productivity/tree/main/backend/write-mongodb-query
Command: npx skills add https://github.com/ly0o0o/lyoo-ai-productivity --skill write-mongodb-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation of MongoDB queries (find, insert, update, delete, aggregate) tailored for both Navicat shell syntax and Compass GUI filters, reducing manual drafting errors and speeding up data tasks.

Core Features & Use Cases

Generate Navicat-style shell queries (db.collection.method({...})) and corresponding Compass JSON filters.
Support common operations including find, insert, update, delete, and aggregate with guidance on indexes and data types.
Use cases include data extraction, batch updates, and complex aggregations across collections.

Quick Start

Describe your collection, operation, and preferred tool to receive ready-to-run queries.

Frequently Asked Questions about write-mongodb-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I generate MongoDB queries for Navicat and Compass?▼

To generate MongoDB queries for Navicat and Compass, describe your target collection, requested operation, and preferred tool. The Skill outputs ready-to-run Navicat shell syntax or Compass GUI JSON filters, including index considerations and validation notes.

Can I use MongoDB aggregation pipelines in Navicat shell syntax?▼

Yes, MongoDB aggregation pipelines are supported in Navicat shell syntax. The Skill generates correct db.collection.aggregate([...]) queries and corresponding Compass JSON filters based on your provided schema constraints and data type requirements.

What is the best way to write safe MongoDB update queries for batch operations?▼

The best way to write safe MongoDB update queries for batch operations is by providing your collection schema and update criteria. The Skill generates validated queries with data type guidance, index considerations, and specific syntax for Navicat or Compass.

Does this approach support both MongoDB shell commands and Compass GUI filters?▼

Yes, this approach supports both MongoDB shell commands and Compass GUI filters. It identifies your requested operation—find, insert, update, delete, or aggregate—and outputs the correct code or filters for your chosen database tool.

Why do my MongoDB queries fail due to schema or data type mismatches?▼

MongoDB queries often fail due to schema or data type mismatches when constraints are not properly mapped. The Skill satisfies constraints from your provided schema and returns ready-to-run queries with validation notes to prevent these errors.

How do I extract data using MongoDB find operations in Compass?▼

To extract data using MongoDB find operations in Compass, specify your collection and query criteria. The Skill translates your requirements into correct Compass GUI JSON filters, ensuring accurate data extraction with optional index considerations.