Inspiration
My inspiration for GenQuery stemmed from observing the challenges faced by beginners in learning SQL. We aimed to simplify the process of generating SQL queries, especially for those new to programming and database management.
What it does
GenQuery serves as a personal SQL query assistant, powered by TiDB Database & Generative AI tools. It enables users to effortlessly generate SQL queries and receive detailed explanations, streamlining the data retrieval process.
How we built it
We developed GenQuery using Python and integrated the Gemini 1.5 Pro API for AI capabilities. For database management, we utilized TiDB Serverless, a fully-managed MySQL-compatible database service with built-in Vector Search. We uploaded our database to TiDB Serverless, which allowed us to leverage its advanced features for scalable and efficient data handling. The project was deployed and showcased using Streamlit, a platform for building and sharing data apps.
Challenges we ran into
Throughout the development process, integrating the AI model seamlessly with Streamlit posed a significant hurdle. Additionally, ensuring smooth interaction with TiDB Serverless and overcoming technical obstacles related to database management required creative problem-solving.
Accomplishments that we're proud of
We're proud to have successfully built a user-friendly SQL query assistant that simplifies complex tasks for users. Leveraging TiDB Serverless for database management and Vector Search capabilities enhanced our project's scalability and performance. Deploying the project and showcasing its capabilities was a significant achievement.
What we learned
Developing GenQuery provided valuable learning experiences. We explored the potential of AI in simplifying tasks like SQL query generation and utilized TiDB Serverless to handle large datasets efficiently. Deploying projects using Streamlit taught us essential skills in project deployment and user interface design. Overcoming technical challenges enhanced our problem-solving skills and deepened our understanding of software development.
What's next for GenQuery 2.0
Looking ahead, we plan to implement additional features to enhance the user experience further. We'll gather feedback from users and incorporate improvements based on their input. Additionally, we aim to explore opportunities to expand GenQuery's functionality, including advanced data visualization and enhanced query capabilities, leveraging TiDB Serverless Vector Search for even greater performance and scalability.
Log in or sign up for Devpost to join the conversation.