Qwen2.5-VL-Diagrams2SQL-v2

Qwen2.5-VL-Diagrams2SQL

A fine-tuned Qwen2.5-VL-3B-Instruct model specialized for converting database schema diagrams into structured JSON format. This model dramatically improves upon the base model's ability to understand and extract information from ER diagrams, database schemas, and other structured database documentation.

Model Details

Model Description

This model addresses a common pain point in database documentation and migration projects: manually transcribing database schema diagrams is time-consuming and error-prone. While the base Qwen2.5-VL model struggled with structured diagram interpretation (often missing tables, incorrectly identifying relationships, or producing malformed outputs), this fine-tuned version shows significant improvements across all metrics.

The model uses LoRA (Low-Rank Adaptation) for parameter-efficient fine-tuning, targeting attention layers for optimal performance while maintaining efficiency.

• Developed by: David Nguyen
• Model type: Vision-Language Model (Fine-tuned)
• Language(s): English
• License: Same as base model (Qwen2.5-VL-3B-Instruct)
• Finetuned from model: Qwen/Qwen2.5-VL-3B-Instruct

Model Sources

• Repository: GitHub Repository
• Base Model: Qwen/Qwen2.5-VL-3B-Instruct

Performance Improvements

The fine-tuned model shows significant improvements over the base model:

Uses

Direct Use

This model is designed to:

• Convert database ER diagrams to structured JSON schemas
• Extract table structures, column definitions, and relationships from visual diagrams
• Automate database documentation processes
• Assist in database migration and reverse engineering tasks

Supported Diagram Types

The model has been trained on diverse schema types including:

• E-commerce: Products, orders, customers, payments
• Healthcare: Patients, appointments, medical records
• Education: Students, courses, grades, enrollment
• Finance: Accounts, transactions, investments
• IoT/Social Media: Users, posts, device data

Out-of-Scope Use

• Not suitable for non-database diagrams (flowcharts, network diagrams, etc.)
• Does not generate actual SQL DDL statements (outputs JSON schema only)
• Not trained for natural language database queries

How to Get Started with the Model

Installation

pip install transformers torch pillow

Basic Usage

from transformers import AutoProcessor, Qwen2_5_VLForConditionalGeneration
from PIL import Image
import torch
import json

# Load the fine-tuned model
model_id = "zodiac2525/Qwen2.5-VL-Diagrams2SQL-v2"
processor = AutoProcessor.from_pretrained(model_id)
model = Qwen2_5_VLForConditionalGeneration.from_pretrained(
    model_id, 
    torch_dtype=torch.bfloat16, 
    device_map="auto"
)

# Load your ER diagram
image = Image.open("path/to/your/diagram.png").convert("RGB")

# Prepare the input
messages = [
    {
        "role": "user",
        "content": [
            {"type": "image", "image": image},
            {"type": "text", "text": "Extract data in JSON format"}
        ]
    }
]

# Process and generate
text = processor.apply_chat_template(messages, tokenize=False, add_generation_prompt=True)
inputs = processor(text=[text], images=[image], return_tensors="pt").to("cuda")

# Generate schema
with torch.no_grad():
    generated_ids = model.generate(
        **inputs,
        max_new_tokens=1024,
        do_sample=False,
        temperature=0.0
    )

# Extract and parse JSON
generated_text = processor.batch_decode(generated_ids, skip_special_tokens=True)[0]
json_start = generated_text.find('{')
if json_start != -1:
    schema_json = json.loads(generated_text[json_start:])
    print(json.dumps(schema_json, indent=2))

Expected Output Format

The model outputs JSON schemas in the following structure:

{
  "tables": [
    {
      "name": "users",
      "columns": [
        {
          "name": "id",
          "type": "INT",
          "constraints": ["PRIMARY KEY", "AUTO_INCREMENT"]
        },
        {
          "name": "email",
          "type": "VARCHAR(255)",
          "constraints": ["UNIQUE", "NOT NULL"]
        }
      ]
    }
  ],
  "relationships": [
    {
      "from_table": "orders",
      "from_column": "user_id",
      "to_table": "users",
      "to_column": "id",
      "relationship_type": "FOREIGN KEY"
    }
  ]
}

Training Details

Training Data

The model was fine-tuned on a custom dataset of 400+ database schema diagrams with corresponding JSON annotations, covering various domains and complexity levels.

Training Procedure

Fine-tuning Method: LoRA (Low-Rank Adaptation)

• LoRA Rank: 16
• LoRA Alpha: 32
• Target Modules: q_proj, v_proj, k_proj, o_proj (attention layers)

Training Hyperparameters:

• Learning Rate: 1e-4
• Batch Size: 4
• Gradient Accumulation Steps: 8
• Max Epochs: 8
• Optimizer: AdamW
• Weight Decay: 0.01
• LR Scheduler: Cosine
• Mixed Precision: bf16

Training Infrastructure

• Framework: PyTorch with Transformers
• Experiment Tracking: Comet ML
• Hardware: GPU-optimized training setup

Evaluation

The model was evaluated on a held-out test set using multiple metrics:

• Table Detection Accuracy: Percentage of correctly identified tables
• Relationship Accuracy: Percentage of correctly identified relationships
• JSON Format Compliance: Percentage of valid JSON outputs
• Overall Schema Score: Composite metric combining all aspects

Bias, Risks, and Limitations

Limitations:

• Performance may vary with diagram quality, resolution, and formatting
• Best results achieved with clear, well-structured diagrams
• May struggle with hand-drawn or heavily stylized diagrams
• Limited to database schema diagrams (not general-purpose diagram understanding)

Recommendations:

• Use high-quality, clear diagram images for best results
• Verify generated schemas for critical applications
• Consider the model as an assistive tool rather than fully automated solution

Technical Specifications

Model Architecture

• Base Architecture: Qwen2.5-VL (Vision-Language Model)
• Vision Encoder: Processes input images to visual tokens
• Language Model: Qwen2.5 transformer backbone
• Multi-modal Fusion: Integrates visual and textual representations

Compute Requirements

• Minimum VRAM: 8GB (for inference)
• Recommended: 16GB+ for optimal performance
• CPU Inference: Supported but slower

Framework Versions

• PEFT: 0.16.0
• Transformers: 4.49.0+
• PyTorch: 2.0+
• Python: 3.8+

Citation

If you use this model in your research or applications, please cite:

@misc{qwen25vl-diagrams2sql,
  title={Qwen2.5-VL-Diagrams2SQL: Fine-tuned Vision-Language Model for Database Schema Extraction},
  author={David Nguyen},
  year={2024},
  howpublished={\url{https://huggingface.co/zodiac2525/Qwen2.5-VL-Diagrams2SQL-v2}}
}

Model Card Contact

For questions, issues, or collaboration opportunities, please:

• Open an issue on the GitHub repository
• Contact via Hugging Face model discussions