Skip to main content

Schema visualizer

The schema visualizer helps you inspect relationships between tables.

Use it to check​

  • Primary keys.
  • Foreign keys.
  • Required columns.
  • Unique constraints.
  • Table relationships.

How to use the schema view​

  1. Connect to the database.
  2. Open Schema.
  3. Search for the table you care about.
  4. Follow relationship lines to understand which records depend on each other.
  5. Reset the layout if the diagram becomes hard to read.
  6. Ask Cocoding AI to explain the schema if table names or relationships are unclear.

Example questions to ask Cocoding AI​

Explain how the bookings, listings, and users tables relate to each other.
Which table should I update when a booking is cancelled?
Are there any missing indexes or foreign keys for this schema?

Useful prompts after reviewing schema​

The bookings table should reference guests and rooms.
Add the missing foreign keys and update the app forms to use those relationships.
Add a status field to invoices and show paid, unpaid, and overdue totals on the admin dashboard.

Exporting schema​

When export is available, use PNG or SVG output for product specs, handoff notes, and team reviews.