Glancer

RoR engine that enables natural language queries over your database using RAG and LLMs.

Glancer is a Ruby on Rails engine that mounts a full chat interface inside your app and lets anyone on your team query the database in plain language, no SQL required. You ask a question, Glancer retrieves the relevant schema context, generates a query, validates and executes it safely, then returns the results with a human-readable explanation.

What you get

• Safety first — all queries run inside a transaction that always rolls back. No write statement can ever reach the database.
• Your LLM, your cost — bring your own Gemini, OpenAI, or OpenRouter key. Mix providers per role to balance cost and quality.
• No external vector store — embeddings live in your existing database. No Pinecone, no Weaviate, no extra infrastructure.
• Rails-native — mounted as an engine, uses Turbo and Stimulus, installs in under five minutes.

Installing it

# Gemfile
gem "glancer"

Details

35 stars on GitHub · MIT licensed · maintained by ErnaneJ. Source: https://github.com/ErnaneJ/glancer