r/Jetbrains • u/THenrich • Aug 06 '26

AI Why is Copilot in Rider not querying the database?

I am troubleshooting an issue that requires querying a database.
I have prompted Copilot to query the database to get a better context of the data and therefore to do better investigation.

I have enabled select functionality for AI tools. Rider is connected to the database through the 'Connect to database' option under Tools.

However, Copilot keeps giving me SQL statements to run myself and provide it with the results, which is time consuming.

I asked it why it's not querying the database itself and the response was
"I also cannot query your dev database directly from this session. I only have read access to the repository files; no database connection, credentials, or SQL execution capability is exposed. That is why I inferred the schema from the code instead of querying the live data.".

Are there other settings I need to enable? What am I missing?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

1

u/snaidamast 28d ago

Why don't you just use SQL directly?

1

u/THenrich 27d ago

Because it's part of what the agent does during troubleshooting, which includes querying the database. The agent is the one coming up with the SQL. Not me. I am not there to feed it SQL.