Esri CASE tools with Microsoft Visio, CASE Support. Supported by Esri.

ArcGIS Geodatabase Design with UML (for 10.0). Add-in to Enterprise Architect (third party). Unsupported by Esri.

ArcGIS Diagrammer (for 9.x, 10.0, 10.1, 10.2). Visual editor (not uml). Schema and data reporting. Unsupported by Esri.

Geodatabase Diagrammer (for 9.x, 10.x) Requires Visio. Originally created by Mike Zelier. Unsupported by Esri.

This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if you wish to contribute more content to it then feel free to do so by editing this answer.

X-Ray for ArcCatalog (for 10.0, 10.1, 10.2) Created by Steve Grise of Vertex3. Unsupported by Esri.

Geometric Network Configuration Manager (for 10.2) Save, edit and restore geometric network configuration. Unsupported by Esri.

• Esri CASE tools with Microsoft Visio, CASE Support. Supported by Esri.
• ArcGIS Geodatabase Design with UML (for 10.0). Add-in to Enterprise Architect (third party). Unsupported by Esri.
• ArcGIS Diagrammer (for 9.x, 10.0, 10.1, 10.2). Visual editor (not uml). Schema and data reporting. Unsupported by Esri.
• Geodatabase Diagrammer (for 9.x, 10.x) Requires Visio. Originally created by Mike Zelier. Unsupported by Esri.
• X-Ray for ArcCatalog (for 10.0, 10.1, 10.2) Created by Steve Grise of Vertex3. Unsupported by Esri.
• Geometric Network Configuration Manager (for 10.2) Save, edit and restore geometric network configuration. Unsupported by Esri.