I am coming around to why MCP is so impressive.
For one of my side projects, I used to have to log onto my database admin (PgAdmin) to query stuff.
I connected an MCP server to Postgres and can "talk" with my database (and data!)
An uplevel in my productivity + ease of work.
For one of my side projects, I used to have to log onto my database admin (PgAdmin) to query stuff.
I connected an MCP server to Postgres and can "talk" with my database (and data!)
An uplevel in my productivity + ease of work.
Comments
The coding AIs would get upgraded from a stubborn vim fan using grep and command line tools to an ide user, with symbol lookup, intellisense, red squigglies, refactoring commands, etc etc
I have a service that sends our promo codes for Perplexity and Kagi that paid newsletter members can claim: https://newsletter.pragmaticengineer.com/p/free-kagi-and-perplexity-access
I can now "talk" with the data from my IDE to get all kinds of details!
Was impossible till now
Have a shell open on your local db for development makes a lot more sense than some json to sql stuff that queries the db…
Why tab completion etc in your sql prompt if you can do json in your IDE?
You need prod -> ssh
I like that it's one less tool running, one less interface, and I can do more powerful stuff during dev time
Just my two cents on what is an improvement for my dev flow
I just use one xterm and screen to have shells: git, psql, curl,…
I guess I am a bit purist but it is really powerful. And C-r search history helps to do less typing.
"Has there been an unsual spike of signups the last 2 months?"
"What are suspicious-looking emails signing up recently? Any patterns?"
"Which domains have the most number of signups?"
"How many unclaimed promo codes are left?"
"Has there been an unsual spike of signups the last 2 months?"
"What are suspicious-looking emails signing up recently? Any patterns?"
"Which domains have the most number of signups?"
"How many unclaimed promo codes are left?"
I'm also experimenting with MCP for wider range, but did this experimental "chat/graph with data" project that is pretty convincing that chat *IS* the interface for data exploration.
https://github.com/jeffbryner/illuminaite/
For a product guy who’s not good enough with tech, it’s empowering.
Not having this already in your analytics or as plain db view means it either wasn’t important or you were negligent.
Sure, you might have dashboard for KPIs, but not for “I wonder what…” questions that pop into your mind. Answers with low effort is a superpower