Skills understanding-db-schema
📦

understanding-db-schema

v1.0.0 Content revision r2 Safe ⚙️ External commands🌐 Network access

Understand Logseq Database Schemas

Logseq database concepts can be difficult to connect across entities, classes, properties, and validation. This skill explains the Datascript model and provides practical schema templates.

Supports: Claude Codex Code(CC)
🥈 81 Silver

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "understanding-db-schema" from https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema.md and its manifest at https://skillstore.io/api/skills/c0ntr0lledcha0s-understanding-db-schema/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/c0ntr0lledcha0s-understanding-db-schema.md Signed manifest GET /api/skills/c0ntr0lledcha0s-understanding-db-schema/manifest Signed lockfile GET /api/skills/c0ntr0lledcha0s-understanding-db-schema/lockfile

Test it

Using "understanding-db-schema". Explain how pages and blocks relate in a Logseq DB graph.

Expected outcome:

  • Pages and blocks share a unified node model.
  • Parent and page references place blocks within a hierarchy.
  • Tags and references connect nodes to classes and related entities.

Using "understanding-db-schema". Recommend a property model for one rating from one to five.

Expected outcome:

  • Use a numeric property with single-value cardinality.
  • Restrict accepted values to the five allowed ratings.
  • Associate the property with each class that needs rating validation.

Using "understanding-db-schema". Review a Book class that should contain authors and one publication date.

Expected outcome:

  • Extend the shared root class and use a stable user-class identifier.
  • Model authors as multiple node references when several authors are allowed.
  • Model publication date as a single date property.

Security Audit

Safe
v9 • 7/23/2026 Open versioned report

All 41 static findings are false positives caused by schema terms, Markdown backticks, code fences, and reference links. The reviewed files contain documentation and inert templates, with no command execution, reconnaissance, network requests, or prompt injection.

4
Files scanned
441
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (35)
SKILL.md:23 SKILL.md:25 SKILL.md:38-52 SKILL.md:52-56 SKILL.md:56-62 SKILL.md:62-66 SKILL.md:66-77 SKILL.md:77-79 SKILL.md:79 SKILL.md:85 SKILL.md:86 SKILL.md:87 SKILL.md:88 SKILL.md:89 SKILL.md:90 SKILL.md:91 SKILL.md:92 SKILL.md:96-105 SKILL.md:105-111 SKILL.md:111 SKILL.md:112 SKILL.md:113 SKILL.md:114 SKILL.md:115 SKILL.md:119-126 SKILL.md:126-132 SKILL.md:132-133 SKILL.md:133-135 SKILL.md:135 SKILL.md:136-144 SKILL.md:144-154 SKILL.md:154-166 SKILL.md:166-176 SKILL.md:176-180 SKILL.md:180-187
🌐 Network access (3)
SKILL.md:192 SKILL.md:193 SKILL.md:194
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema/audits/9?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/c0ntr0lledcha0s-understanding-db-schema/security.svg)](https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/c0ntr0lledcha0s-understanding-db-schema/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/c0ntr0lledcha0s-understanding-db-schema.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

C0ntr0lledCha0s. (2026). understanding-db-schema security audit report (audit version 9) [Author version 1.0.0]. Skillstore. https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema/audits/9

BibTeX citation

@techreport{c0ntr0lledcha0s-c0ntr0lledcha0s-understanding-db-schema-2026, author = {C0ntr0lledCha0s}, title = {understanding-db-schema security audit report (audit version 9)}, institution = {Skillstore}, year = {2026}, number = {9}, url = {https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema/audits/9}, note = {Author version 1.0.0} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "understanding-db-schema security audit report (audit version 9)" version: "1.0.0" type: report authors: - name: "C0ntr0lledCha0s" date-released: "2026-07-23" url: "https://skillstore.io/skills/c0ntr0lledcha0s-understanding-db-schema/audits/9" identifiers: - type: other value: "skillstore:c0ntr0lledcha0s-understanding-db-schema:audit:9" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
100
Maintainability
87
Content
71
Community
91
Spec Compliance

What You Can Build

Plan a Plugin Schema

Choose identifiers, property types, cardinalities, and relationships before implementing a Logseq plugin data model.

Review Graph Structure

Assess custom classes and properties for clear inheritance, valid references, and consistent naming.

Learn the DB Model

Connect Datascript concepts with Logseq pages, blocks, classes, properties, and validation behavior.

Try These Prompts

Explain the Basics 
Explain the Logseq Datascript schema to a beginner. Cover entities, attributes, values, references, and cardinality with one conceptual example.
Select a Property Type 
Compare Logseq property types for {property_goal}. Recommend a type and cardinality, then explain validation and closed-value implications.
Design a Custom Class 
Design a Logseq class named {class_name} with these properties: {properties}. Explain inheritance, identifiers, references, and validation constraints.
Audit a Proposed Schema 
Review this Logseq schema: {schema_description}. Identify relationship, cardinality, namespace, inheritance, migration, and validation risks. Suggest precise corrections.

Best Practices

  • State the Logseq version and whether the graph uses the DB model.
  • Describe expected cardinality and allowed values for every proposed property.
  • Validate identifiers, inheritance, and references before applying schema changes.

Avoid

  • Do not reuse example identifiers without adapting them to your namespace.
  • Do not treat pages and blocks as unrelated storage models.
  • Do not assume documentation examples automatically match the installed Logseq version.

Frequently Asked Questions

What Logseq model does this skill cover?
It covers Datascript-based Logseq DB graphs, including nodes, classes, properties, references, cardinality, and validation.
Can this skill inspect my live graph?
No. It provides analysis from supplied details but does not connect to or query a live graph.
Does it generate custom class designs?
Yes. It can propose class inheritance, property associations, identifiers, and cardinalities from your requirements.
Can it explain property validation?
Yes. It explains property types, closed values, cardinality handling, and the documented Malli validation flow.
Does it run Datalog queries or migrations?
No. It can explain query and migration concepts, but it does not execute database operations.
How should I handle version differences?
Provide your Logseq version and verify recommendations against current official documentation before changing a graph.

Developer Details

License

MIT

Author version

v1.0.0

Skillstore revision

r2

Repository

https://github.com/C0ntr0lledCha0s/claude-code-plugin-automations/tree/main/logseq-expert/skills/understanding-db-schema

Ref

a39a91716eadede5f4cdefd78178fed4e837a128

Maintenance freshness

7/24/2026

Usage

7 downloads · 291 views

File structure

📁 assets/

📄 class-template.edn

📄 property-template.edn

📁 references/

📄 built-in-classes.md

📄 SKILL.md