See Your Salesforce Org's Data Model on One Diagram

Connect DbSchema to Salesforce and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed for visual modeling, schema documentation, and deployment — keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Salesforce Features Download Salesforce JDBC Driver · All drivers

Visual Data Model Exploration for Salesforce Orgs

Salesforce's object model spans standard objects (Account, Contact, Opportunity), custom objects, and junction objects — often totaling hundreds of tables in a mature org. Understanding the full data model and how custom relationships connect these objects requires either the Schema Builder in Salesforce Setup or developer-level API access. DbSchema connects via the Simba or CData Salesforce JDBC driver, reads the object metadata, and renders the schema as an entity-relationship diagram that consultants and admins can explore and document offline.

Download DbSchema Free See Salesforce Features

ER Diagrams for Salesforce Standard and Custom Objects

DbSchema reads object metadata through the Salesforce JDBC driver and maps standard objects, custom objects, and their lookup and master-detail relationships onto an interactive diagram canvas. This is particularly useful for Salesforce architects documenting org-level data models for integration projects or system reviews.

Visual Query Builder for Salesforce Data

DbSchema's query builder lets you construct SOQL-compatible queries against Salesforce objects without writing raw SQL. Select objects, choose fields, and apply filters from a graphical interface — the query builder generates the corresponding SQL that the JDBC driver translates to SOQL internally.

Schema Documentation for Salesforce Consultants and Admins

DbSchema generates HTML documentation from the Salesforce object schema, capturing object names, field types, picklist values, and relationship definitions. This documentation is invaluable for Salesforce implementation teams handing off a customized org to a client, or for admins preparing change control documents for regulated environments.

From Download to Salesforce ER Diagram

Reading an org's object model into DbSchema follows this path:

1. Download and install DbSchema — no account is required to get started.
2. Pick either the CData Salesforce JDBC driver or the Simba Salesforce JDBC driver; register its JAR file from Connections > Manage Drivers, DbSchema's driver manager screen.
3. For the Simba driver, build a connection string of the form jdbc:salesforce:[email protected];Password=password;SecurityToken=token, where the Security Token comes from your Salesforce profile settings under "Reset My Security Token."
4. If your org uses a Connected App, swap the username/password pair for OAuth parameters (Consumer Key and Consumer Secret) instead.
5. Connect, and DbSchema reads the object metadata into an ER diagram you can explore and document.

DbSchema also ships its own open-source Salesforce JDBC driver as an alternative — the source code is available on GitHub.

Benefits of DbSchema for Salesforce Teams

• Visualize the full Salesforce data model including custom objects and relationships
• Generate documentation for Salesforce org schemas for consultant handoffs and audits
• Build SOQL-compatible queries visually without writing raw Salesforce SQL
• Compare object schemas between Salesforce sandbox and production orgs
• Work with the schema diagram offline after synchronizing the model from Salesforce

Give your Salesforce org the visual data model it's missing — download DbSchema for free and map every standard and custom object onto one diagram.