FlareStart
HomeNewsHow ToSources
FlareStart

Where developers start their day. All the tech news & tutorials that matter, in one place.

Quick Links

  • Home
  • News
  • Tutorials
  • Sources
  • Privacy Policy

Connect

© 2026 FlareStart. All rights reserved.

Back to articles
I built a VS Code extension that lets you chat with your database - everything runs locally
NewsSystems

I built a VS Code extension that lets you chat with your database - everything runs locally

via Dev.toHitesh Shinde3w ago

I spent a week onboarding into a project with a SQL Server database I'd never seen before. Dozens of stored procedures, no documentation, and the previous dev had left. I kept thinking — why can't I just ask this database what it does? I couldn't find a tool that solved that specific problem, so I built one. SchemaSight is a VS Code extension that connects to SQL Server, PostgreSQL, or MySQL, crawls your schema, and lets you ask plain English questions about it. What does this procedure do? What tables are involved in invoicing? Is there row-level security anywhere? It answers from the indexed schema itself — no live query execution, nothing leaves your machine. How it works under the hood When you crawl a database, the extension walks every table, view, stored procedure, and function, summarizes each one using your local Ollama model, embeds those summaries with Transformers.js ( all-MiniLM-L6-v2 ) running entirely in Node.js, and stores everything in LanceDB. At query time, a QueryCl

Continue reading on Dev.to

Opens in a new tab

Read Full Article
15 views

Related Articles

News

Best offer Buy Now limited Time 🫴

Dev.to Beginners • 15h ago

News

After 40 years, arbitrary code execution has been achieved in Super Mario Bros

Lobsters • 16h ago

DSTs Are Just Polymorphically Compiled Generics
News

DSTs Are Just Polymorphically Compiled Generics

Lobsters • 16h ago

From Missed Birthdays to Automation: How I Built a Bot That Designs and Sends Birthday Cards
News

From Missed Birthdays to Automation: How I Built a Bot That Designs and Sends Birthday Cards

Medium Programming • 17h ago

News

I Made a Keyboard Nobody Asked For: My Experience Making TapType

Lobsters • 18h ago

Discover More Articles