mcp-informix mcp

v1.0.0 · MCP Tool · database · registry.pascalai.org

IBM Informix 12.10+ and HCL Informix 14+ via FireDAC native driver. Operations: query (SELECT → rows JSON), execute (INSERT/UPDATE/DELETE/DDL), execute_tx (transaction), list_tables (from systables), describe (from syscolumns), list_databases (from sysmaster). Default port: 9088. Requires IBM Informix Client SDK (ifcli.dll).

informixibmhcldatabasesqlfiredacenterprise

Input Parameters

ParameterTypeDescription
operationrequired string Operation to perform. One of: query, execute, execute_tx, list_tables, describe, list_databases.
hostrequired string Informix server host or IP (e.g. 'infxserver', '192.168.1.50').
portoptional integer Informix port. Default: 9088 (ol_informix1210 service). Default: 9088.
databaserequired string Database name (e.g. 'stores_demo', 'production').
usernameoptional string Informix username.
passwordoptional string Informix password.
sQLoptional string SQL statement. Required for query and execute. Use FIRST N for row limiting (e.g. SELECT FIRST 10 ...).
sQLListoptional string JSON array string of SQL statements for execute_tx.
tableoptional string Table name (lowercase in Informix). Required for describe.
schemaoptional string Owner/schema name for list_tables filter.
maxRowsoptional integer Maximum rows to return for query. Default: 100. Default: 100.
timeoutoptional integer Query timeout in seconds. Default: 30. Default: 30.

Output Fields

FieldTypeDescription
ok boolean
rows array[object]
affected integer
tables array[object]
columns array[object]
databases array[string]
error string

Examples

Query from Informix

// Input
{
  "operation": "query",
  "host": "infxserver",
  "database": "stores_demo",
  "username": "informix",
  "password": "secret",
  "sQL": "SELECT FIRST 10 customer_num, fname, lname FROM customer ORDER BY lname"
}

// Output
{
  "ok": true,
  "rows": [
    {
      "customer_num": 101,
      "fname": "Ludwig",
      "lname": "Pauli"
    }
  ]
}

List user tables

// Input
{
  "operation": "list_tables",
  "host": "infxserver",
  "database": "stores_demo",
  "username": "informix",
  "password": "secret"
}

// Output
{
  "ok": true,
  "tables": [
    {
      "tabname": "customer"
    },
    {
      "tabname": "orders"
    }
  ]
}

Install & Discovery

Install

ppm install mcp-informix

Get JSON Schema

GET /v1/packages/mcp-informix/1.0.0/schema

Discover by keyword

GET /v1/mcp/discover?q=informix
Discovery hint: Install with ppm install mcp-informix or invoke remotely via POST /v1/invoke/mcp-informix on the MCP Service.