DB Schema App is an environment audit application that inspects MySQL database tables, indexes, and column structures across separate server deployments on Joget DX 8.

Software development teams and database administrators frequently encounter deployment failures caused by unrecorded schema changes between development, testing, and production servers. Inspecting database structures manually using SQL command-line interfaces or separate administration tools delays migration reviews and risks missed column definitions. Discrepancies in index configurations across environments degrade database query performance and create untracked configuration drift.

For more information regarding this app, please refer to the knowledge base here.

Key Features

• Lists MySQL database tables with total column counts and single or multi-field schema filtering options.
• Displays total index counts per table with dedicated detail views for individual index names.
• Extracts column specifications across schemas into searchable list views.
• Compares total table, index, and column counts side-by-side across development, user acceptance testing, and production environments.
• Exports schema metadata and table structures to CSV, Excel, XML, and PDF files.

Frequently Asked Questions

How does DB Schema App compare database schemas across different environments?
Database Schema Comparison and Audit Tool tracks table totals, index counts, and column counts across separate target database instances, displaying summary metrics side-by-side to identify schema discrepancies between development and production environments.

Which database platforms and Joget versions are compatible with DB Schema App?
DB Schema App supports MySQL database schemas running on Joget DX 8 Enterprise and Professional editions. Complete setup instructions live in the DB Schema App Documentation.

Can database administrators export schema reports from Database Schema Comparison and Audit Tool?
DB Schema App exports schema metadata, table lists, index counts, and column details directly into CSV, Excel, XML, and PDF formats for compliance reviews and offline audits.