skills.rest
tektonlabs
tektonlabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

data-model

Generates data model documentation with ER diagrams, data dictionaries, and PostgreSQL schema specifications.

Updated Aug 26, 2026
Search Tags:#architecture#postgresql#data dictionary#database schema#data model#deprecated#erd
One-click install
npx skills add https://github.com/tektonlabs/ai-software-design --skill data-model-tektonlabs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-model
Source: https://github.com/tektonlabs/ai-software-design/tree/main/.claude/skills/_deprecated/architecture/data-model
Command: npx skills add https://github.com/tektonlabs/ai-software-design --skill data-model-tektonlabs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? This Skill addresses the need for structured data model documentation during software design, covering entities, relationships, data dictionaries, and physical database schemas. Note: this Skill is deprecated and its content has been consolidated into Section 6 of the Software Architecture Document skill. ## Core Features & Use Cases - Conceptual and Logical Modeling: Produces Mermaid ER diagrams with entities, relationships, and cardinality definitions. - Data Dictionary Generation: Documents columns, data types, constraints, indexes, and status enumerations per entity. - Physical Schema Output: Generates PostgreSQL DDL including partitioning, indexing strategies, and referential integrity rules. - Use Case: A data architect documenting an e-commerce platform uses the template to define User, Order, and Product entities with full constraint and PII protection specifications. ## Quick Start Ask the agent to generate a data model document for your project, or note that this deprecated skill redirects to the software-architecture-document skill instead.

Frequently Asked Questions about data-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a data model document with ER diagrams?▼

Provide the project name, core business entities, relationships, data volumes, and compliance requirements as inputs. The skill produces conceptual and logical Mermaid ER diagrams plus a full data dictionary with constraints and indexes.

Is the data-model skill still active in the SDLC flow?▼

No, this skill is deprecated. Data model content is now consolidated into Section 6 of the Software Architecture Document skill, and invocations redirect to /architecture/software-architecture-document.

What inputs are required for data model documentation?▼

Required inputs are the requirements specification, business rules, and use cases from earlier SDLC skills. An architecture design document is recommended, and existing database schemas are needed when migrating legacy data.

Does the data model output include physical database schema?▼

Yes, the physical data model section targets PostgreSQL 15+ and includes CREATE TABLE statements, partitioning strategies, indexing approaches, and referential integrity rules with cascade behaviors.

How are PII and data privacy handled in the data model?▼

The template includes a PII identification table mapping fields to protection measures, data masking rules for fields like email and phone, and retention policies per data type such as accounts, orders, and audit logs.

Related Skills

Explore More Software Engineering Skills→
netcorepalnetcorepal
33

cleanddd-requirements-analysis

Identify stakeholders and tag requirements to business objects for modeling inputs.

Official
Intermediate
suriyelsuriyel
178

long-task-design

Generate technical design documents from approved SRS and UCD documents.

Community
Advanced
kernex-devkernex-dev
1

backend-architect

Design backend APIs, data models, and service architectures with endpoint contracts and auth rules.

Official
Advanced
MHD-Nour-KJMHD-Nour-KJ

Backend_Refactor (DEPRECATED)

Redirect users from a deprecated backend skill to current replacement skills.

Community
Basic