DBWillow Logo

Schema Explorer

Overview

The Schema Explorer provides a visual way to browse your database structure, view table schemas, examine relationships, and understand your data model.

Navigating the Schema

Database List

The sidebar shows:

  • All databases on the server
  • Tables in each database
  • Views, stored procedures, and functions
  • Expand/collapse to navigate

Table Details

Click a table to see:

  • Column names and types
  • Primary keys
  • Foreign keys
  • Indexes
  • Triggers

Features

Column Information

View detailed column information:

  • Data type
  • Nullable status
  • Default values
  • Auto-increment status
  • Column comments

Relationships

See table relationships:

  • Foreign key constraints
  • Referenced tables
  • Relationship types
  • Cascade rules

Schema Diagram Viewer

Visualize complex schemas at a glance:

  • Open the Schema view in the main toolbar
  • Select tables on the left to add them to the diagram
  • Auto-layout nodes horizontally or vertically
  • Drag tables to fine-tune positioning
  • Hover edges to inspect the exact column relationship

Indexes

View table indexes:

  • Index name
  • Columns included
  • Index type (PRIMARY, UNIQUE, INDEX)
  • Cardinality

Table Descriptions

Adding Descriptions

Help the AI understand your tables:

  1. Right-click a table
  2. Select "Edit Description"
  3. Add context about the table's purpose
  4. Save the description

Benefits

  • AI Assistant uses descriptions for better queries
  • Team collaboration
  • Documentation
  • Better understanding

Quick Actions

View Data

  • Right-click table → "View Data"
  • See first 100 rows
  • Quick data preview

Open in SQL Editor

  • Right-click table → "Open in SQL Editor"
  • Generates SELECT query
  • Edit and execute

Export Table

  • Right-click table → "Export"
  • Choose format
  • Download data

Schema Search

Finding Tables

Use the search box:

  • Type table name
  • Filter results
  • Quick navigation

Finding Columns

Search across all columns:

  • Type column name
  • See which tables contain it
  • Navigate directly

Best Practices

Regular Exploration

  • Familiarize yourself with schema
  • Understand relationships
  • Note important tables
  • Document complex structures

Use Descriptions

  • Add descriptions to key tables
  • Explain business logic
  • Document relationships
  • Help team members

Next Steps