IdeaCredIdeaCred

Hitesh1326/schemasight

74

Chat with your database. Locally. VS Code extension for exploring and understanding schemas and stored procedures using local LLMs. SQL Server · PostgreSQL · MySQL. Zero cloud dependency.

What's novel

Chat with your database. Locally. VS Code extension for exploring and understanding schemas and stored procedures using local LLMs. SQL Server · PostgreSQL · MySQL. Zero cloud dependency.

Code Analysis

5 files read · 2 rounds

A VS Code extension that crawls database schemas (SQL Server, PostgreSQL, MySQL) and creates a local LanceDB vector index for RAG-based SQL generation using Ollama.

Strengths

Excellent modularity with clear separation between drivers, indexing logic, and UI contracts. The architecture is clean, leveraging established tools like LanceDB and LangChain effectively. Naming conventions are consistent and descriptive.

Weaknesses

Lacks any visible test suite (test_quality: 0). Error handling appears basic, relying on standard try/catch without detailed logging or specific error types for database failures.

Score Breakdown

Innovation
6 (25%)
Craft
62 (35%)
Traction
11 (15%)
Scope
85 (25%)

Signal breakdown

Innovation

Not Fork+1
Code Novelty+1
Concept Novelty+2

Craft

Ci+0
Tests+0
Polish+2
Releases+0
Has License+5
Code Quality+21
Readme Quality+15
Recent Activity+7
Structure Quality+5
Commit Consistency+2
Has Dependency Mgmt+5

Traction

Forks+0
Stars+6
Hn Points+0
Watchers+0
Early Traction+5
Devto Reactions+0
Community Contribs+0

Scope

Commits+7
Languages+8
Subsystems+10
Bloat Penalty+0
Completeness+7
Contributors+5
Authored Files+15
Readme Code Match+3
Architecture Depth+7
Implementation Depth+8

Evidence

Commits

46

Contributors

1

Files

94

Active weeks

3

TestsCI/CDREADMELicenseContributing

Repository

Language

TypeScript

Stars

3

Forks

0

License

MIT