Introduction

This article features the DB Schema app created by Mokxa Technologies, LLC. The DB Schema App is designed to help users efficiently analyze and compare database
structures across different environments. It provides a comprehensive view of database
schemas, including tables, indexes, and column details. The app enables users to filter
schema information, extract insights, and export data in various formats. Built on Joget, it
ensures seamless integration with MySQL databases. This tool is particularly useful for
database administrators, developers, and system architects managing schema migrations
and migrations and consistency checks.

Key Features

• Improved database governance through consistent database environments.
• Quick and easy schema audits for analysis, debugging, and compliance checks.
• Minimize schema-related issues and performance bottlenecks to minimize downtime.
• Configurable with MySQL and multiple databases (coming soon in future release).
• Streamlines migration and improves deployment between development, staging, and
  production environments with better governance.

Prerequisite

This plugin requires Joget DX Enterprise version.

Steps to install

1. Navigate to the Joget Marketplace and search for DB Schema App.
2. Click Download.
3. Open App Center > Import App and click Choose File.
4. Select the DB Schema App and click Upload.
5.  Launch the App Composer and click Publish to publish the app.
6. In the App Center, open the DB Schema App.

Usage

Table List

The Table List provides an overview of the database schema by displaying:

...

• Database Schema: Select a schema to view only tables from that specific database.
• Table Name: Search for a particular table within the selected schema.

Index Count

The Index Count list provides insights into indexing, which is crucial for performance optimization. This list is useful when analyzing how indexes are structured across different environments. It displays:

...

The View Index column provides a clickable link that redirects you to a detailed view of index names for the selected table.

Sample index:

 Column Details

The Column Details list allows users to drill down further into table structures by showing:

...

A hyperlink column called View Columns enables users to click on a table name and navigate to a detailed list displaying all column names for that table.

Video Tutorial

Download Sample App

• Download the app for DB Schema App

Credits

This sample app and documentation are created by Mokxa Technologies, LLC.