CLARITY - Data Dictionary Agent
Link to open source: https://github.com/samikshakamdi/intelligent_data_dictionary
Link to Live Project: https://intelligentdatadictionary-production-2a17.up.railway.app/
The Intelligent Data Dictionary Agent - CLARITY is an AI-powered system designed to automatically analyze enterprise databases and convert complex technical structures into clear, business-friendly insights. Organizations often struggle with outdated or missing documentation, leading to confusion and slow decision-making. This solution connects to databases using SQLAlchemy, extracts schema metadata such as tables, columns, and relationships, and performs data quality checks including null values, duplicates, and freshness analysis. It then generates human-readable documentation using a large language model and provides a natural language chat interface for easy data exploration. A unique feature of the system is its Business Health Score, which evaluates overall database quality, along with Industry Detection, which identifies the likely industry based on schema patterns and sample data. Built with FastAPI for the backend and a modern React frontend, the platform combines automation, analytics, and AI to make database understanding faster, smarter, and accessible to both technical and non-technical users.
This build was uploaded as a hackathon project
