Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io

Developer Tools

Explore the latest advancements in SQL tooling for Draw.io with new plugins from Hacktoberfest 2025. Discover improved DDL import/export, foreign key generation, and PostgreSQL support.

Hacktoberfest: Contribution Chronicles

Back in Hacktoberfest 2022, I initiated a series of contributions focused on simplifying SQL DDL generation and schema visualization using open-source tools. This year, I've revisited those efforts with a refined strategy, emphasizing the development of plugins for Draw.io.

🔧 What’s New in 2025

Draw.io continues to be a robust platform for diagramming, yet its native capabilities for SQL workflows are somewhat limited. To enhance this, I've persistently developed and improved third-party plugins that enable:

  • Importing SQL DDLs directly into Draw.io diagrams.
  • Exporting diagrams back into SQL DDL format.
  • Enhanced foreign key line generation across diverse database types.
  • Finally, support for PostgreSQL relationship arrows!

These latest updates are integrated into the sqltooling-drawio repository, which now boasts improved test coverage, multi-database compatibility, and streamlined integration with the Draw.io desktop application.

🧪 Pull Requests & Plugin Highlights

I submitted two significant Pull Requests to the Draw.io repository:

  1. Export SQL DDL plugin
  2. Improved SQL parser for import plugin

While direct contributions to Draw.io itself remain closed-source, these specialized plugins can be manually installed and utilized with the desktop version or through its VSCode integration.

📦 Supporting Packages

The development is supported by:

  • @funktechno/sqlsimpleparser: A package designed to convert SQL DDL into JSON models, facilitating seamless import into Draw.io.