MongoDB Pro icon

MongoDB Pro

Find, insert and update documents in MongoDB

Overview

This node enables advanced interactions with MongoDB, specifically focusing on managing search indexes within a MongoDB collection. The "Drop" operation under the "Search Index" resource allows users to delete an existing search index from a specified MongoDB collection.

Common scenarios for this node include:

  • Removing obsolete or unused search indexes to optimize database performance.
  • Cleaning up indexes before redefining or recreating them.
  • Automating maintenance tasks in MongoDB collections as part of data pipeline workflows.

For example, if you have a collection named products and want to remove a search index called productSearchIndex, this node can perform that deletion programmatically within an n8n workflow.

Properties

Name Meaning
Collection The name of the MongoDB collection where the search index exists and will be dropped.
Index Name The exact name of the search index to drop from the specified collection.

Output

The output is a JSON array where each item corresponds to the result of dropping a search index for each input item processed. Each JSON object contains a key with the index name and a boolean value true indicating successful deletion.

Example output JSON for dropping an index named myIndex:

{
  "myIndex": true
}

If an error occurs during the operation (e.g., index not found), the output JSON will contain an error field describing the issue.

Dependencies

  • Requires a valid connection to a MongoDB instance with appropriate permissions to manage search indexes.
  • Needs an API key credential or authentication token configured in n8n to connect securely to MongoDB.
  • The node depends on the official MongoDB Node.js driver for executing commands.
  • The MongoDB server must support search indexes (MongoDB Atlas or compatible versions).

Troubleshooting

  • Common Issues:

    • Specifying a non-existent collection or index name will cause errors.
    • Insufficient permissions to drop indexes may result in authorization errors.
    • Malformed or missing credentials will prevent connection to MongoDB.
  • Error Messages:

    • "error": "NamespaceNotFound" — The specified collection does not exist.
    • "error": "IndexNotFound" — The specified search index name does not exist in the collection.
    • Connection errors related to invalid credentials or network issues.
  • Resolutions:

    • Verify the collection and index names are correct and exist in the database.
    • Ensure the API key or authentication token has sufficient privileges.
    • Check network connectivity and MongoDB server status.

Links and References

Discussion