Duplicate integrations and expert ratings can no longer be created

Two rules the platform has always described — one integration per catalogue entry, one expert rating per vendor and project — were never actually enforced by the database. Nothing stopped a duplicate being written by a retry, a race, or a bulk import, and once written it sat there alongside the original.

Both rules are now enforced at the database itself, so a duplicate cannot be created in the first place.

Three things to expect, all on the first run:

• Existing duplicates are cleaned up. Where the same integration or the same rating was recorded more than once, the most recent one is kept and the earlier copies are archived. They are not deleted. If your integrations list looks shorter than you remember, this is why.
• Adding an integration you already have now tells you so. You will see “already in this organisation’s integrations” instead of a second copy appearing silently.
• Expert match scores may move slightly. An expert’s quality score averages the ratings they have received, so removing duplicate ratings from that average can nudge a score up or down.

Removing an integration and adding it back is unaffected — that has always been supported and still is.