HN Showcase
Back to browse
Building a SQL analyst agent from scratch

Building a SQL analyst agent from scratch

by ramin2nt2·Apr 27, 2026·6 points·0 comments
Visit ProjectView on HN

AI Analysis

●MidShip It

Focuses on iterative schema exploration, but LangChain and Vanna already solve this.

Strengths
  • •Explicitly models the iterative analysis loop instead of one-shot query generation.
  • •Clean implementation using Vercel AI SDK for tool definitions and state management.
Weaknesses
  • •No differentiation from established libraries like LangChain or Vanna AI.
  • •Tutorial-focused repo lacks production features like auth, caching, or multi-tenant support.
Category
AI/ML
Target Audience

Developers learning to build AI agents or SQL tools

Similar To

Vanna AI · LangChain SQL Agent · LlamaIndex

Post Description

I built a SQL analyst agent based on a simple idea: generating SQL is not the same as doing analysis.

Most text-to-SQL tools stop at producing a query. But real analysis is iterative. You explore the schema, run queries, adjust, and refine.

This project tries to model that loop instead of treating a query as the final output.

I wrote about the approach, challenges, and tradeoffs here: https://raminmousavi.dev/blog/building-a-sql-analyst-agent

Github repo: https://github.com/raminious/sql-analyst-ai-agent

Similar Projects

Infrastructure●●Solid

Rust Database from Scratch

Unified SQL, graph, and vector engine when Neon and pgvector already split these concerns.

Bold BetBig Brain
ayoubnabil
8514d ago