CodeViz

Mermaid Diagram
SQL Metrics
SQL Suggestions
CPU and Memory Metrics
Chat

Inspiration

As a fellow developer, I wanted to help the community by creating a tool that makes understanding complex codebases easier. CodeViz was born out of the desire to democratize code comprehension and foster collaboration within development teams. By leveraging AI-powered visualizations, CodeViz aims to empower everyone to understand the structure and logic of code repositories without needing deep programming expertise.

What it does

CodeViz currently focuses on SQL queries by connecting to Snowflake databases. It utilizes the Snowflake Arctic LLM to generate insightful visualizations, SQL metrics, and suggestions based on the provided SQL queries and insight visualization using Streamlit.

How we built it

CodeViz was built using Python and the Streamlit framework for the frontend. The backend leverages the Snowflake Arctic LLM to analyze SQL queries and generate visualizations. The tool integrates with Snowflake for credential verification and SQL query processing.

Challenges we ran into

Integrating the Snowflake Arctic LLM effectively to generate accurate and meaningful visualizations from SQL queries.
Designing an intuitive and user-friendly interface using Streamlit that caters to both technical and non-technical users.

Accomplishments that we're proud of

Successfully integrating the Snowflake Arctic LLM with CodeViz to generate insightful visualizations from SQL queries.
Developing a clean and intuitive user interface using Streamlit, enhancing the overall user experience.

What we learned

Leveraging AI and LLMs for code analysis and visualization.
The importance of user-centric design and visual communication in conveying complex technical concepts.
Utilizing Streamlit for rapid prototyping and iterating on the user interface.

What's next for CodeViz

Expanding CodeViz's capabilities to support a wider range of programming languages and databases.
Continuously improving the AI-powered analysis and suggestion features for enhanced accuracy and relevance.
Exploring integrations with popular version control systems and IDEs to streamline the workflow.

We're excited about the future of CodeViz and its potential to revolutionize code understanding and collaboration. Stay tuned for more updates and features!