Hermes

An open source prototype that lets you query your PostgreSQL database using natural language. Think of it as "Perplexity for your data": ask questions like "What's our revenue this quarter?" and get answers with beautiful visualizations. Features smart chart selection (bar, line, area, pie), AI-powered SQL generation with GPT-4o, and secure read-only query execution. I used PostgreSQL's Row Level Security (RLS) to restrict database access to SELECT queries only, preventing SQL injection attacks. In a multi-tenant SaaS production environment, this same RLS approach would restrict queries to rows matching the current tenant_id, ensuring complete data isolation between customers. For this project I gave Clojure a try, and it powers the entire backend. I'd been curious about functional programming and Lisp-style languages for a while, and Clojure's emphasis on immutability and data-first design felt like a natural fit for an application that's all about transforming and querying data.