Scribd
Upload
4 views10 pages

AI SQL & SSIS Documentation Tool

AutoSQLDoc++ is an AI-powered documentation generator designed to automate the documentation of legacy SQL stored procedures and SSIS packages, addressing issues such as manual effort and onboarding delays. It parses SQL scripts and SSIS packages to extract metadata and generates structured documentation in Word or PDF format, featuring key functionalities like visual flow diagrams and input/output mapping. The tool is built with a React frontend and Python FastAPI backend, and is suitable for use cases including audit readiness and developer onboarding.

Uploaded by

Vanitha Kannan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
4 views10 pages

AI SQL & SSIS Documentation Tool

AutoSQLDoc++ is an AI-powered documentation generator designed to automate the documentation of legacy SQL stored procedures and SSIS packages, addressing issues such as manual effort and onboarding delays. It parses SQL scripts and SSIS packages to extract metadata and generates structured documentation in Word or PDF format, featuring key functionalities like visual flow diagrams and input/output mapping. The tool is built with a React frontend and Python FastAPI backend, and is suitable for use cases including audit readiness and developer onboarding.

Uploaded by

Vanitha Kannan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

AutoSQLDoc++

AI-Powered SQL & SSIS


Documentation Generator
By Vanitha Kannan
🚨 Problem Statement
• Legacy SQL stored procedures and SSIS
packages lack proper documentation.
• - Time-consuming manual efforts
• - Onboarding delays
• - Audit and compliance risks
💡 Solution: AutoSQLDoc++
• AutoSQLDoc++ is an AI-powered
documentation engine that:
• - Parses SQL scripts and SSIS packages
• - Extracts metadata, logic, inputs, and outputs
• - Generates structured Word or PDF
documentation
• - Offers a web UI for file upload and export
✨ Key Features
• - SQL logic parsing and explanation
• - SSIS control/data flow analysis
• - Visual flow diagrams (Mermaid/ASCII)
• - Business logic summary
• - Input/output mapping
• - Export to Word/PDF
🧱 Architecture Overview
• Frontend: React/HTML file uploader
• Backend: Python FastAPI
• AI: Copilot + prompt templates
• Parser Modules: SQL and SSIS extractors
• Output: Docx/PDF formatter
📄 Sample Output (Word
Document)
• - Overview
• - Flow Diagram
• - Input/Output Mapping
• - Task Summary Table
• - Schedule, Variables, Error Handling
🎯 Use Cases
• - Documentation for legacy stored procedures
• - SSIS audit readiness
• - Developer onboarding
• - Migration readiness (to ADF/Synapse)
• - Control-M job mapping
🚀 Demo Workflow
• 1. Upload `.sql` or `.dtsx` file
• 2. AI parses and extracts structure
• 3. Document is generated (Word/PDF)
• 4. Download and share with stakeholders
🏆 GHCP Hackathon Value
• - Leverages GitHub Copilot to save hours of
effort
• - Automates documentation for SQL & SSIS
• - Brings business and tech closer
• - Ready for integration into CI/CD pipelines
🙏 Thank You
• Vanitha Kannan | GHCP Hackathon 2025
• AutoSQLDoc++

You might also like