DB Schema App

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 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: The name of the database/schema where the tables reside.
• Table Name: The name of each table within the selected database.
• Number of Columns: The total number of columns in each table.

Filters available:

• 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:

• Database Schema – The database or schema associated with the indexes.
• Table Name – The name of the table for which indexes exist.
•  Number of Indexes – The total number of indexes on each table

Filters available:

• Database Schema – Select a schema to view index details for tables in that database.
• Table Name – Search for a table to check its indexes.

Additional Feature:

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:

•  Database Schema: The schema in which the table resides.
•  Table Name: The name of the table being analysed.

This feature helps users compare column structures across different servers, ensuring consistency between environments.

Filters available:

•  Database Schema: Filter by schema to focus on specific database structures.
•  Table Name: Find details for a specific table.

Additional feature:

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.