execute_sql
Execute write SQL (requires --allow-any-sql)
How to use it
Project documentation lists execute_sql for the AdoMCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.
Install AdoMCP
dnx -y AdoMcpOther tools in AdoMCP (7)
Add (or replace) a database connection at runtime
Get table indexes
Get table schema details (columns/types/nullability/PK/default/comments)
List configured database connections
List database objects (table/view/procedure/function/trigger/sequence/synonym, etc.)
Execute read-only SQL and return CSV
Remove a dynamically-added connection