Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

astra-db-mcp

MCP.Pizza Chef: datastax

Astra DB MCP server is a Model Context Protocol server that allows large language models to interact directly with Astra DB databases. It enables real-time querying and manipulation of Astra DB data through LLMs, extending their capabilities to act as intelligent agents within database environments. This server requires an Astra DB instance and credentials, facilitating integration with MCP clients like Claude Desktop for enhanced AI-driven database workflows.

Use This MCP server To

Query Astra DB databases using natural language via LLMs Integrate Astra DB data access into AI-powered workflows Enable LLMs to perform CRUD operations on Astra DB Automate data retrieval and updates in Astra DB through MCP Combine Astra DB data with other context sources in MCP clients

README

Astra DB MCP Server

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.

Astra DB Server MCP server

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.

Claude Desktop

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

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

Changelog

All notable changes to this project will be documented in this file. The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

❤️ Contributors

astra-db-mcp contributors


astra-db-mcp FAQ

How do I set up the Astra DB MCP server?
You need a running Astra DB instance, an application token, and the API endpoint. Follow the Astra DB getting started docs to configure environment variables.
Can I use this MCP server with any MCP client?
Yes, it is designed to integrate with MCP clients like Claude Desktop and others supporting MCP servers.
What credentials are required to connect to Astra DB?
An Astra DB Application Token and the API Endpoint URL are required for authentication and connection.
Does this server support real-time data querying?
Yes, it enables LLMs to perform real-time queries and data operations on Astra DB.
Is Astra DB MCP server limited to specific LLM providers?
No, it is provider-agnostic and works with models like OpenAI, Claude, and Gemini.
How secure is the connection between the MCP server and Astra DB?
Security depends on Astra DB's authentication tokens and API security; the MCP server uses these credentials securely.
Can I use this server for both read and write operations?
Yes, it supports CRUD operations allowing both data retrieval and updates.
Where can I find documentation for integrating this server?
Integration docs are available on the Astra DB MCP GitHub repository and the official Astra DB API reference.