Design and Manage Dataverse Databases Visually with DbSchema

DbSchema lets you design, manage, and document Dataverse databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Dataverse database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema

How to Connect to Dataverse

Retrieve environment host and make sure TDS endpoint is enabled

Open the Power Platform admin center at https://admin.powerplatform.microsoft.com/

The following instructions depend on whether you are using the old or the new UI.

Old UI

You know that you're using the old admin center UI if this toggle is off in the top toolbar: Toggle showing New Admin Center disabled.

In this case:

  1. Go to Environments in the left sidebar
  2. Click on an environment that has Dataverse enabled (it has Yes in the Dataverse column)
  3. Copy the host name of the environment from the Details panel (org63ec15e8.crm4.dynamics.com in this case):

    Environment URL (hostname)

  4. Choose Settings on the top toolbar
  5. Go to Product -> Features
  6. Enable TDS endpoint in the section with the same name:

    Toggle showing TDS endpoint enabled

New UI

You know that you're using the new admin center UI if this toggle is on in the top toolbar: Toggle showing New Admin Center enabled.

In this case:

  1. Go to Manage in the left sidebar
  2. Click on Environments
  3. Click on an environment that has Dataverse enabled (it has Yes in the Dataverse column)
  4. Copy the host name of the environment from the Details panel (org63ec15e8.crm4.dynamics.com in this case):

    Environment URL (hostname)

  5. Choose Settings on the top toolbar
  6. Go to Product -> Features
  7. Enable TDS endpoint in the section with the same name:

    Toggle showing TDS endpoint enabled

Connect from DbSchema

  1. Access the Connection Dialog

    Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

    DbSchema automatically downloads the JDBC driver to ensure a smooth connection to Amazon Athena.

  2. Configure the Connection
  3. In the Connection Dialog window, select the JDBC URL you want to connect with.

    Choose Microsoft Entra / Active Directory Interactive Multi-Factor Authentication if the authenticating user has MFA enabled. When attempting to connect, a browser window will be opened where you can input your MFA code.

    Choose Microsoft Entra / Active Directory User and Password if the authenticating user doesn't have MFA enabled.

    Enter the host name that you copied from the UI, the authentication details, and the database name as described in the Connection Dialog page.

    Connecta to Dataverse in DbSchema