query_sql

MCP tool from AdoMCP by John0King

Execute read-only SQL and return CSV

How to use it

Project documentation lists query_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 AdoMcp

FULL ADOMCP LISTING

Other tools in AdoMCP (7)

add_connection

Add (or replace) a database connection at runtime

execute_sql

Execute write SQL (requires --allow-any-sql)

get_table_indexes

Get table indexes

get_table_schema

Get table schema details (columns/types/nullability/PK/default/comments)