agno_ai_agent_sql_tools

In this project, an Agentic AI Application has been built for running SQL Queries and interacting with Database in Python with Agno (previously known as Phidata), SQLTools and Llama4 LLM (with Groq cloud). For building the app, Streamlit library is used in python. SQL Tools enables an AI Agent to run various SQL Queries and interact with the Database based on user's questions. In the App, user needs to enter the query/question based on what information he/she wants to extract from some Database table, then they just need to click on the "Run Query" button. Our AI Agent, with the help of SQL Tools will run corresponding SQL query and fetch the required data from the database table and display it there.

Installation of Agno: pip install agno pip install mcp This project requires us to install sqlalchemy library: pip install -U sqlalchemy

It also requires us to create a database. We will use a Postgres database running in a Docker container. Following steps are required:

1. Install Docker Desktop, launch and keep it running
2. Open command prompt on windows and run the following: docker run -d -e POSTGRES_DB=ai -e POSTGRES_USER=ai -e POSTGRES_PASSWORD=ai -e PGDATA=/var/lib/postgresql/data/pgdata -v pgvolume:/var/lib/postgresql/data -p 5532:5432 --name pgvector phidata/pgvector:16