| Table of Contents |
|---|
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.
...
- Navigate to the Joget Marketplace and search for DB Schema App.
- Click Download.
- Open App Center > Import App and click Choose File.
- Select the DB Schema App and click Upload.
- Launch the App Composer and click Publish to publish the app.
- 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
...