Advanced Guide Overview
Welcome to the DDLBuilder Advanced Guide. This section is designed for engineering leads, database architects, and power users tackling complex modeling, schema governance, workflow automation, and cross-team collaboration.
Topic Directory
| Topic | Core Capabilities & Key Benefits | Guide Link |
|---|---|---|
| Database delivery tools | Multi-table dictionaries, SQL snapshot comparison, and related test rows | Database Tools |
| Import & Parsing | Reverse-engineer existing SQL, CSV, Excel, or JSON Schema into editable structures | Import and Parse SQL |
| WebMCP Agent Integration | Connect browser-based AI agents to safely inspect, lint, and patch active schemas | WebMCP Agent Workflow |
| AI-Assisted Modeling | Conversational table generation, step-by-step patch reviews, and smart comments | AI-Assisted Table Design Workflow |
| SQL Review & Explanation | Architectural quality audits, risk detection, actionable tips, and SQL explanations | Review and Explain SQL |
| Partitioning & Sharding | Multi-strategy MySQL/TiDB partitioning and PostgreSQL Citus distributed tables | Partitioning and Sharding |
| Diff & Rollback | Visual schema diffing, forward ALTER migration scripts, and rollback DDL | Change Diff and Rollback |
| Relational Modeling & ER | Model physical foreign keys and logical relationships with cardinality, optionality, and business descriptions | Foreign Key Configuration and ER Diagram |
| Field Standards & Business Dictionary | Define standard fields, link business concepts, check saved tables for deviations, and import or export the library | Field Standards and Business Dictionary |
| ORM Generation | One-click code generation for Prisma, TypeORM, SQLAlchemy, GORM, and JPA | ORM Model Generation |
| Advanced Database Objects | CREATE VIEW statements and skeleton code for procedures, functions, and triggers | View and Routine Configuration |
| Schema Governance & Linting | Built-in linter detecting naming violations, type hazards, and redundant indexes | Schema Lint |
| Testing & Metadata | Realistic mock test data generation and visual color-badged logical enums | Mock Data and Logical Enums |
| Domain Blueprints | Production-grade business templates (User, Order, Audit Log, etc.) | Table Blueprint Templates |
Recommended Learning Paths
- Legacy Migration: Start with Import and Parse SQL to bring existing DDL into your workspace.
- Data Architecture: Combine Foreign Key Configuration and ER Diagram with Table Blueprint Templates to build cohesive domain models.
- Quality Assurance: Run Schema Lint and Review and Explain SQL prior to production rollout.
- Change Management: Leverage Change Diff and Rollback to prepare rollout and contingency scripts.