Tools¶
The Actian MCP Server for HCL Informix® provides built-in tools for database discovery and read-only query execution.
Available Tools¶
| Tool | Description |
|---|---|
execute_query | Runs a read-only SQL query against the connected database. |
list_tables | Lists available user tables and views. |
describe_table | Displays column definitions, data types, and key information for a table. |
list_functions | Lists available user-defined functions and procedures. |
execute_query¶
Use this tool to run read-only SQL queries. The results are returned as structured JSON.
Result truncation
The truncated and warning fields appear only when the number of result rows exceeds the max_rows configuration.
Parameters¶
| Field | Type | Required | Description |
|---|---|---|---|
query | string | ✓ | The read-only SQL statement you want to execute. |
Output Schema¶
On Success
{
"success": true,
"columns": ["<result_columns>"],
"rows": [["<result_rows>"]],
"row_count": "<num_rows>",
"truncated": true,
"warning": "Results were truncated to <max_rows> rows."
}
On Error
{
"success": false,
"error": "<error_message>"
}
Example¶
User Request
Show me all the rows in the customers table
Input
{
"query": "SELECT * FROM customers"
}
Response
{
"success": true,
"columns": ["customer_id", "customer_email"],
"rows": [
[101, "alice@tech.com"],
[102, "bob@corp.net"]
],
"row_count": 2
}
list_tables¶
Returns all user tables and views available in the connected database as structured JSON.
Parameters¶
This resource does not require any input parameters.
Output Schema¶
On Success
{
"success": true,
"columns": ["table_name"],
"rows": [["<table_name>"]],
"row_count": 1
}
On Error
{
"success": false,
"error": "<error_message>"
}
Example¶
User Request
Show me all the tables in my database
Response
{
"success": true,
"columns": ["table_name"],
"rows": [
["customers"],
["orders"]
],
"row_count": 2
}
describe_table¶
Returns schema details for a table, including column names, data types, lengths, scales, and column comments.
Parameters¶
| Field | Type | Required | Description |
|---|---|---|---|
table_name | string | ✓ | Name of the table to describe. |
Output Schema¶
On Success
{
"success": true,
"columns": [
"column_name",
"column_datatype",
"column_length",
"null_column",
"key_type"
],
"rows": [["<column_name>", "<column_datatype>", "<column_length>", "<null_column>", "<key_type>"]],
"row_count": "<num_rows>"
}
On Error
{
"success": false,
"error": "<error_message>"
}
Example¶
User Request
Show me schema information about the customers table
Input
{
"table_name": "customers"
}
Success Response
{
"success": true,
"columns": [
"column_name",
"column_datatype",
"column_length",
"column_scale",
"column_comment"
],
"rows": [
["customer_id", "integer", "4", "YES", "P"],
["email", "varchar", "50", "NO", "None"]
],
"row_count": 2
}
Error Response
{
"success": false,
"error": "No permission to access table 'table name'"
}
list_functions¶
Returns user-defined functions and procedures, including their stored definitions, as structured JSON.
Parameters¶
This resource does not require any input parameters.
Output Schema¶
On Success
{
"success": true,
"columns": ["function_name","type", "function_ddl"],
"rows": [["<function_name>", "<type>","<function_ddl>"]],
"row_count": 1
}
On Error
{
"success": false,
"error": "<error_message>"
}
Example¶
User Request
Show me all the functions in my database
Response
{
"success": true,
"columns": ["function_name", "function_ddl"],
"rows": [
["calculate_discount","FUNCTION", "CREATE FUNCTION calculate_discount(...) ..."],
["refresh_sales_summary","PROCEDURE", "CREATE PROCEDURE refresh_sales_summary() ..."]
],
"row_count": 2
}