DDL和DML自动授权

[coderlindacheng]

现在agent执行DDL和DML都需要获得人工的授权，无法做到全自动完成，可以新增一个可选的开关，让DDL和DML可以自动授权么？因为通常使用tabularis都是出于开发环境的状态，其实改坏了数据库的问题并不大的

[debba]

Good news: this already exists. Tabularis ships with an approval gate that has three modes, and you can turn it off entirely.

Open the MCP settings in Tabularis and look for the "Approval gate" section. The "Approval required" setting has three options:

• Off - no manual approval, the agent runs DDL/DML fully unattended (what you are asking for)
• Writes only (default) - only non-SELECT statements pause for approval
• All queries - every query pauses for approval

Set it to Off for your dev environment. Two things to keep in mind:

1. The read-only settings in the same section are independent: if a connection is marked read-only, writes from MCP are still blocked regardless of the approval mode. Make sure your dev connection is allowed to write.
2. The MCP subprocess reads this setting at startup, so restart the MCP connection in your AI client after changing it.

This way you keep the safety default for production-ish connections while going fully automatic in dev.