Safe read-only mode of the table schemas #70
Description
Congrats for making this MCP available!
That's the future!
A very good use case would be to use the LLM to generate SQL queries by introspecting the database/workspace tables and their columns.
We often need to join several tables in the same way, join on JSON columns, make sure we select the right conditions for the tables (not-soft-deleted rows, having several synced statuses...)...
Queries can take some time to create, and an LLM is perfect for these (we have to give it hints on how to join on JSON columns, etc. but once it's setup, LLM can greatly help us).
However, trusting an LLM to execute SQL queries without hallucinating is worrying :-)
And currently, listing the tables and describing them can only be performed through SQL.
We'd like to get a read-only mode that can only introspect the database.
Or at lease some commands that are specifically designed for this read-only mode.
As an example, this MCP can be used in RooCode for the IDE agent to be able to inspect the Postgres database in a safe way:
https://github.com/modelcontextprotocol/servers-archived/tree/main/src/postgres