# Source: https://docs.lancedb.com/api-reference/data/merge-insert-upsert-data.md

# Merge-Insert (Upsert) Data

> Perform a merge-insert operation (upsert) on a table by combining insert, update, and delete operations based on matching criteria. This endpoint enables sophisticated data synchronization patterns for keeping tables in sync with external data sources.



---

> To find navigation and other pages in this documentation, fetch the llms.txt file at: https://docs.lancedb.com/llms.txt