MySQL_AI_Agent

Name: MySQL_AI_Agent
Author: nvhnam

nvhnam April 7, 2025

3 copies 0 downloads

An intelligent MySQL AI Agent system that translates natural language into SQL queries and provides insightful responses — powered by Streamlit, LangChain, Gemini, and MySQL.

🧠 MySQL AI Agent

A lightweight AI-powered agent that understands and interacts with MySQL databases through natural language. Built to support developers, analysts, and students in exploring and querying databases using plain English — no manual SQL writing required.

🚀 Features

🔍 Natural Language Interface: Ask questions in plain English and get meaningful answers back.
📊 Database Insights: Retrieve data summaries, visualize results (line, bar, pie charts), and explore tables effortlessly.
🔄 Multi-query Support: Handles follow-up questions and context-aware dialogue.
🧠 LLM-Powered Responses: Uses Google Gemini + LangChain to return human-friendly explanations instead of raw query outputs.
⚙️ Customizable Schema: Connect to your own MySQL database with ease.
💬 Conversational UI: Clean chat interface for seamless interaction.

🛠️ Tech Stack

🧪 Programming Language: Python
🧠 AI Framework: LangChain + Gemini
📊 Database: MySQL
🌐 Frontend/UI: Streamlit

📦 Setup Instructions

Clone the repository

<pre> git clone https://github.com/nvhnam/MySQL_AI_Agent.git cd to the project </pre>

Install dependencies

<pre> pip install -r requirements.txt </pre>

Configure Environment

Create a folder named .streamlit in the project root (if it doesn't already exist):

<pre> mkdir .streamlit </pre>

Inside the .streamlit folder, create a file named secrets.toml and add your credentials:

<pre> gemini_key = "your_gemini_api_key" default_db_uri = "mysql+pymysql://username:password@host:port/database_name" </pre>

💡 Make sure to replace the values with your actual Claude API key and MySQL connection URI.

Run the app

<pre> streamlit run app.py </pre>

🤝 Contributing

I'm happy to hear your thoughts or ideas! Feel free to contact me with your ideas or collaboration.

Reach me at:

📧 Email: nvhnam01@gmail.com
👨‍💻 Portfolio: https://nguyenviethoangnam.vercel.app/

⭐ Support the Project

If you fi

Comments

More Agents

View all

agentic-ai

Agentsmith

Universal, model-agnostic operating harness for AI agents (Claude, Codex, Gemini, …) — a lean core + work-type profiles assembled by one setup script.

PromptPartner

308

agent-skills

Awesome Gamedev Agent Skills

Game-development Agent Skills for AI coding agents: install once and a master router loads the right skill for your engine and task. 66 original, version-pinned skills (plus a master router) in the portable SKILL.md format that runs across Claude Code, Cursor, Codex, Copilot, Gemini CLI and more, for Godot, Unity, Unreal, web and beyond.

gamedev-skills

303

ai-agents

Agentpet

A desktop pet for macOS & Windows that monitors your AI coding agents (Claude Code, Codex, Cursor, Gemini...) in real time, and grows as you code, feed it tokens, level it up, climb the leaderboard.

ntd4996

279

ai-agent

UltraGameStudio

UltraGameStudio - AI coding agent for game development: engine workflows, gameplay code, and asset generation.

wellingfeng

260

Zero

The coding agent that answers to you, your model, your machine, your rules.

Gitlawb

1,099

agent-bridge

Lucarne

Stop babysitting local AI agents. Just notifications, approve, and resume your Codex,Pi,Grok, or Claude code sessions anywhere. 0-Intrusion mobile control bridge via Telegram/微信/飞书. No hooks, no skills, no MCP.

tuchg

314