Turn MarkLogic TDE Views into Relational Diagrams

Build a clearer workflow for MarkLogic: 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 MarkLogic Features Download MarkLogic JDBC Driver · All drivers

Multi-Model Architecture: Forests, Databases, and HTTP Servers

MarkLogic is an enterprise multi-model database that unifies document storage, full-text search, RDF triple store graph queries, and relational-style row access through the Optic API in a single platform. Storage is organized into forests — physical on-disk partitions that hold document fragments — which are attached to named databases. Applications connect to databases through HTTP Application Servers, each configured with a port, authentication scheme, and default query evaluator (XQuery or JavaScript). DbSchema connects to MarkLogic via the MarkLogic XCC connector and introspects the row-view schema exposed by the Optic API, rendering the TDE (Template-Driven Extraction) view definitions as schema diagrams. This gives teams a visual representation of the relational projection layered over MarkLogic's document content.

Download DbSchema Free See MarkLogic Features

Writing Optic API and SQL Queries in the SQL Editor

MarkLogic's Optic API exposes a SQL-compatible interface over TDE views, allowing standard SELECT, JOIN, and aggregation queries to be executed against document content that has been projected into a relational schema via TDE templates. DbSchema's SQL editor connects over the Optic SQL endpoint and provides auto-completion for TDE view names and column names, making it straightforward to write queries that join projected document fields without learning XQuery. For users working with MarkLogic's SPARQL graph queries, the editor also supports submitting SPARQL statements against the configured triple store, enabling exploration of RDF triples alongside tabular Optic queries in the same session.

Browsing Document Collections and Relational Data

The DbSchema data explorer lets you browse rows from MarkLogic TDE views interactively, applying filter and sort operations that translate to Optic API row queries under the hood. This provides a familiar relational browsing experience over what is fundamentally a document store, making it easy for data engineers to validate that TDE templates are projecting the correct fields from the underlying JSON or XML documents. For bitemporal MarkLogic databases, the explorer surfaces the system and valid time columns exposed by the bitemporal template, allowing time-travel queries to be executed directly from the data explorer interface.

How to Connect DbSchema to MarkLogic

MarkLogic's connector setup is a little more involved than a typical JDBC hookup, since the driver and TDE templates need to be in place first.

1. Install DbSchema, then open the driver manager and register the MarkLogic XCC connector JAR (driver class com.marklogic.xcc.spi.XccDriver).
2. Create a connection and choose MarkLogic as the database type.
3. Enter the host and the HTTP Application Server port — 8000 by default — together with the target database name; DbSchema forms the URL jdbc:marklogic://localhost:8000/Documents (substituting your own database for Documents).
4. Authenticate with a MarkLogic admin or application-user account that holds document and Optic API privileges.
5. Connect — DbSchema introspects the TDE view definitions and builds the schema diagram.

For HTTPS-enabled application servers, point the connection at the HTTPS listener port and append the relevant SSL parameters. DbSchema can only introspect schema objects once at least one TDE (Template-Driven Extraction) template has been deployed to the target database.

Why Teams Use DbSchema with MarkLogic

• Visualize MarkLogic TDE view schemas as relational diagrams to communicate the document-to-relational projection to SQL-oriented data consumers.
• Write and test Optic API SQL queries against TDE views in DbSchema's SQL editor with column name auto-completion, reducing reliance on XQuery expertise.
• Browse projected document data in the data explorer to validate TDE template correctness after updating document schemas or ingestion pipelines.
• Generate schema documentation for MarkLogic TDE views and RDF graphs to support data governance and compliance programs.
• Manage connections to multiple MarkLogic databases and HTTP Application Servers from a single DbSchema project file.
• Use DbSchema's offline schema model to design new TDE view templates and review them with the team before deploying to MarkLogic.

Curious what your MarkLogic TDE views look like as a diagram? Download DbSchema and reveal the relational projection behind your document content without writing an Optic query first.

Related databases

Teams working with MarkLogic often use these engines too. Explore dedicated guides and JDBC setup for each.

• Cassandra
• Couchbase
• CrateDB
• DynamoDB
• Elasticsearch
• Kafka

Browse all 100+ supported databases