Design and Manage Salesforce Databases with DbSchema
Build a clearer workflow for Salesforce: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built 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
What happens after you download?
Get to your first Salesforce schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to Salesforce or open a sample
Reverse engineer an existing Salesforce database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Connecting DbSchema to Salesforce
Use the CData Salesforce JDBC driver or the Simba Salesforce JDBC driver
to connect DbSchema. For the Simba driver, the JDBC URL format is:
jdbc:salesforce:[email protected];Password=password;SecurityToken=token.
The Security Token is generated from your Salesforce profile settings under "Reset My Security Token."
For Connected App authentication, replace the username/password combination with OAuth parameters
(Consumer Key and Consumer Secret). Add the JDBC driver JAR via DbSchema's driver manager under
Connections > Manage Drivers.
DbSchema also provides its own open-source Salesforce JDBC driver — source code available on
GitHub.
Why DbSchema for Salesforce
- 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