get_distinct_values

Retrieve unique values from a specified field in a MongoDB collection to analyze data distribution, identify categories, check quality, or detect anomalies within filtered datasets.

Instructions

Get distinct values for a field in a collection.

Useful for:

Understanding data distribution
Finding unique categories
Data quality checks
Identifying outliers

Example: use_mcp_tool with server_name: "mongodb", tool_name: "get_distinct_values", arguments: { "collection": "users", "field": "role", "filter": { "active": true } }

Input Schema

Name	Required	Description
`collection`	Yes	Collection name
`database`	No	Database name (optional if default database is configured)
`field`	Yes	Field name to get distinct values for
`filter`	No	MongoDB query filter to apply before getting distinct values (optional)

Input Schema (JSON Schema)

{
  "properties": {
    "collection": {
      "description": "Collection name",
      "type": "string"
    },
    "database": {
      "description": "Database name (optional if default database is configured)",
      "type": "string"
    },
    "field": {
      "description": "Field name to get distinct values for",
      "type": "string"
    },
    "filter": {
      "description": "MongoDB query filter to apply before getting distinct values (optional)",
      "type": "object"
    }
  },
  "required": [
    "collection",
    "field"
  ],
  "type": "object"
}

MongoDB MCP Server

get_distinct_values

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MongoDB MCP Server

Related Tools

MCP directory API