Database Logo

Schema Analyzer AI Powered

Version {{ appVersion }}

1. Upload DDL File *

Required (e.g. DDL_sample.sql)

{{ ddlFileName }}

2. Upload Table Focus

Optional (CSV for filtering)

{{ csvFileName }}

Your files stay on this device.

DDL and CSV files are read in your browser and remembered in local storage only. Nothing is uploaded to any server during upload or analysis.

{{ errorMsg }}

Schema Explorer

Matches: {{ filteredTables.length }} / {{ tables.length }} Tables

Active: T{{t}} L{{l}} Leaves Focus List {{ f }}
{{ table.name }}
{{ formatGroupBadge(table.group) }} L{{ table.depth }} T{{ table.tier }}
F {{ key.substring(0, 3).toUpperCase() }}
{{ getDynamicChildCount(table.name) }} {{ getDynamicDescendantCount(table.name) }}

No tables match filters

{{ formatGroupBadge(selectedTable.group) }} No Group Tier {{ selectedTable.tier || '?' }} Level {{ selectedTable.depth }}

{{ selectedTable.name }}

Focus Table {{ key }}

Parents

Direct{{ ancestorStats.direct }}
Ancestors{{ ancestorStats.total }}
Depth{{ selectedTable.depth }}
{{ p }}
No Parent Tables found

Children

Direct: {{ getDynamicChildCount(selectedTable.name) }} Total: {{ getDynamicDescendantCount(selectedTable.name) }}

Leaf Node

{{ activeFilterCount > 0 ? 'No child tables match filters' : 'No tables reference this table' }}

Select a table to analyze

or use the AI Chat button for global queries

Module Versions

{{ name }} {{ ver }}

Data Dictionary: {{ selectedTable?.name }} FOCUS {{ key }}

# Column Type Attributes Unique Key Not Null FK Reference Default
{{ idx + 1 }} {{ col.name }} {{ col.type }} PK FK UQ
{{ uq.name }} ({{ uq.columns.join(', ') }})
- 		{{ col.notNull ? 'Yes' : '' }} {{ col.fkTarget }} {{ col.defaultVal || '-' }}
Parsing failed or no columns found.

Triggers & Bound Functions

  • {{ trig.event }} {{ trig.name }}
    executes {{ trig.func }}({{ trig.args }}) 
    {{ trig.body }}
No triggers found for this table.

Mock Data Generator

Generates complete INSERT statements for {{ selectedTable?.name }} (All required fields). Includes parent records.
{{ mockDataSql }}

Column Impact Analysis

Filter (AND):

Impact Hierarchy Total: {{ filteredImpactCount }} / {{ totalImpactCount }} Tables

No tables found containing this column.

Matches found, but hidden by current filters.

Search to see which tables contain a specific column.

SQL Generator

{{ generatedSql }}

Cannot generate automatic JOIN path.

Logic: Attempts to join to application table.

AI Assistant

Ask me anything about your schema structure.

e.g., "Where is customer address stored?", "Explain the relationship between Order and Product"

Note: I will prioritize your DDL but can also answer general DB questions. (History limited to 100 messages)

{{ msg.text }}
Thinking...

Sample Result (AI Generated)

ER Diagram

Filtered: {{ filteredTables.length }} tables
Pan Zoom
Level Zones
L0 (Root)
L1
L2
{{ appSignature }}