SchemaDoc AI
Link to open source: https://github.com/Aafi04/SchemaDoc-AI-Hackfest-2.0-ft.-Turgon-AI
Link to Live Project: https://schema-doc-ai-hackfest-2-0-ft-turgo.vercel.app
Enterprise databases grow organically over years:
-Leaving documentation outdated or nonexistent.
-Analysts waste hours reverse-engineering what tables and columns mean
-Slowing decisions and increasing error risk.
SchemaDocAI is an autonomous Data Reliability Agent that transforms silent database schemas into living, business-ready documentation. Unlike static generation tools, SchemaDocAI operates as an active investigator, also turning natural language into SQL queries.
Tools: Python, SQLAlchemy, Vercel(frontend), Railway(backend), Neon(Cloud postgreSQL DB), Gemini/LangChain for AI Brain, LangGraph for workflow.
UPDATE AFTER ROUND 2 (Development phase):
-Completely brought the project into live deployment and production phase from local hosting on Streamlit.
Live link: https://schema-doc-ai-hackfest-2-0-ft-turgo.vercel.app
Presentation Link: https://drive.google.com/file/d/13-9Jdv4iIZNxh5CV_3-FycLzD4fzNreI/view?usp=sharing
-Optimized SQL queries to reduce token usage and turnaround time.
-User flow time usage reduced from 2 minutes to 30 seconds per report iteration
-Complete refinement of UI/UX using modern stack (next.js and tailwind, can compare with images of earlier prototype in Images section.
-Introduced data persistance on the page, doesnt result in loss in case of accidental reloads/network failure
GOAL FOR ROUND 3(Final mentorship):
-Implement end-to-end testing for the agent
-Introduce possible restrictions on product usage based on some metric/time to avoid API abuse/rate limiting
-Handle all/any error gracefully instead of sudden/abrupt failure
-Present with snippets of actual code for the refinement work done for better understanding
-Make website compatible for cross-platform if time allows
UPDATES FOR ROUND 3(Final Mentorship) [6:37AM]
-End to end tests have be written
-IP-based rate limiting has been implemented to avoid resource usage abuse
-Errors/exceptions all are now handled gracefully
-Site is now COMPATIBLE to run on mobile browser!!!!
-Ready with snippets of code to show these updates
-Updates images has been uploaded to the Images section
______
All done with the project :)
This build was uploaded as a hackathon project
