Turn MarkLogic TDE Views into Relational Diagrams

MarkLogic unifies document storage, full-text search, and RDF triples in one platform, with the Optic API projecting documents into rows through TDE views. DbSchema connects through the MarkLogic XCC connector, introspects those TDE view definitions, and diagrams the relational layer over your document content.

Render TDE view definitions as ER-style schema diagrams
Write Optic SQL with autocomplete for view and column names
Browse projected rows to verify what each TDE template extracts
Document the projection for SQL-oriented consumers and governance

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema rendering MarkLogic TDE views as relational schema diagrams

Trusted by teams at

Analysts Ask for Tables
MarkLogic Answers in Documents

The richness of a multi-model platform — forests of documents, triples, full-text search — is exactly what makes it opaque to SQL-oriented consumers. TDE views bridge that gap, but the templates defining them are XML or JSON files, and whether a template projects the intended fields is hard to see from the template alone.

DbSchema shows the result: each TDE view drawn as a diagram, its rows one click away, its structure exportable as documentation for everyone downstream.

Introspect, Join & Verify
MarkLogic's Relational Layer

The row side of a document database, treated like a first-class schema.

Introspect MarkLogic TDE views into schema diagrams

TDE Views, Introspected

DbSchema connects over XCC and reads the row-view schema the Optic API exposes, laying out the view definitions as diagrams a SQL consumer can follow.

Build queries over MarkLogic TDE views without XQuery

Joins Without XQuery

Pick views, columns, and join paths in the visual builder and read the generated SQL — analysts query projected documents without learning a new language.

Browse MarkLogic TDE view rows in the data explorer

Template Output, Checked in Rows

Browse and filter the rows a TDE view returns to confirm each template projects the fields your ingestion pipeline promised.

The Projection, Published
as Browsable Documentation

Generate interactive HTML5 documentation of the TDE view schemas — views, columns, and relationships — for data governance programs and for every consumer who reads SQL rather than template XML. It opens in a browser, with zero MarkLogic access required.

Explore the Documentation Tool

HTML5 documentation of MarkLogic TDE view schemas generated by DbSchema

MarkLogic Connection: XCC Connector, Port, and Prerequisites

Register the MarkLogic XCC connector JAR in the driver manager — driver class com.marklogic.xcc.spi.XccDriver. Connect to the host and the HTTP Application Server port, 8000 by default, with the target database in the URL: jdbc:marklogic://localhost:8000/Documents. Authenticate as an admin or application user holding document and Optic API privileges; for HTTPS-enabled application servers, use the HTTPS listener port and the relevant SSL parameters.

One prerequisite: schema introspection becomes possible once at least one TDE template is deployed to the target database — the templates are what define the row views DbSchema reads. Driver setup details are on the MarkLogic JDBC driver page.