MCP Tool Reference Low Risk

FindDistinctValues

Find distinct values for a field in a collection

Part of the DataStax Astra DB MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.

Other

WHEN AI AGENTS USE THIS TOOL

AI agents call FindDistinctValues to perform operations in DataStax Astra DB. While the risk category is not fully classified, applying a rate limit gives you visibility into how often the tool is called and prevents unexpected bursts of activity from autonomous agents.

WHY ENFORCE A POLICY ON FINDDISTINCTVALUES

Applying a policy to FindDistinctValues gives you an audit trail of every call an AI agent makes. Even for low-risk tools, visibility into agent behaviour helps you debug issues, optimise workflows, and maintain compliance with your organisation's security requirements.

RECOMMENDED POLICY

Apply a rate limit to control usage and monitor for unexpected behaviour.

astra-db.yaml 
tools:
  FindDistinctValues:
    rules:
      - action: allow
        rate_limit:
          max: 60
          window: 60

See the full DataStax Astra DB policy for all 19 tools.

DETAILS

Tool Name

FindDistinctValues

Category

Other

MCP Server

DataStax Astra DB MCP Server

Risk Level

Low

MORE DATASTAX ASTRA DB TOOLS

BulkCreateRecords Other
Create multiple records in a collection at once
BulkDeleteRecords Other
Delete multiple records from a collection at once
BulkUpdateRecords Other
Update multiple records in a collection at once
CreateCollection Other
Create a new collection in the database
CreateRecord Other
Create a new record in a collection
DeleteCollection Other
Delete a collection from the database
DeleteRecord Other
Delete a record from a collection
EstimateDocumentCount Other
Estimate the number of documents in a collection using a fast, approximate count method

View all 19 tools →

SIMILAR OTHER TOOLS ON OTHER SERVERS

analytics Algolia
Access Algolia analytics data
monitoring Algolia
Monitor Algolia service status
recommend Algolia
Access Algolia recommendation features
abtesting Algolia
Manage A/B tests
collections Algolia
Manage query suggestions collections
usage Algolia
Access Algolia usage data

RELATED READING

FREQUENTLY ASKED QUESTIONS

What does the FindDistinctValues tool do?

Find distinct values for a field in a collection. It is categorised as a Other tool in the DataStax Astra DB MCP Server, which means it performs auxiliary operations.

How do I enforce a policy on FindDistinctValues?

Add a rule in your Intercept YAML policy under the tools section for FindDistinctValues. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the DataStax Astra DB MCP server.

What risk level is FindDistinctValues?

FindDistinctValues is a Other tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit FindDistinctValues?

Yes. Add a rate_limit block to the FindDistinctValues rule in your Intercept policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block FindDistinctValues completely?

Set action: deny in the Intercept policy for FindDistinctValues. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides FindDistinctValues?

FindDistinctValues is provided by the DataStax Astra DB MCP server (). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

ENFORCE POLICIES ON DATASTAX ASTRA DB

Open source. One binary. Zero dependencies.

VIEW ON GITHUB Full DataStax Astra DB policy →