The AI-Powered SQL Assistant is a proof-of-concept system designed to bridge the gap between natural language and database queries, specifically for Oracle Autonomous Database (23ai). It allows users to ask questions in plain English, which are then intelligently translated into SQL or semantic vector searches. The system leverages a locally running Large Language Model (LLaMA 3.2 via Ollama) for query interpretation and SQL generation, a FastAPI-based backend (MCP Server) for execution on Oracle ADBS, and native Oracle Vector Search capabilities, eliminating the need for external vector databases. Its modular architecture ensures flexible query routing and an optional LLM-driven interpretation of results for more human-readable answers.
主要功能
01Optional LLM-based interpretation of SQL results for natural language answers.
02Native Oracle ADBS vector embedding and querying, no external vector database required.
03Fully local LLM for intelligent SQL generation via Ollama.
040 GitHub stars
05Modular architecture facilitating easy expansion and integration.
06Smart switching between structured SQL and semantic vector search.
使用案例
01Natural language querying of Oracle 23ai databases.
02Performing semantic searches on unstructured data stored within Oracle Autonomous Database.
03Generating SQL statements from plain English descriptions.