SmartDB_MCP — Universal Database MCP Gateway

Main

• Start with a readonly role: README’s permission examples list SELECT/SHOW/DESCRIBE/EXPLAIN as the safe baseline for agent DB access.

• Promote to writer/admin only for scoped tasks: keep agent workflows narrow and require human approval for schema changes.

• Use it as a gateway, not a superuser: store DB creds in an envfile and mount config as read-only where possible.

• Pair it with query review: use EXPLAIN + index/health tools (as listed in README tool list) before running heavy statements.

Source-backed notes

• README lists supported databases and includes a tool list (execute_sql, health checks, schema/index tools, SQL optimize, etc.).
• README shows pip install: pip install SmartDB-MCP and a start command example using smartdb --envfile=... --oauth=true.
• README shows role permission control examples for readonly/writer/admin SQL command sets.

FAQ

• Can I force read-only access?: Yes — README includes a readonly permission set limited to SELECT/SHOW/DESCRIBE/EXPLAIN.
• Which transport modes are supported?: README mentions stdio, sse, and streamableHTTP modes.
• How do I deploy quickly?: README provides docker-compose steps (up/ps/logs) and a manual docker build/run example.