SQL_MCP_Server

Overview

SQLGenius is an intelligent SQL assistant built with the Model Context Protocol that enables users to query BigQuery databases using natural language. It combines Vertex AI's Gemini Pro for natural language understanding with a Streamlit frontend for an intuitive interface. The server provides tools for converting English queries to SQL, executing validated queries, exploring database schemas, and visualizing results in real-time. It focuses on data exploration with security features that only permit SELECT queries.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_nl_query

  Execute a natural language query to convert English questions to SQL

  Try:Show me the top 5 customers by revenueTry:What products have the highest sales in January?
• execute_sql_query

  Execute a raw SQL query against the BigQuery database

  Try:SELECT * FROM orders WHERE order_date > '2023-01-01'Try:COUNT(*) FROM customers WHERE status = 'active'
• list_tables

  List all available tables in the BigQuery dataset

  Try:Show all tablesTry:List available tables in the dataset
• get_table_schema

  Get schema information for a specific table

  Try:Show schema for orders tableTry:What columns are in the products table?

Comparable tools

Installation

git clone https://github.com/pawankumar94/sql_mcp_server.git
cd sql_mcp_server

pip install -r requirements.txt

cp .env.example .env
# Edit .env with your BigQuery credentials

streamlit run streamlit_app.py

{
  "mcpServers": {
    "sqlgenius": {
      "command": "python",
      "args": ["path/to/sql_mcp_server/sql_mcp_server.py"]
    }
  }
}

FAQ

What databases does SQLGenius support?

Currently, SQLGenius is specifically designed for Google BigQuery integration.

Are there security limitations in place?

Yes, only SELECT queries are permitted to ensure safe data exploration. The server includes query validation to prevent dangerous operations.

Compare SQL_MCP_Server with