Astra DB MCP Server

Instructions

Implementation Reference

• tools/DeleteRecord.ts:17-36 (handler)

  The main handler function that executes the deletion of a specific record from the given collection by ID using the database client.

  export async function DeleteRecord(params: {
    collectionName: string;
    recordId: string;
  }) {
    const { collectionName, recordId } = params;
  
    const collection = db.collection(collectionName);
    const result = await collection.deleteOne({ _id: recordId });
  
    if (result.deletedCount === 0) {
      throw new Error(
        `Record with ID '${recordId}' not found in collection '${collectionName}'`
      );
    }
  
    return {
      success: true,
      message: `Record '${recordId}' deleted successfully from collection '${collectionName}'`,
    };
  }

• tools.ts:194-211 (schema)

  The JSON schema defining the input parameters for the DeleteRecord tool: collectionName and recordId.

  {
    name: "DeleteRecord",
    description: "Delete a record from a collection",
    inputSchema: {
      type: "object",
      properties: {
        collectionName: {
          type: "string",
          description: "Name of the collection containing the record",
        },
        recordId: {
          type: "string",
          description: "ID of the record to delete",
        },
      },
      required: ["collectionName", "recordId"],
    },
  },

• index.ts:201-213 (registration)

  The switch case in the CallToolRequestSchema handler that registers and invokes the DeleteRecord tool during runtime.

  case "DeleteRecord":
    const deleteRecordResult = await DeleteRecord({
      collectionName: args.collectionName as string,
      recordId: args.recordId as string,
    });
    return {
      content: [
        {
          type: "text",
          text: deleteRecordResult.message,
        },
      ],
    };