Your Database Knows Everything. Too Bad It Only Speaks SQL.

2026-03-17 · Source: Naturallanguageprocessing on Medium · Field: Technology & Digital — Artificial Intelligence & Machine Learning, Data Science & Analytics, Software Development & Engineering · Depth: Intermediate, medium

Summary

An open-source Agentic AI module has been developed to enable users to query databases like Redshift and SQLite using plain English, eliminating the need for manual SQL writing for common tasks. This solution leverages LangGraph for agent orchestration, Gemini 2.5 Flash for natural language processing and SQL generation, and Streamlit for an intuitive, context-aware chat interface with session memory and caching. A critical aspect of its design is a robust security model, which connects as the actual user to enforce existing database permissions, validates all queries to be "SELECT-only", and caps result rows, enhancing data governance without relying on prompt engineering. The tool is free, open-source, and can be set up locally in under five minutes, offering both a SQLite proof-of-concept and a production-ready Redshift version on GitHub.

Key takeaway

An open-source Agentic AI, leveraging LangGraph and Gemini 2.5 Flash, enables plain English querying of Redshift and SQLite databases, eliminating manual SQL for data professionals. It ensures robust security by connecting as the actual user to enforce native permissions, validating all queries as SELECT-only, and capping results at 50 rows. This Streamlit-based solution provides a free, auditable, and quickly deployable tool to streamline database interactions and reduce trivial engineering tasks.

Topics

• Agentic AI
• Natural Language to SQL
• LangGraph
• Gemini 2.5 Flash
• Streamlit

Code references

• yatanjain/redshift-agentic-ai

Best for: AI Engineer, Machine Learning Engineer, Data Engineer

Related on AIssential

• AgentNLQ: A General-Purpose Agent for Natural Language to SQL — Multi-agent orchestration with enriched schema and execution feedback significantly improves NL2SQL accuracy and efficiency.
• Kimi 2.6 Test | The Best Agentic Coding Open Model? | Coding, OCR, Image Understanding | 🔴 Live — Gemini K 2.6 is a large, multimodal open model excelling in agentic coding and visual design tasks.
• What the Agentic Era Means for Data Science — AI agents are transforming data science by automating procedural tasks, shifting focus to evaluative and systemic design roles.
• Google CEO: Agents, Open Source, Race to AGI, Cybersecurity, Chips, China — Agents will fundamentally reshape internet interaction, demanding trust, control, and efficient, responsible AI development.
• 🗞️ Google just launched Gemini 3.1 Flash TTS, a text-to-speech model that takes scene direction, speaker notes — AI advancements focus on enhanced control, multimodal retrieval, secure agent execution, and specialized model access.
• Imagine if your Teams or Slack messages automatically turned into secure context for your AI agents — PromptQL built it — PromptQL transforms team communications into secure, actionable context for AI agents via an AI-native workspace and shared wiki.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Naturallanguageprocessing on Medium.