Back to Home

AI Khata Bot

Feb 2026—Present
Visit ProjectView on GitHub

Technologies

  • Next.js
  • TypeScript
  • Google Gemini Pro
  • Telegram API
  • PostgreSQL
  • Prisma
  • +3

About This Project

AI-Powered Bookkeeping & Khata Assistant for Small Businesses and Shop Owners.

Key Architecture & Highlights:

  • Built an intelligent bookkeeping assistant integrating Telegram bot conversational interface with a modern Next.js web analytics dashboard.
  • Implemented multi-lingual natural language intent parsing (Hindi, Hinglish, English) using Google Gemini to automatically extract sales, credits, and debits (e.g., "Ramesh ko 250 udhar").
  • Designed automated transaction records and reconciliation workflows backed by PostgreSQL and Prisma ORM.
  • Architected high-performance caching and rate limiting with Upstash Redis and automated webhook lifecycle management.
  • Integrated Clerk authentication for secure multi-tenant merchant access.

All Technologies & Skills

  • Next.js
  • TypeScript
  • Google Gemini Pro
  • Telegram API
  • PostgreSQL
  • Prisma
  • Upstash Redis
  • Clerk
  • Tailwind CSS