astra db mcp

Local 2025-08-31 23:26:01 0

A Model Context Protocol server that allows Large Language Models to interact with Astra DB databases, providing tools for managing collections and records through natural language commands.

A Model Context Protocol (MCP) server for interacting with Astra DB. MCP extends the capabilities of Large Language Models (LLMs) by allowing them to interact with external systems as agents.

Prerequisites

You need to have a running Astra DB database. If you don't have one, you can create a free database here. From there, you can get two things you need:

An Astra DB Application Token
The Astra DB API Endpoint

To learn how to get these, please read the getting started docs.

Adding to an MCP client

Here's how you can add this server to your MCP client.

Claude Desktop

To add this to Claude Desktop, go to Preferences -> Developer -> Edit Config and add this JSON blob to claude_desktop_config.json:

{
  "mcpServers": {
    "astra-db-mcp": {
      "command": "npx",
      "args": ["-y", "@datastax/astra-db-mcp"],
      "env": {
        "ASTRA_DB_APPLICATION_TOKEN": "your_astra_db_token",
        "ASTRA_DB_API_ENDPOINT": "your_astra_db_endpoint"
      }
    }
  }
}

Windows PowerShell Users: npx is a batch command so modify the JSON as follows:

  "command": "cmd",
  "args": ["/k", "npx", "-y", "@datastax/astra-db-mcp"],

Cursor

To add this to Cursor, go to Settings -> Cursor Settings -> MCP

From there, you can add the server by clicking the "+ Add New MCP Server" button, where you should be brought to an mcp.json file.

Tip: there is a ~/.cursor/mcp.json that represents your Global MCP settings, and a project-specific .cursor/mcp.json file that is specific to the project. You probably want to install this MCP server into the project-specific file.

Add the same JSON as indiciated in the Claude Desktop instructions.

Alternatively you may be presented with a wizard, where you can enter the following values (for Unix-based systems):

Name: Whatever you want
Type: Command
Command:

env ASTRA_DB_APPLICATION_TOKEN=your_astra_db_token ASTRA_DB_API_ENDPOINT=your_astra_db_endpoint npx -y @datastax/astra-db-mcp

Once added, your editor will be fully connected to your Astra DB database.

Available Tools

The server provides the following tools for interacting with Astra DB:

GetCollections: Get all collections in the database
CreateCollection: Create a new collection in the database
UpdateCollection: Update an existing collection in the database
DeleteCollection: Delete a collection from the database
ListRecords: List records from a collection in the database
GetRecord: Get a specific record from a collection by ID
CreateRecord: Create a new record in a collection
UpdateRecord: Update an existing record in a collection
DeleteRecord: Delete a record from a collection
FindRecord: Find records in a collection by field value
BulkCreateRecords: Create multiple records in a collection at once
BulkUpdateRecords: Update multiple records in a collection at once
BulkDeleteRecords: Delete multiple records from a collection at once
OpenBrowser: Open a web browser for authentication and setup
HelpAddToClient: Get assistance with adding Astra DB client to your MCP client
EstimateDocumentCount: Get estimate of the number of documents in a collection.

[
  {
    "description": "Get all collections in the Astra DB database",
    "inputSchema": {
      "properties": {},
      "required": [],
      "type": "object"
    },
    "name": "GetCollections"
  },
  {
    "description": "Create a new collection in the database",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to create",
          "type": "string"
        },
        "dimension": {
          "default": 1536,
          "description": "The dimensions of the vector collection, if vector is true",
          "type": "number"
        },
        "vector": {
          "default": true,
          "description": "Whether to create a vector collection",
          "type": "boolean"
        }
      },
      "required": [
        "collectionName"
      ],
      "type": "object"
    },
    "name": "CreateCollection"
  },
  {
    "description": "Update an existing collection in the database",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to update",
          "type": "string"
        },
        "newName": {
          "description": "New name for the collection",
          "type": "string"
        }
      },
      "required": [
        "collectionName",
        "newName"
      ],
      "type": "object"
    },
    "name": "UpdateCollection"
  },
  {
    "description": "Delete a collection from the database",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to delete",
          "type": "string"
        }
      },
      "required": [
        "collectionName"
      ],
      "type": "object"
    },
    "name": "DeleteCollection"
  },
  {
    "description": "List records from a collection in the database",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to list records from",
          "type": "string"
        },
        "limit": {
          "default": 10,
          "description": "Maximum number of records to return",
          "type": "number"
        }
      },
      "required": [
        "collectionName"
      ],
      "type": "object"
    },
    "name": "ListRecords"
  },
  {
    "description": "Get a specific record from a collection by ID",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to get the record from",
          "type": "string"
        },
        "recordId": {
          "description": "ID of the record to retrieve",
          "type": "string"
        }
      },
      "required": [
        "collectionName",
        "recordId"
      ],
      "type": "object"
    },
    "name": "GetRecord"
  },
  {
    "description": "Create a new record in a collection",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to create the record in",
          "type": "string"
        },
        "record": {
          "description": "The record data to insert",
          "type": "object"
        }
      },
      "required": [
        "collectionName",
        "record"
      ],
      "type": "object"
    },
    "name": "CreateRecord"
  },
  {
    "description": "Update an existing record in a collection",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection containing the record",
          "type": "string"
        },
        "record": {
          "description": "The updated record data",
          "type": "object"
        },
        "recordId": {
          "description": "ID of the record to update",
          "type": "string"
        }
      },
      "required": [
        "collectionName",
        "recordId",
        "record"
      ],
      "type": "object"
    },
    "name": "UpdateRecord"
  },
  {
    "description": "Delete a record from a collection",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection containing the record",
          "type": "string"
        },
        "recordId": {
          "description": "ID of the record to delete",
          "type": "string"
        }
      },
      "required": [
        "collectionName",
        "recordId"
      ],
      "type": "object"
    },
    "name": "DeleteRecord"
  },
  {
    "description": "Find records in a collection by field value",
    "inputSchema": {
      "properties": {
        "collectionName": {
          "description": "Name of the collection to search in",
          "type": "string"
        },
        "field": {
          "description": "Field name to search by (e.g., 'title', '_id', or any property)",
          "type": "string"
        },
        "limit": {
          "default": 10,
          "description": "Maximum number of records to return",
          "type": "number"
        },
        "value": {
          "description": "Value to search for in the specified field",
          "type": [
            "string",
            "number",
            "boolean"
          ]
        }
      },
      "required": [
        "collectionName",
        "field",
        "value"
      ],
      "type": "object"
    },
    "name": "FindRecord"
  }
]