Main
Use read-only mode first: validate schema access and Text2SQL accuracy before enabling any write permissions.
Pick your transport based on deployment: stdio for local MCP hosts; Streamable HTTP/SSE when you need remote connections (Dify, services).
For large schemas, rely on caching and batch schema retrieval; README includes a table showing 25x–100x improvements as table counts grow.
Source-backed notes
- README claims “17 database support” and lists MySQL/PostgreSQL/Redis/Oracle/SQL Server/MongoDB/SQLite plus additional vendors.
- README states read-only is the default and describes permission modes for write operations.
- README shows two startup modes (stdio/http) and multiple access methods (MCP stdio, SSE, Streamable HTTP, REST API).
FAQ
- Is write access enabled by default?: No — README says read-only is the default and write permissions must be explicitly enabled.
- Which transport should I choose?: Use stdio for local Claude Desktop/Cursor; use Streamable HTTP/SSE for remote deployments.
- How does it handle large schemas?: README documents schema caching and batch retrieval, with a performance table up to 100x improvements.