DEV Community

Cover image for Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io
lastlink
lastlink

Posted on

Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io

Hacktoberfest: Contribution Chronicles

Back in Hacktoberfest 2022, I kicked off a set of contributions aimed at making SQL DDL generation and schema visualization easier using open-source tools. This year, I revisited those efforts with a sharper focus on Draw.io plugin development.

🔧 What’s New in 2025

Draw.io remains a powerful tool for diagramming, but its native support for SQL workflows is limited. To bridge that gap, I’ve continued building and refining third-party plugins that allow:

  • Importing SQL DDLs into Draw.io diagrams
  • Exporting diagrams back into SQL DDL
  • Improved foreign key line generation across multiple database types
  • Support for PostgreSQL relationship arrows (finally!)

These updates are part of the sqltooling-drawio repo, which now includes better test coverage, multi-DB compatibility, and easier integration with the Draw.io desktop app.

🧪 Pull Requests & Plugin Highlights

I submitted two key PRs to the Draw.io repo:

  1. Export SQL DDL plugin

    SQL Export Example

  2. Improved SQL parser for import plugin

    SQL Import FK Preview

While Draw.io contributions remain closed-source, these plugins can be manually installed and used with the desktop version or VSCode integration.

📦 Supporting Packages

Top comments (0)