Schema Viewer
Schema Viewer is a development tool that lets you view your Drupal site's database table structures directly from the admin interface. It helps developers and site builders understand how data is stored by showing table schemas, including fields, data types, and indexes.
Schema Viewer is a lightweight Drupal development tool that allows site builders and developers to browse database table structures from the admin interface. The module offers an autocomplete-based UI to select a table and view its full schema—fields, types, lengths, nullability, and indexes—making it easier to debug, develop custom features, and understand how Drupal maps data to database tables.
Ideal for custom module developers, site architects, and teams working with complex entity structures or integrations.
Admin Steps to Use Schema Viewer Module
Install the Module
Place the schema_viewer module inside your Drupal site's modules/custom directory.
Enable it using the Drupal UI at:
Admin > Extend (/admin/modules) → Search and check Schema Viewer, then click Install.
Or use Drush:
drush en schema_viewer -y
Access the Schema Viewer Page
Go to:
Admin > Configuration > Development > Schema Viewer
or
Direct URL:
/admin/config/development/schema-viewer
View Table Schema
Use the autocomplete field to enter a table name (e.g., node, users_field_data, etc.).
Once selected, the module will display the schema structure of that table: field names, data types, sizes, and constraints.
Permissions (Optional)
To control access, navigate to:
Admin > People > Permissions
and grant the "Access Schema Viewer" permission to appropriate roles (like administrator or developer).