execute_sql
Run SQL queries directly on the InterSystems IRIS MCP Server to monitor and manipulate data, ensuring efficient interoperability management.
Instructions
Execute an SQL query on the Server
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | ||
| query | Yes |
Implementation Reference
- src/mcp_server_iris/server.py:155-167 (handler)The main handler function for the 'execute_sql' tool. It executes the provided SQL query on the IRIS database connection, fetches up to 100 rows, and returns the results as text content. Registered via the @server.tool decorator.@server.tool(description="Execute an SQL query on the Server") async def execute_sql( query: str, ctx: Context, params: list[str] = [] ) -> list[types.TextContent]: # params = arguments.get("params", []) logger.info(f"Executing SQL query: {query}") conn = ctx.db with conn.cursor() as cursor: cursor.execute(query, params) # limit by 100 rows rows = cursor.fetchall()[:100] return [types.TextContent(type="text", text=str(rows))]