datastax/astra-db-mcp

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:
1. An Astra DB Application Token
2. 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.
IBM Bob
For **IBM Bob** IDE, follow the procedure at this documentation.
For **IBM Bob** Shell, follow the procedure at this documentation.
Claude Desktop
To add this to Claude Desktop, go to Preferences -> Developer -> Edit Config and add this JSON blob to claude_desktop_config.json:
**Optional Keyspace Configuration:**
By default, this server uses the keyspace configured in the underlying Astra DB library (typically default_keyspace). If you need to connect to a specific keyspace, you can add the ASTRA_DB_KEYSPACE variable to the env object above, like so:
**Windows PowerShell Users:**
npx is a batch command so modify the JSON as follows:
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:
*Note: ASTRA_DB_KEYSPACE is optional. If omitted, the default keyspace configured in the Astra DB library will be used.*
Once added, your editor will be fully connected to your Astra DB database.
Available Tools
The server provides a comprehensive suite of tools spanning Collections, Vector Search, Tables, Keyspaces, and Administration:
📁 Collections & Documents
- GetCollections: Get all collections in the active keyspace
- GetCollectionInfo: Inspect collection options, vector settings, and default ID configuration
- CreateCollection: Create a collection with vector options, distance metrics (cosine, euclidean, dot_product), and auto-vectorize configurations
- UpdateCollection: Update or rename a collection
- DeleteCollection: Delete a collection
- EstimateDocumentCount: Get an approximate count of documents in a collection
- ListRecords: List records with optional sorting, pagination (skip), and projection
- GetRecord: Get a specific record by ID
- CreateRecord: Insert a single document
- UpdateRecord: Update a record
- DeleteRecord: Delete a record by ID
- FindRecord: Find records by exact field value match
- FindWithFilter: Rich querying with MongoDB-style filter operators ($and, $or, $gt, $in, $exists, etc.)