DEV Community

Shrijith Venkatramana
Shrijith Venkatramana

Posted on • Edited on

Improving DBChat - Part 10

Hello, I'm Shrijith. I'm building git-lrc, an AI code reviewer that runs on every commit. It is free, unlimited, and source-available on Github. Star Us to help devs discover the project. Do give it a try and share your feedback for improving the product.

In this series, I am on a journey to build for myself DBChat - a simple tool for using AI chat to explore and evolve databases.

See previous posts to get more context:

  1. Building DBChat - Explore and Evolve Your DB with Simple Chat (Part 1)

  2. DBChat: Getting a Toy REPL Going in Golang (Part 2)

  3. DBChat Part 3 - Configure , Connect & Dump Databases

  4. Chat With Your DB via DBChat & Gemini (Part 4)

  5. The Language Server Protocol - Building DBChat (Part 5)

  6. Making DBChat VSCode Extension - Ping Pong With LSP Backend (Part 6)

  7. Starting a VSCode Extension UI For DBChat (Part 7)

  8. Manage TOML Configuration From VSCode Extension - DBChat Part 8

  9. Getting DBChat Working For the First Time In VSCode - Part 9

A Video Demo (Step Up from Screenshots Last Time)

You can see me do a bunch of things in the following demo:

  1. See existing DB connections

  2. See various operations (show DB creds, edit, delete)

  3. Chat with a specific DB

  4. Generate SQL options from simple English prompt

  5. Execute SQL and show results

  6. Refine the SQL with more specific/pointed English prompt

What's New

  1. Fixed various annoyances with the chat window: Enter key not working, scrollbar resetting on response, etc

  2. Earlier DB credentials were exposed in the listing page; now there's a specific eye icon - which must be clicked to show any sensitive information

  3. I have a better testing setup now - with custom database, users, and so on. Will speed up development from now on due to the foundation.

Bugs and things learned

  1. With LLMs - I tried doing a bit of "vibe coding" that Karpathy talked about.

  2. It is important to commit/snapshot things as we vibe code, so that we can revert to working state if things go wrong.

  3. LLMs get into loops and do the same errors again and again, and sometimes never seem to learn/improve. I have to jump in and fix things often.

  4. Had a pretty table come up once, but it was a hardcoded HTMLfrom the LSP. So tried to dynamize it - for almost an hour. See above - the LLM went into an unproductive broken code loop. Had to set this challenge for another day.

  5. Found a bug with "Edit Connection". Maybe LLM interfered with my old code, but now, on clicking save, a new connection was created rather than updating old one.

  6. The "Show DB credentials" feature is not working reliably

  7. The "Add Connection" method via connection string is quite unfriendly. I want to give an LLM interface to add DBs. So you could paste pretty much anything, and it'll collect the necessary information.

git-lrc
*AI agents write code fast. They also silently remove logic, change behavior, and introduce bugs -- without telling you. You often find out in production.

git-lrc fixes this. It hooks into git commit and reviews every diff before it lands. 60-second setup. Completely free.*

Any feedback or contributors are welcome! It's online, source-available, and ready for anyone to use.

⭐ Star it on GitHub:

GitHub logo HexmosTech / git-lrc

Free, Unlimited AI Code Reviews That Run on Commit

git-lrc logo

git-lrc

Free, Unlimited AI Code Reviews That Run on Commit



git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt



AI agents write code fast. They also silently remove logic, change behavior, and introduce bugs -- without telling you. You often find out in production.

git-lrc fixes this. It hooks into git commit and reviews every diff before it lands. 60-second setup. Completely free.

See It In Action

See git-lrc catch serious security issues such as leaked credentials, expensive cloud operations, and sensitive material in log statements

git-lrc-intro-60s.mp4

Why

  • πŸ€– AI agents silently break things. Code removed. Logic changed. Edge cases gone. You won't notice until production.
  • πŸ” Catch it before it ships. AI-powered inline comments show you exactly what changed and what looks wrong.
  • πŸ” Build a habit, ship better code. Regular review β†’ fewer bugs β†’ more robust code β†’ better results in your team.
  • πŸ”— Why git? Git is universal. Every editor, every IDE, every AI…

Top comments (1)

Collapse
 
lincemathew profile image
LinceMathew

This looks great.