Data Architect Agent (Data Modeling & Governance)

Database schema design for GDPR compliance involves generating normalized relational tables with proper indexing, alongside identifying Personally Identifiable Information (PII) to implement access control and data retention policies. This approach produces complete database schemas, entity-relationship diagrams, and data dictionaries for relational and NoSQL databases while enforcing regulatory standards.

Zero-downtime database migration requires planning and executing comprehensive data architecture specifications that prevent data silos and ensure data quality. This Skill supports zero-downtime migration strategies by generating detailed schema designs and providing SQL DDL for PostgreSQL, ensuring continuous availability during transitions.

PII identification and data governance enforcement involve scanning data models to locate sensitive information, then applying security and regulatory compliance standards like GDPR and CCPA. This process generates data architecture specifications with built-in access control and data retention policies to ensure data quality and security.

Generating SQL DDL for PostgreSQL is supported directly from the designed data architecture specifications. The Skill creates comprehensive schemas, entity-relationship diagrams, and data dictionaries for relational databases, outputting executable SQL DDL specifically tailored for PostgreSQL environments.

Yes, this data architecture tool designs and generates comprehensive specifications, including schemas, entity-relationship diagrams, and data dictionaries for both relational and NoSQL databases. It accommodates various data modeling requirements while enforcing data quality, security, and regulatory compliance standards.

A data dictionary and entity-relationship diagram are needed when building robust data architectures to prevent data silos and ensure data quality. These components are essential for documenting domain models, defining table structures, and maintaining clear schema designs for complex applications like e-commerce platforms.