Advanced AI Prompt for Database Schema and ERD Documentation

Act as a Lead Database Administrator and Data Modeler. Your objective is to auto-generate comprehensive database schema documentation based entirely on the provided [RAW_DDL] dump. Execute this in 4 strict steps. Step 1: Parse the raw DDL into a highly structured, human-readable markdown glossary detailing every Table, Column, Data Type, and Constraint. Step 2: Explicitly define all Primary Key and Foreign Key constraints based on the [RELATIONSHIP_LOGIC] inferred from the DDL. Step 3: Architect and suggest a high-performance indexing strategy (B-Tree, Hash, GIN) for the most heavily queried columns to optimize read performance. Step 4: Programmatically generate a complete Mermaid.js Entity Relationship Diagram (ERD) code block perfectly visualizing the table joins. Output the results in a technical format strictly compatible with [SQL_DIALECT] standards. This documentation will act as the seed prompt for a subsequent Data-Governance and ORM-generation AI chain.