DEV Community

Ekong Ikpe
Ekong Ikpe

Posted on

Gnoke DataForge — An Offline Schema Builder for Vibe Developers

#devchallenge #weekendchallenge #showdev

DEV Weekend Challenge: Community

title: Gnoke DataForge — An Offline Schema Builder for Vibe Developers
published: true

tags: devchallenge, weekendchallenge, showdev

This is a submission for the DEV Weekend Challenge: Community

The Community

Vibe developers — people who ship fast with AI assistants like Claude, Cursor, or ChatGPT.

One thing I've learned after years of building: when you hand an AI assistant a well-structured schema upfront, it hallucinates less, asks fewer clarifying questions, and produces far better code. But there was no lightweight, offline-first tool to quickly model a table and export it in AI-ready formats. So I built one.

What I Built

Gnoke DataForge — a browser-based relational schema modeler that runs 100% offline.

You open it, design your tables visually, define column types and constraints (PK, NOT NULL, UNIQUE), and export in formats your AI assistant can immediately use:

  • .json — flat data format
  • .entity.json — structured entity format ideal for pasting into AI prompts
  • .sql — CREATE TABLE + INSERT statements
  • .sqlite — a real binary SQLite database file
  • .csv — universal fallback

Projects are saved locally via IndexedDB. No account. No server. No telemetry.

Demo

🔗 Live: https://edmundsparrow.github.io/gnoke-dataforge

Open it, edit the demo table, switch to SQLite mode to define types and constraints, then hit Export — all without leaving the browser.

Code

GitHub logo edmundsparrow / gnoke-dataforge

A professional, offline-first relational modeling tool for vibe builders

🔥 Gnoke DataForge

Offline relational modeling tool for builders.

Structured. Portable. Private.

What It Does

  • Design and edit relational tables
  • Model schemas before backend implementation
  • Export as JSON, SQL, SQLite (.db), or CSV
  • Save projects locally using IndexedDB
  • Works completely offline

No accounts. No servers. No tracking.

Live Demo

https://edmundsparrow.github.io/gnoke-dataforge

Run Locally

git clone https://github.com/edmundsparrow/gnoke-dataforge.git
cd gnoke-dataforge
python -m http.server 8080
Enter fullscreen mode Exit fullscreen mode

Open:

http://localhost:8080

⚠ Always run through a local server. Do not open the HTML file directly.

Privacy

All data stays inside your browser.

  • No external database
  • No telemetry
  • No ads

Export anytime to keep your models portable.

Tech Stack

  • SQLite (sql.js WebAssembly)
  • IndexedDB
  • HTML · CSS · Vanilla JavaScript

License

GNU General Public License v3.0 — See LICENSE for details.

Edmund Sparrow © 2026 — Gnoke Suite


View on GitHub


How I Built It

The entire app is vanilla HTML, CSS, and JavaScript — no framework, no build step.

  • SQLite in the browser via sql.js (WebAssembly) — handles .sqlite export and import
  • IndexedDB for local project persistence — each saved table is stored as a real SQLite binary blob
  • A custom JSON normalizer that accepts multiple JSON shapes (array of objects, entity format, flat arrays) so importing from AI-generated output just works
  • Light/dark theme, mobile drawer, and a skip-intro toggle for repeat visits

The design prioritizes speed: open → build → export → paste into AI. That's the whole loop.

Top comments (0)