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.

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.

Important

Tool Name	Description	Required Scopes
sfmc_bulk_upsert_data_extension_rows	Async bulk upsert rows into a Data Extension. Special considerations: 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. Special considerations: 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. Special considerations: Asynchronous	Data | Data Extensions | Write
sfmc_delete_data_extension	Delete a data extension. Special considerations: Destructive	Data | Data Extensions | Write
sfmc_get_bulk_job_status	Get the status of an async bulk data job. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_get_bulk_job_results	Get the results of a completed async bulk data job. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_get_data_extension	Retrieve a data extension. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_get_data_extension_fields	Retrieve the field definitions for a data extension. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_get_data_extension_folders	List all data extension folders. Special considerations: 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. Special considerations: Read-only, open-world	(No permissions required)
sfmc_get_data_extensions	Search and list data extensions. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_get_data_extensions_by_category	Retrieve all data extensions in a folder. Special considerations: 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. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_retrieve_data_extension_record	Retrieve a single row from a data extension. Special considerations: Read-only, open-world	Data | Data Extensions | Read
sfmc_update_data_extension	Update the properties of a data extension. Special considerations: Destructive	Data | Data Extensions | Write
sfmc_update_data_extension_field_async	Update the fields in a data extension asynchronously. Special considerations: 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