← Files ScoptureARCHIVED FILE

skills/duc/docs/sql/overview.md

867 Bytes · Nov 22, 2026 · 12:12 UTC

↓ Download file

# Overview (/docs/sql/overview)



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 [#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](/docs/sql/api).

SHA-256: 08eba7624473d24c6d49c205cb9306c338a9b9519d654764f4862c6fcbdda4f5