Duc
DocumentationBlogPlayground
SQL

Overview

Querying, mutating, and introspecting gzip-compressed SQLite .duc containers directly using standard SQL and FTS5 indexing.

A .duc file is a gzip-compressed SQLite database container. This allows physical-engineering applications, SDKs, and AI tools to query, inspect, and mutate project state using standard SQL.

Core Features

  • Relational Integrity: Foreign key constraints and WAL mode ensure atomic, safe transactions across elements, styles, symbol blocks, and DAG version history.
  • Selective Mutations: Execute targeted SQL UPDATE or INSERT queries directly against specified elements or attributes without re-serializing full documents.
  • FTS5 Full-Text Search: Instant full-text search indexing across element labels, text primitives, embedded documents, code models, and PDF text.

For full schema details and interactive entity-relationship diagrams, visit the SQL API Reference.

Edit on GitHub

Last updated on

AI Compatibility

Why the SQLite database container design and native Python adapter make .duc seamlessly compatible with foundation AI models.

API Reference

Next Page