Database Designer – No-Code PostgreSQL Database Builder
This is a submission for the DEV's Worldwide Show and Tell Challenge Presented by Mux
What I Built
Database Designer is a standalone desktop application that lets you visually design PostgreSQL databases without writing a single line of code. Drag-and-drop tables, define columns, relationships, indexes, and more – then instantly generate:
- Complete, ready-to-run SQL scripts (schemas, tables, foreign keys, indexes)
- Clean Markdown documentation for your schema
- Entity Framework-compatible C# model classes
Everything runs 100% locally and offline, with built-in post-quantum-resistant encryption for project files via Pariah Cybersecurity v2.
It's fast, intuitive, and built to remove the tedium from database setup so you can focus on building features.
My Pitch Video
(A quick 1-minute demo showing the intuitive interface, schema creation, relationship building, and one-click exports to SQL, docs, and C# models.)
Demo
Live Product Page / Download for wishlisting: (https://store.steampowered.com/app/4098880/Database_Designer/) (Early Access)- (Please contact me at [email protected] for a Steam code for testing if you're a judge)
The Story Behind It
Database Designer started as an internal tool at Walker Industries to rapidly prototype and connect databases across ambitious projects like XRUIOS (an XR-focused shell OS) and Project Replicant (local high-functionality AI). Manually writing SQL, updating docs, and generating models was eating hours better spent on innovation.
I wanted a tool that felt easy to use – fast, local, secure, and powerful enough for real production work. What makes it special: full offline operation, post-quantum security, table/project templates for consistency, and zero cloud lock-in (cloud sync coming soon).
It's open-source planned, with a free SDK on the horizon.
Team credits:
- 🎨 Kennaness – beautiful, polished art assets
- 🛠️ jpena173 – backend optimizations and architecture
Ares – feature guidance
IiErickiI – invaluable UI/UX feedback
Technical Highlights
Tech Stack:
- C# /.NET for core logic and cross-platform potential
- Custom UI framework for smooth, responsive drag-and-drop canvas
- Pariah Cybersecurity v2 (open-source library by Walker Industries) integrating NIST-approved post-quantum algorithms (Kyber/CRYSTALS, AES-256) for encrypted local project storage
- One-click exporters for PostgreSQL DDL, Markdown docs, and EF Core-ready C# POCOs
Unique Aspects:
- Fully local execution – no internet needed, perfect for secure/air-gapped environments
- Built-in templates for common patterns (users/auth, e-commerce, etc.)
- Future-proof encryption against quantum threats
- Lightweight and performant – runs great even on modest hardware (school laptops included!)
Built over 2025 with a focus on usability, the current version has some rough edges (messy code, minor bugs) but is actively improving.
This tool is already helping devs (and fictional characters 😉) build faster. If you're tired of hand-crafting SQL and docs, give Database Designer a try – feedback welcome! 🚀