Skip to main content

Database Designer overview

KAIZEN Database Designer is a visual tool that simplifies how you create and manage your application's database schema. Through an interactive interface, developers can easily define tables, columns, and data relationships without writing manual SQL scripts. For an overview of the data modeling concepts, supported databases, and generated artifacts, refer to Design the physical model.

In KAIZEN studio console, find your project and click Theme button to open the Database Designer.

Layout​

The designer is organised into a multi-column layout for efficient navigation and management.

  1. Navigation bar (Left): This slim vertical toolbar contains icons that act as the primary navigation for the designer. This includes options to switch between different views:

  2. Resources panel (Mid-left): The content in this panel is dynamic and changes based on the selection in the Navigation Bar.

  3. Main workspace (Centre): This is the largest and primary work area where all major tasks are performed. The content here is contextual. It can display:

    • Table data: A grid view of the rows and columns when the user opens a table.
    • Query console: An editor to write, execute, and save raw SQL scripts.
    • Table editor: A visual interface for creating or modifying a table's structure.

  4. Information panel (Right): This panel provides supplementary information and tools related to the activity in the main workspace. It contains several tabs:

    • Info: Displays contextual information about the selected item.
    • Executive logging: Shows a log of actions and queries that have been executed.
    • Saved console: Provides quick access to the previously saved SQL queries and scripts.

Workspace​

Click Workspace on the Navigation bar and select a connection from the dropdown to browse the database structure. The Resources panel displays a hierarchical view of all the database objects under that connection.

Browse database objects​

The tree structure organises the database objects in the following hierarchy:

  • Databases: The top-level nodes represent the available databases on the server.
  • Schemas: Each database contains one or more schemas.
  • Tables: Each schema contains its tables. Expand a table to view its columns, keys, and indexes.
  • Views: Lists all the views defined in the schema.
  • Functions: Lists all the user-defined functions.
  • Stored procedures: Lists all the stored procedures.
  • Triggers: Lists all the triggers defined in the schema.

Use the Search in the expand node search bar at the top of the Resources panel to quickly filter and locate specific objects within the expanded nodes.

Connections​

Click Connections on the Navigation bar to manage the database connections. When selected, the Resources panel displays a list of all configured connections.

Add a connection​

Refer to Connect to the database server for the step-by-step guide on creating a new database connection.

Test, modify, or cancel a connection​

  • Click Test to verify the connection to the database server before saving.
  • Click Modify to save the changes to the connection configuration.
  • Click Cancel to discard changes and close the form.

Last updated on 20 May 2026