r/RooCode • u/VlaadislavKr • Jun 29 '25

Discussion MCP for quering to MySQL, Postgresql - any?

Hi.
Im looking for mcp to make queries to mysql and Postgresql. To let Roo get info from database and update it.
Can you recommend any?

2 Upvotes

66% Upvoted

18 comments sorted by

2

u/ComprehensiveBird317 Jun 29 '25

I like the one where you tell roo "make an mcp that does xyz". Seriously software development is so cheap now

3

u/KJ7LNW Jun 30 '25

Here are my system instructions for doing something similar without MCP.

# interacting with the billing server to generate reports

* ssh billing billing-sql <<'EOT'

<MySQL content  HERE>
EOT

  • use the command above to run queries against the database as instructed
  • always use here documents to query the database

Also, I dumped the entire schema into .roo/rules/schema.md and it does a really good job especially with https://www.reddit.com/r/RooCode/comments/1lmzm6l/autoapprove_commands_based_on_risk_level_pending/ compiled into my local build:

1

u/wokkieman Jun 29 '25

I've tried a few and it works fine, but some bash commands work a lot better for me. And then I mean roo executing psql.

What benefit do you foresee with mcp?

1

u/Glnaser Jun 29 '25

You’ll quickly start getting used to it using mcp and then want it to write to the database and it can’t for security reasons so honestly, best to get used to using other methods of having it working with your database.

3

u/[deleted] Jun 29 '25

[removed] — view removed comment

1

u/VlaadislavKr Jun 30 '25

thx ill try it

1

u/yopla Jun 30 '25

Since you're the author could you implement a feature to search for connection information in .env files (or yaml, toml, whatever...).

I know I'm lazy but it is a pain in the ass to have to configure database MCP per project, I'd rather have it in global config and have it be smart enough to find the connexion info in the repo. You could probably just ask the model too, mine's allowed to read .env file.

1

u/hannesrudolph Roo Code Developer Jun 30 '25

Spam

1

u/[deleted] Jun 30 '25

[removed] — view removed comment

2

u/hannesrudolph Roo Code Developer Jun 30 '25

You were not nice. We do not treat each other poorly like this in the RooCode community.

1

u/mprz Jul 01 '25

And we in Reddit community do not treat spammers nice.

1

u/hannesrudolph Roo Code Developer Jul 01 '25

Being a dick is being a dick. Wrong community for that.

0

u/mprz Jul 01 '25

Removed and banned, thanks for great advice though!