---
schema_version: "1"
id: 3cb6dbe0fec26d585d46af65f39bd55063aaca6ae17602f22acd77cd03680342
title: Data Extensions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/marketing-cloud/mce-mcp/reference/mce-mcp-tools-data-extensions.md
canonical_url: https://developer.salesforce.com/docs/marketing/mce-mcp/references/mce-mcp-tools/mce-mcp-tools-data-extensions.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ad7b42c2574d857f119425024d233412b931e94e0f09c64b621a1ede0644f56c
products:
  - MCP Server for Marketing Cloud Engagement
  - Marketing Cloud
---
# Data Extensions

The MCP server for Marketing Cloud Engagement includes several tools for managing data extensions. This table includes information about tools related to managing data extensions.

**important:** Destructive tools can change or delete data. Before you use a destructive tool, ask the AI assistant to perform a trial run of the task or show you the code that it plans to execute.

| Tool Name                                | Description                                                                                                                                           | Required Scopes                  |
| ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------- |
| `sfmc_bulk_upsert_data_extension_rows`   | Async bulk upsert rows into a Data Extension.<br><br><b>Special considerations</b>: Asynchronous                                                      | Data \| Data Extensions \| Write |
| `sfmc_bulk_upsert_data_event_rows`       | Batch upsert multiple rows into a Data Extension by external key.                                                                                     | Data \| Data Extensions \| Write |
| `sfmc_clear_data_extension_data`         | Clear all data from a data extension.<br><br><b>Special considerations</b>: Destructive                                                               | Data \| Data Extensions \| Write |
| `sfmc_create_data_extension`             | Create a data extension.                                                                                                                              | Data \| Data Extensions \| Write |
| `sfmc_create_data_extension_field_async` | Add fields to a data extension.<br><br><b>Special considerations</b>: Asynchronous                                                                    | Data \| Data Extensions \| Write |
| `sfmc_delete_data_extension`             | Delete a data extension.<br><br><b>Special considerations</b>: Destructive                                                                            | Data \| Data Extensions \| Write |
| `sfmc_get_bulk_job_status`               | Get the status of an async bulk data job.<br><br><b>Special considerations</b>: Read-only, open-world                                                 | Data \| Data Extensions \| Read  |
| `sfmc_get_bulk_job_results`              | Get the results of a completed async bulk data job.<br><br><b>Special considerations</b>: Read-only, open-world                                       | Data \| Data Extensions \| Read  |
| `sfmc_get_data_extension`                | Retrieve a data extension.<br><br><b>Special considerations</b>: Read-only, open-world                                                                | Data \| Data Extensions \| Read  |
| `sfmc_get_data_extension_fields`         | Retrieve the field definitions for a data extension.<br><br><b>Special considerations</b>: Read-only, open-world                                      | Data \| Data Extensions \| Read  |
| `sfmc_get_data_extension_folders`        | List all data extension folders.<br><br><b>Special considerations</b>: Read-only, open-world                                                          | Data \| Data Extensions \| Read  |
| `sfmc_get_data_extension_link`           | Create and output a direct link to a data extension in the Marketing Cloud Engagement UI.<br><br><b>Special considerations</b>: Read-only, open-world | (No permissions required)        |
| `sfmc_get_data_extensions`               | Search and list data extensions.<br><br><b>Special considerations</b>: Read-only, open-world                                                          | Data \| Data Extensions \| Read  |
| `sfmc_get_data_extensions_by_category`   | Retrieve all data extensions in a folder.<br><br><b>Special considerations</b>: Read-only, open-world                                                 | Data \| Data Extensions \| Read  |
| `sfmc_query_data_extension_rows`         | Query rows from a Data Extension by its external key, with filtering and pagination.<br><br><b>Special considerations</b>: Read-only, open-world      | Data \| Data Extensions \| Read  |
| `sfmc_retrieve_data_extension_record`    | Retrieve a single row from a data extension.<br><br><b>Special considerations</b>: Read-only, open-world                                              | Data \| Data Extensions \| Read  |
| `sfmc_update_data_extension`             | Update the properties of a data extension.<br><br><b>Special considerations</b>: Destructive                                                          | Data \| Data Extensions \| Write |
| `sfmc_update_data_extension_field_async` | Update the fields in a data extension asynchronously.<br><br><b>Special considerations</b>: Destructive, asynchronous                                 | Data \| Data Extensions \| Write |
| `sfmc_upsert_data_extension_record`      | Update a row into a data extension, or insert a row if it doesn’t exist.                                                                              | Data \| Data Extensions \| Write |