MCP ServerDatabar offers two modes of deduplication to keep your data clean: a one-time manual cleanup and an ongoing automatic mode that prevents duplicates as new data arrives.Documentation Index
Fetch the complete documentation index at: https://docs.databar.ai/llms.txt
Use this file to discover all available pages before exploring further.
Single-column deduplication (manual)
Remove duplicate rows based on a specific column. This is a one-off operation best suited for cleaning up after imports or before exporting a list.Select the column
Choose which column should be checked for duplicate values (e.g., email address, domain, phone number).
- Quick cleanup after CSV imports
- Preparing outreach lists with no repeated contacts
- Removing duplicate entries from exported data
Automatic deduplication (ongoing)
Set rules that enforce uniqueness automatically on specified columns. When new rows arrive — from imports, webhooks, or enrichments — duplicates are rejected at the moment they land.Enable automatic deduplication
Open your table settings and navigate to the deduplication rules section.
Select columns to enforce uniqueness
Choose one or more columns that should remain unique across all rows.
- Ongoing data flows where manual cleanup is not practical
- Daily or weekly imports (e.g., LinkedIn contacts, job board scrapes)
- Tables connected to webhooks or automated pipelines
Comparing the two modes
| Feature | Manual | Automatic |
|---|---|---|
| When it runs | On demand (one-time) | Continuously on new data |
| Removes existing duplicates | Yes | No (prevents new ones only) |
| Reversible | No | Rules can be disabled |
| Best for | Post-import cleanup | Ongoing data hygiene |
Related
Tables overview
Learn how tables work in Databar.
Import data
Bring external data into your tables.