Execute SQL and return results as a table. For DDL/DML with no result set, returns a short status line. Args: ctx: The context of the tool call. sql: The SQL query to execute. parameters: The parameters to pass to the SQL query.

Insert a single row into a table. Args: ctx: The context of the tool call. table_name: The name of the table to insert the data into. values: The values to insert into the table. table_schema: The schema of the table to insert the data into.

List all tables in a specific schema. Args: ctx: The context of the tool call. table_schema: The schema of the tables to list.

Show columns and types for a table. Args: ctx: The context of the tool call. table_name: The name of the table to describe. table_schema: The schema of the table to describe.

Creates a standard index to speed up queries. Args: ctx: The context of the tool call. table_name: The name of the table to create the index on. column_name: The name of the column to create the index on. index_name: The name of the index to create. table_schema: The schema of the table to create the index on.

Creates a table and imports data from a CSV string. The first row of the CSV must be the header (column names). All columns will be created as VARCHAR(255) for this blueprint. Args: ctx: The context of the tool call. table_name: The name of the table to import the data into. csv_content: The content of the CSV file to import. table_schema: The schema of the table to import the data into.

Export rows from an existing IRIS table as JSON, CSV, or TXT (pipe-separated).

The result is returned as a single string the caller can preview, copy to a file, or stream to a downstream client. For large tables narrow the result with columns, where, and/or limit to keep responses manageable.

Check if a global exists (e.g., 'MCPData'). Args: ctx: The context of the tool call. global_name: The name of the global to check.

Save a value to a global node. Use subscripts for ^g(1,"a") style paths (e.g. [1, "Prova"]). Args: ctx: The context of the tool call. global_name: The name of the global to save the value to. value: The value to save to the global. subscripts: The subscripts of the global to save the value to.

Read a global node (same subscript rules as save_global). Args: ctx: The context of the tool call. global_name: The name of the global to read. subscripts: The subscripts of the global to read.

List subscript keys under a global path using the IRIS node iterator (ZORDER-style). Args: ctx: The context of the tool call. global_name: top global without ^ (e.g. BTHo). subscripts: path into the global, e.g. ["DufT", 3] for ^BTHo("DufT",3,... recursive: if True, each line is a full path from the start node; max_depth is how many subscript levels to descend below the starting path (1 = only immediate children). max_depth: how many subscript levels to descend below the starting path (1 = only immediate children). max_nodes: maximum number of nodes to return (default: 2000). include_values: if True, include the values of the nodes.

Run an ObjectScript ClassMethod. Args: ctx: The context of the tool call. class_name: The name of the class to run the method on. method_name: The name of the method to run. args: The arguments to pass to the method.

Search for a string across IRIS source documents (Atelier action/search).

Calls GET /api/atelier/<ver>/<ns>/action/search (v2+). Both query and documents are required by the server; missing documents returns HTTP 400.

Read .cls source code using Atelier REST API.

Return the name of the currently active Interoperability production on the current namespace.

Start an Interoperability production by class name (must already exist and be compiled).

Calls ##class(Ens.Director).StartProduction(productionName) (single-argument form compatible with the IRIS Native SDK and servers where the two-argument sync overload is not exposed to Python). It does not create the production class; use create_empty_production or deploy a class from source, then call this tool.

Stop the currently running Interoperability production in this namespace.

Calls ##class(Ens.Director).StopProduction().

Create and compile a new empty Ens.Production subclass in the current namespace.

Uses the Atelier REST API (PutDoc + action/compile) — same web host/credentials as other Atelier tools (IRIS_WEB_PORT, IRIS_ATELIER_API_VERSION).

List the items currently configured in a production on the current namespace.

Add a Business Host (Service / Process / Operation) to a production on the current namespace.

Remove a Business Host from a production.

List the configured setting overrides on a Business Host (Service / Process / Operation) inside a production.

Only settings explicitly stored on the Ens.Config.Item are returned — settings that still use the class-level defaults are NOT listed (they are not present in item.Settings). The output combines both Host and Adapter targets and is meant as input to update_production_item_settings.

Update (or create) one or more setting overrides on an existing Business Host inside a production.

For each (name, value) entry in settings:

• if the host already has an override with that Name and Target, its Value is overwritten;

• otherwise a new Ens.Config.Setting is appended with the given Target.

The production is then persisted with SaveToClass + %Save. To make the changes take effect on a running production without a full restart, call update_production afterwards (equivalent to clicking "Update" in the Management Portal).

Apply pending configuration changes to the running production (equivalent to clicking 'Update' in the Management Portal).

Calls ##class(Ens.Director).UpdateProduction(). Only the active production is updated; production_name is reserved for future use and ignored.

Create or update a CSP web application that exposes an HTTP-based Business Service (typically EnsLib.REST.GenericService) to the outside world.

Delegates to the ObjectScript helper because 'Security.Applications' requires switching to the %SYS namespace, which is cleaner to do in ObjectScript than over the Native SDK.

Authentication is set to Unauthenticated for development convenience. Tighten this before going to production.

Delete a CSP web application by URL path (delegates to ObjectScript).