> ## Documentation Index
> Fetch the complete documentation index at: https://xata.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Schemas

> Design, manage, and optimize your database schema structure and relationships

<img src="https://mintcdn.com/xata/PDDxPY9xptrEGBCP/images/platform/schemas.png?fit=max&auto=format&n=PDDxPY9xptrEGBCP&q=85&s=91a214cdc089150e8754af98f049e3de" alt="Database schemas interface showing table structure, relationships, and schema management tools" className="rounded-lg" width="2870" height="1550" data-path="images/platform/schemas.png" />

Use the schema view for a 10,000 foot view of your database schema, tables, relationships and column details.
Design, manage, and optimize your database schema structure, tables, relationships, and indexes for optimal performance and data integrity.

## Supported Features

* **Table View**: View your schema in a table view for each table with visibility into data types, contstraints, relationships and indices
* **UML View**: Use the UML view for a graphical representation of your schema
* **Schema Diff**: Choose to the diff option to view a diff of your branch schema and its parent branch