iflow-mcp-pawankumar94-sql-mcp-server

# SQLGenius - AI-Powered SQL Assistant [](https://mcpreview.com/mcp-servers/pawankumar94/sql_mcp_server) SQLGenius is an intelligent SQL assistant that helps you query your BigQuery database using natural language. Built with MCP (Model Context Protocol), Vertex AI's Gemini Pro, and Streamlit. ## 🌟 Features - Natural language to SQL conversion using Gemini Pro - Interactive Streamlit UI with multiple tabs - Real-time query execution and visualization - Database schema explorer - Query history tracking - Safe query validation - BigQuery integration - MCP-based architecture ## 🎥 Demo Watch SQLGenius in action! Here's a quick demo of how to use the application:  In this demo, you can see: 1. Natural language query conversion to SQL 2. Interactive data visualization 3. Schema exploration 4. Query history tracking ## 🚀 Installation 1. Clone the repository and navigate to the project directory: ```bash cd sql_mcp_server ``` 2. Install dependencies: ```bash pip install -r requirements.txt ``` 3. Copy the `.env.example` file to `.env` and fill in your configuration: ```bash cp .env.example .env ``` 4. Set up your environment variables in `.env`: ``` PROJECT_ID=your-project-id DATASET_ID=your-dataset-id GOOGLE_APPLICATION_CREDENTIALS=path/to/your/service-account.json VERTEX_AI_LOCATION=us-central1 ``` ## 🎮 Usage 1. Start the application: ```bash streamlit run streamlit_app.py ``` 2. The MCP server will start automatically when the Streamlit app launches 3. Use the tabs to: - Ask natural language questions about your data - Write SQL queries directly - Explore your database schema ## 📊 Interface Tabs ### 💬 Natural Language Query Ask questions in plain English and get SQL results: - "Show me the top 5 customers by revenue" - "What products have the highest sales in January?" - "How many orders were placed last month?" ### 📊 SQL Query Write and …