kwiklydb
A data dictionary web app for Kwikly's MySQL production database, with AI-generated schema definitions, user ratings, and collaborative documentation.
8 commits over 3 days
What it is
Kwiklydb provides a searchable, collaborative interface for understanding the complex database schema of Kwikly (a dental staffing marketplace platform). It syncs table/column metadata from a production MySQL database, generates AI-powered natural-language definitions using OpenAI, and allows users to rate and comment on those definitions. The tool bridges technical database schemas with business context, making the data accessible to both technical and non-technical team members. Admin users can sync the schema, bulk-generate definitions, and manage content; regular users can browse, search, rate, and contribute feedback.
Why I built it
Built to document and make sense of Kwikly's production database schema in a centralized, accessible way. The dental staffing platform has grown complex (multi-tenant architecture, multiple user types, intricate workflows), and this data dictionary helps developers, product managers, and stakeholders quickly discover what tables and columns represent without digging through code or database dumps. The AI-powered definitions automate the tedious work of writing documentation, while user ratings and comments enable collaborative knowledge sharing.
Tech stack
Next.js 15 (App Router), React 19, TypeScript, Tailwind CSS 4. Backend: Next.js API routes, Prisma ORM, MySQL2 for read-only production database access, PostgreSQL (Neon) for app metadata. Auth: NextAuth.js with Google OAuth. AI: OpenAI API for definition generation with Zod schema validation. Deployed on Vercel.
Timeline & effort
Last active Sep 19, 2025 — 8 commits across 3 active days (spanning 3 days).
Developed over 3 days in mid-September 2025 with 8 commits across 3 distinct active days. The commit pattern suggests focused, task-oriented work sessions iterating on AI prompt engineering, schema sync, and admin features.
Did it turn out useful?
This is a deployed, functional internal tool (live at kwiklydb.vercel.app) solving a real documentation problem for the Kwikly production team. The comprehensive README, detailed docs (PRD, design context, AI improvement tasks), schema sync safety features (read-only MySQL access), and multi-role authentication indicate it was built for actual use. The AI improvement tasks doc shows iterative refinement (proper Zod validation, structured output, cleanup of legacy code), and the presence of admin/sync workflows + user rating features demonstrates it's more than a proof-of-concept.