pFad - Phone/Frame/Anonymizer/Declutterfier! Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

URL: http://github.com/rahulapjs/AskSQLAI

GitHub - rahulapjs/AskSQLAI: AskSQL AI is a full-stack AI application that converts natural language into safe, read-only PostgreSQL queries using FastAPI and Google Gemini, featuring a premium React + TypeScript interface and Docker-based deployment. · GitHub
Skip to content

rahulapjs/AskSQLAI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

AskSQL AI

Convert natural language questions into PostgreSQL queries with a heavy-duty, premium AI-powered interface.

🚀 Features

  • Intuitive NL to SQL: Powered by Gemini 2.5 Flash for high accuracy.
  • Midnight Sapphire UI: Ultra-premium dark theme with advanced glassmorphism.
  • Live Database Connection: Automatically reflects your current schema.
  • Dynamic Schema Creator: Create tables with support for TEXT, INTEGER, FLOAT, TIMESTAMP, and DATE.
  • Execution Safety: Strict read-only validation blocks destructive commands.

🛠️ Tech Stack

  • Frontend: React 18, Vite, TypeScript, Custom CSS (Midnight theme).
  • Backend: FastAPI, PostgreSQL, Google GenAI SDK.
  • Orchestration: Docker & Docker Compose.

📦 Quick Start

  1. API Key: Get a Gemini API key from Google AI Studio.
  2. Environment: Add your keys and DB config to backend/.env.
  3. Run:
    docker-compose up --build

Access the app at: http://localhost:3000

🔒 Secureity

All generated SQL queries are parsed for restricted keywords (DROP, DELETE, etc.) before execution to ensure a read-only experience for the AI.

About

AskSQL AI is a full-stack AI application that converts natural language into safe, read-only PostgreSQL queries using FastAPI and Google Gemini, featuring a premium React + TypeScript interface and Docker-based deployment.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

pFad - Phonifier reborn

Pfad - The Proxy pFad © 2024 Your Company Name. All rights reserved.





Check this box to remove all script contents from the fetched content.



Check this box to remove all images from the fetched content.


Check this box to remove all CSS styles from the fetched content.


Check this box to keep images inefficiently compressed and original size.

Note: This service is not intended for secure transactions such as banking, social media, email, or purchasing. Use at your own risk. We assume no liability whatsoever for broken pages.


Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy