9 months ago
research-and-dataSQLGenius is an AI-powered SQL assistant that converts natural language to SQL queries using Vertex AI's Gemini Pro. Built with MCP and Streamlit, it provides an intuitive interface for BigQuery data exploration with real-time visualization and schema management.
Overview
what is SQLGenius?
SQLGenius is an AI-powered SQL assistant that converts natural language queries into SQL commands, enabling users to interact with their BigQuery databases effortlessly.
how to use SQLGenius?
To use SQLGenius, clone the repository, install the dependencies, set up your environment variables, and run the Streamlit application to start querying your data using natural language or SQL.
key features of SQLGenius?
- Natural language to SQL conversion using Vertex AI's Gemini Pro
- Interactive Streamlit user interface with multiple tabs
- Real-time query execution and visualization
- Database schema exploration and query history tracking
- Safe query validation and secure credential management
use cases of SQLGenius?
- Querying databases using plain English questions.
- Executing complex SQL queries directly.
- Exploring database schemas and sample data.
- Visualizing query results in real-time.
FAQ from SQLGenius?
- Can SQLGenius handle all types of SQL queries?
SQLGenius is designed primarily for SELECT queries to ensure safety and prevent dangerous operations.
- Is SQLGenius free to use?
Yes! SQLGenius is open-source and free for everyone to use.
- How does SQLGenius ensure query safety?
SQLGenius implements query validation to prevent harmful operations and only allows safe SELECT queries.