schema_viewer

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).