• INVENTORY
  • AUDIT
  • CLEANUP
  • HUMAN

How to manage Astra DB collections with your AI

Connect your AI client to DataStax Astra DB once. After that, you can run maintenance tasks just by asking.

Ask AI about this page

Short answer

How can I manage Astra DB collections using my AI?

You can list your existing collections, check document counts, and remove specific documents using natural language. Your AI handles the database commands while you stay in your chat interface. You'll get a clear view of your data and its volume.

Database outcomes.

What you can accomplish.

The AI handles the database operations so you don't have to write manual queries.

INVENTORY

See your collections

The AI pulls a list of all your active collections. You get a clear view of your database structure immediately.

AUDIT

Check record counts

Ask for the number of documents in a specific collection. This gives you a quick way to monitor data volume.

CLEANUP

Remove specific data

You can tell your AI to delete a document. It targets the exact record you specify to keep your database clean.

HUMAN

Review and confirm

The AI performs the actions you request, but you decide which collections to view or which documents to wipe.

The workflow

What your AI does when the request arrives.

Your AI translates your plain English instructions into direct database actions.

  1. Identify collections

    When you ask what's in your database, the AI scans your Astra DB instance to find all available collections.

    list_collections

  2. Verify data volume

    If you need to know how much data is stored, the AI counts the documents within a chosen collection.

    count_documents

  3. Targeted removal

    When you identify a document that needs to go, the AI executes the deletion for that specific entry.

    delete_document

  4. Confirm status

    After a command runs, the AI reports back the result so you know the operation succeeded.

    list_collectionscount_documents

Try it

Copy these to start.

Use these prompts to trigger database actions in your chat window.

Starting points

These are templates. Swap out the collection names or document IDs with your actual Astra DB details.

DataStax Astra DB Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_AqDRfth2dYqeDTcgeoWzkACu9uC1WOaTh5GDBWN7/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — DataStax Astra DB capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "datastax-astra-db-vector-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_AqDRfth2dYqeDTcgeoWzkACu9uC1WOaTh5GDBWN7/mcp"
    }
  }
}
Copy into chat04

  • List all my collections in Astra DB.

  • How many documents are in my 'user_profiles' collection?

  • Delete the document with ID 'abc-123' from the 'logs' collection.

  • Show me all the collections I have currently active.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect DataStax Astra DB Vector once, then ask.

One connection link is all you need. Your credentials stay encrypted and secure on our side, and you can start chatting with your data immediately.

Connect DataStax Astra DB Vector to your AI

FAQ

How this task behaves.

  • 01

    Can the AI create new collections?

    No. This MCP is limited to listing, counting, and deleting existing data.

  • 02

    Will the AI delete my entire database?

    No. The AI can only delete specific documents that you identify. It cannot drop entire collections or wipe the database.

  • 03

    Do I need to write JSON queries?

    No. You just talk to your AI client in plain English, and it handles the underlying database logic.

  • 04

    Can I use this with Cursor or Claude?

    Yes. Any MCP-compatible client like Claude, Cursor, or Windsurf can use this once connected.

  • 05

    Can the AI update existing documents?

    No. The current tools only allow for listing, counting, and deleting documents.

  • More questions about DataStax Astra DB Vector? See everything the DataStax Astra DB Vector Connector can do

Connect DataStax Astra DB to Claude, Cursor, ChatGPT & more