Execute read-only SQL query (SELECT and EXPLAIN PLAN only). CTEs (WITH ... SELECT) accepted. Use list_schemas to see available connections and their readonly status.

Insert a single row into a table. Commits automatically. Only available on writable connections (readonly=false in list_schemas). Returns the number of rows inserted.

Execute an UPDATE statement. Commits automatically. Only available on writable connections (readonly=false in list_schemas). Returns the number of rows updated.

Execute a DELETE statement. Commits automatically. Only available on writable connections (readonly=false in list_schemas). Returns the number of rows deleted.

Call a stored procedure or package procedure via anonymous PL/SQL block. Supports IN parameters only; OUT parameters are not supported. Commits automatically. Only available on writable connections.

Create or replace a trigger using a full DDL statement. The statement must start with CREATE. Commits automatically (DDL). Only available on writable connections.

Enable or disable a trigger via ALTER TRIGGER name ENABLE/DISABLE. Only available on writable connections.

Create or replace a procedure, function, or package using a full DDL statement. The statement must start with CREATE. Commits automatically (DDL). Only available on writable connections.

Execute any SQL statement without restrictions. SELECT returns CSV; DML returns row count. Set auto_commit=false for a dry-run: changes are rolled back after reporting the affected row count. Only available on writable connections.

List available Oracle connections/schemas with descriptions and readonly status. Use readonly field to determine which tools are available:

• execute_query: any connection

• insert_query / update_query / delete_query / call_procedure / create_trigger / set_trigger_status / create_procedure / execute_unsafe_query: readonly=false only.

Chama um serviço Sankhya via API REST.

Retorna JSON da resposta incluindo status ('1'=ok, '0'=erro) e responseBody. Use sankhya_list_connections para ver as conexões disponíveis.

Lista conexões Sankhya disponíveis com auth_url, base_url e status padrão.

Retorna CSV com colunas: name, description, auth_url, base_url, is_default.