
I built a VS Code extension that lets you chat with your database - everything runs locally
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

