Query Lens

Natural language SQL query builder for Rails, powered by AI

Powered by RubyLLM, QueryLens works with any major AI provider: OpenAI, Anthropic (Claude), Google Gemini, DeepSeek, Mistral, Ollama (local models), and more.

What you get

• Natural language to SQL conversion powered by any LLM
• Works with OpenAI, Anthropic, Gemini, Ollama, and 10+ other providers
• Saved queries organized into projects (like Blazer) — save, edit, move, and reuse known-good queries
• Automatic database schema introspection with caching
• Smart schema handling for large databases (two-stage table selection)
• Interactive conversation with context (follow-up questions refine queries)
• Read-only query execution (safety enforced at transaction level)

Installing it

# Gemfile
gem "query_lens"

Details

71 stars on GitHub · MIT licensed · maintained by bryanbeshore. Source: https://github.com/bryanbeshore/query_lens