Design and Manage Amazon DocumentDB Databases Visually with DbSchema

DbSchema lets you design, manage, and document Amazon DocumentDB 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 Amazon DocumentDB 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 Download Amazon DocumentDB JDBC Driver

Amazon DocumentDB is AWS's managed MongoDB-compatible document database, designed for teams that need the MongoDB API without the operational burden of running their own replica set. Because DocumentDB collections are schema-flexible, understanding what fields actually exist in your data requires sampling documents — not reading a DDL file. DbSchema connects via the MongoDB JDBC driver, samples each collection to infer field names and BSON types, and renders the result as a navigable schema diagram.

Infer and Visualize Collection Schemas

DocumentDB collections don't enforce a fixed structure, so DbSchema samples a configurable number of documents per collection to discover the fields in active use. Inferred field names and their detected types are displayed in the diagram canvas, giving you a visual map of the document model without writing a single aggregation pipeline.

DbSchema showing inferred field types for an Amazon DocumentDB collection

Run MongoDB-Compatible Queries Without Writing Application Code

DbSchema's query builder constructs MongoDB-compatible find queries for DocumentDB, letting you filter and project documents interactively. Use it to verify that the document shape your application expects matches what is actually stored, or to explore production data without deploying a temporary script.

Query builder generating a MongoDB-compatible query against Amazon DocumentDB

Browse Document Data with the Data Explorer

The data explorer displays collection contents in a paginated grid with column-level filtering. This makes it practical to audit documents after a migration, cross-check field values against application expectations, or investigate anomalies in production without any custom tooling.

Data explorer browsing documents in an Amazon DocumentDB collection

Connecting to Amazon DocumentDB

Amazon DocumentDB uses the MongoDB wire protocol on port 27017. The connection URI takes the form: mongodb://username:[email protected]:27017/dbname?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0. Download the global-bundle.pem TLS certificate from the AWS documentation before connecting — DocumentDB requires TLS and rejects connections that omit the CA file. Because DocumentDB clusters run inside a VPC, you need either an SSH tunnel through a bastion host or a public-facing cluster endpoint to reach the database from outside AWS. Once the tunnel or endpoint is configured, register the MongoDB JDBC driver in DbSchema's driver manager and paste the URI into the connection dialog.

Why Use DbSchema with Amazon DocumentDB

  • Infer collection schemas by sampling documents — no manual DDL required
  • Visualize nested fields and array types in an ER-style diagram canvas
  • Run ad-hoc MongoDB-compatible queries without writing application code
  • Generate schema documentation for architecture reviews and team onboarding
  • Compare inferred schemas across environments to detect unintended field drift