Back to articles
I Gave Claude Code Access to My Prod Database with MCP
How-ToTools

I Gave Claude Code Access to My Prod Database with MCP

via Dev.toSpencer Pauly

Last week I did something that would've made me uncomfortable six months ago. I opened my Claude Desktop config, added an MCP server URL pointing at my production Postgres database, and told Claude to go look at real customer data. Nothing caught fire. I've been building QueryBear for a while now, and I'd always been careful to test against staging data, demo databases, seed data. Production was the thing I protected. But I kept hitting the same wall. I'd be deep in a debugging thread with Claude, connected to Linear and my codebase, and I'd get 90% of the way to understanding a customer issue. Then I'd tab over to my database client, look up the user, write a couple joins, squint at the results, copy them back into chat. Every single time. It's not hard. It's just friction. After doing it fifty times in a week I started thinking: why am I the bottleneck here? So I built an MCP server that sits between the AI and my database. The AI doesn't get a connection string. It doesn't get crede

Continue reading on Dev.to

Opens in a new tab

Read Full Article
5 views

Related Articles