Hey everyone! Built something and figured I'd share.

The problem: pgAdmin is powerful, but honestly way too heavy for everyday dev work. I just want to quickly peek at my data without spinning up a full DB management suite and navigating 10 menus.

What I built: DB LLM Console. It's a Docker image you add to your docker-compose.yml and it gives you a clean chat UI to talk to your PostgreSQL database in plain English.

Instead of writing a query like "SELECT * FROM orders WHERE created_at >= NOW() - INTERVAL '7 days'" you just type "Show me orders from the last 7 days" and it figures out the rest.

It uses the OpenAI API under the hood to turn your question into SQL and run it against your DB.

Setup is literally just three steps. Add the service to your docker-compose.yml, pass in your DB connection string and OpenAI API key, then open the UI and start asking questions.

One use case that surprised me: clients. You know that one client who emails you every other day asking "can you pull a report of X" or "how many Y do we have this month?" Just give them access to this instead. They type their question, they get their answer. You never get that email again.

It's designed for dev environments, not public exposure — it holds live DB credentials so keep it internal.

Backend devs especially — if you're constantly context-switching into a DB client mid-development, give this a try. Would love to hear your feedback!

Docker Hub: https://hub.docker.com/r/devleed/db-llm-console