Feb 21, 2026

SchemaSense AI The Intelligent Enterprise Data Steward

gdg gdgcloudnd gdgindia gdgnewdelhi googlecloud geminiapi streamlit dataanalytics python sql

Data scientists and business users often struggle with cryptic database schemas. SchemaSense AI is a professional-grade Intelligent Data Dictionary Agent that converts raw, complex databases into a human-readable knowledge graph for real-time analytics.

Core Innovation: Unlike standard SQL-bots, SchemaSense extracts a live "Intelligent Schema Map" and provides a "Visual Analytics" engine that executes read-only SQL queries to generate high-fidelity business charts in seconds.

Key Features implemented for HackFest 2.0:

  • Enterprise Multi-Database Support: Dynamically connects to PostgreSQL (and MySQL ready) instances via Cloud SQL.

  • Autonomous Data Dictionary: Automatically inspects tables, columns, and relationships (Foreign Keys) to provide an interactive map of the architecture.

  • SQL Injection Guard: A built-in security layer ensures the AI only executes SELECT statements, protecting production data from accidental deletion.

  • Live Column Profiling: Fetches real-time statistical samples to visualize data distributions without compromising container memory.

  • Powered by Gemini 3 Flash: Utilizing the latest gemini-3-flash-preview for lightning-fast reasoning and high-accuracy SQL generation.

This build was uploaded as a hackathon project

Hackathon

HackFest 2.0

View All Projects
Give a star to encourage!Discussion
Start a new conversation!
Login to join the discussion