Master Greenplum with DbSchema: Database Design Simplified

DbSchema is a visual Greenplum client and management tool that simplifies the work with databases. Teams can design the database schema using the design model, can share the design model using GIT, and deploy the design in multiple databases. With its diagram-oriented GUI interface, users can easily create, edit, and visualize database schemas, generate SQL scripts, explore and query the data, generate random data, build reports and more.

Download DbSchema Editions
DbSchema Database Designer
Database Schema Design Tool

Design Complex Greenplum Databases

After connecting to the database, DbSchema will reverse engineer the Greenplum database structure in its model and visualize it graphically. You will interact with the schema using layouts (diagrams). The layouts can handle large databases with more than 10.000 tables. The graphical interaction will help to improve the database design.

Design the schema in a Team. Deploy the schema on multiple Greenplum servers.

The DbSchema model refers to the representation of a database schema within the DbSchema application.
DbSchema model is using its copy of schema structure, independent from the Greenplum database.
This is a separation between schema design and the database, with numerous advantages:

  1. Manage Multiple Databases

    Compare and deploy the database schema on multiple Greenplum databases. Incremental changes can be applied.

  2. Model File

    Save the design model including the schema structure to model file, as XML text. The model file can be open from any computer, without Greenplum connectivity.

  3. Design in Team

    The model file can be stored in GIT and shared in a team. Each team member can modify it and commit model changes in GIT. Database administrators can deploy the schema changes on testing or production databases.

  1. Generate Migration Scripts

    Generate migration scripts from one version of the schema to another by comparing two different model files with two versions of the same schema.

  2. Design Offline

    Schema can be designed offline, without database connectivity.

Read More
DbSchema Project File

Design Greenplum Schema Visually. Generate HTML5 Documentation

In DbSchema, layouts refer to the visual arrangements and configurations of various components within the application's workspace. Layouts help users organize their work by defining the positioning and visibility of elements such as database diagrams, SQL editors, query results, and other tool windows. DbSchema offers different predefined layouts, such as Design, Query, and Reports, which can be customized and saved based on individual preferences and project requirements. These layouts allow users to switch between different views and focus on specific tasks or aspects of their database work.

Tables and columns can be edited directly in the layouts. The layouts will be saved as model file. Comments can be added to each table or column and Greenplum interactive HTML5 or PDF documentation can be generated.

Read More

Greenplum Schema Documentation

Relational Data Editor: Easy Visualize Data

An amazingly simple Greenplum data editor and editor that offers simultaneous views of data from multiple tables, and features numerous filters, data sorting mechanisms, and much more. The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables. If the schema is missing foreign keys you can create virtual foreign keys that will be part of the DbSchema model.

Read more

Database Data Editor

Discover the Tools for Greenplum

Download DbSchema Purchase
DbSchema Video Presentation

Free Trial

Free download & evaluate DbSchema for 15 days.

Technical Support

Every user will benefit from full technical support.

All Databases Included

With a one license you can connect to every SQL, NoSQL or Cloud database

Money Back Guarantee

Not happy with DbSchema? 30 days after your purchase you can claim your money back.

Satisfied Customers