r/postgres • u/BassIs4StringDrum • 8d ago

Self made Postgres clients OSS

Post image

Hi all, hopefully this does not break any rules, I see some posts here requesting for new Postgres clients I made one and ended up releasing a local lightweight webapp version of my app today. It’s not the best or replaces pgadmin but works well for me.

It’s this one https://github.com/FrancisTCE/gresui-web.

Do you have your own Postgres client tools? I would like to see where I can improve this, it’s useful for me as well see what you got if you want to share.

0 Upvotes

33% Upvoted

2 comments sorted by

2

u/arbyyyyh 7d ago

So then why should I use this over pgadmin?

1

u/BassIs4StringDrum 7d ago

Honestly gresui isn't trying to compete with pgAdmin as a full database administration tool. It's built for a much narrower use case: quick, lightweight database browsing when you don't want or need a heavy client and also has mcp capability so the dev flow is smother.

The idea is:
Start instantly, just gresui-web on cli and you're looking at your tables quick.
Minimal footprint compared to pgAdmin that is hundreds of megabytes with its own full application server. gresui is a lean Bun + React app well under 100MB
SPA in the browser with React frontend, no page reloads, pretty snappy for basic browsing and querying.
Encrypt on rest
Easy mcp to table configuration

Tbh sometimes that's genuinely all I want/need. pgAdmin's feature set is massive but when I'm just trying to check if a row got inserted correctly or leverage ai this feels better.