Skip to main content
Glama
blakecodes

Informix MCP Server

by blakecodes

Informix MCP Server

A Model Context Protocol server for IBM Informix databases. Connects via JDBC using jaydebeapi, so no Informix Client SDK installation is needed -- just a JDBC driver JAR and Java.

Prerequisites

  • Python 3.11+

  • uv (Python package manager)

  • Java 8+ (JDK or JRE)

An Informix JDBC driver JAR is bundled in the drivers/ directory. To use a different version, either replace the JAR in drivers/ or set the INFORMIX_JDBC_DRIVER_PATH environment variable.

Related MCP server: MySQL MCP Server

Available Tools

Tool

Description

test_connection

Test connectivity and return the Informix server version

list_databases

List all databases on the server (queries sysmaster:sysdatabases)

list_tables

List user tables in a database, optionally including views and system tables

describe_table

Get column names, types, lengths, and nullability for a table

execute_query

Run arbitrary SQL with a configurable row limit

get_table_indexes

Show indexes on a table (name, type, clustered)

get_table_constraints

Show PK, FK, unique, and check constraints for a table

All tools accept an optional database parameter to target a specific database. If omitted, the default database from INFORMIX_DATABASE is used.

Setup

Cursor IDE

Add the following to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "informix": {
      "command": "/path/to/uv",
      "args": [
        "run",
        "--directory",
        "/path/to/informix-mcp",
        "informix-mcp-server.py"
      ],
      "env": {
        "JAVA_HOME": "/path/to/java/home",
        "INFORMIX_HOST": "your-host.example.com",
        "INFORMIX_PORT": "5020",
        "INFORMIX_DATABASE": "your_database",
        "INFORMIX_SERVER": "your_informix_server",
        "INFORMIX_USER": "your_user",
        "INFORMIX_PASSWORD": "your_password",
        "INFORMIX_DBDATE": "MDY4"
      }
    }
  }
}

After saving, restart the MCP server from Cursor Settings > MCP.

Claude Desktop

Add the following to your Claude Desktop config file:

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

  • Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "informix": {
      "command": "/path/to/uv",
      "args": [
        "run",
        "--directory",
        "/path/to/informix-mcp",
        "informix-mcp-server.py"
      ],
      "env": {
        "JAVA_HOME": "/path/to/java/home",
        "INFORMIX_HOST": "your-host.example.com",
        "INFORMIX_PORT": "5020",
        "INFORMIX_DATABASE": "your_database",
        "INFORMIX_SERVER": "your_informix_server",
        "INFORMIX_USER": "your_user",
        "INFORMIX_PASSWORD": "your_password",
        "INFORMIX_DBDATE": "MDY4"
      }
    }
  }
}

After saving, restart Claude Desktop for the changes to take effect. The Informix tools will appear in the tools menu (hammer icon) when starting a new conversation.

Environment Variables

Variable

Required

Description

JAVA_HOME

Yes

Path to a JDK/JRE home directory

INFORMIX_HOST

Yes

Informix server hostname

INFORMIX_PORT

Yes

Informix SQLI port

INFORMIX_DATABASE

Yes

Default database name

INFORMIX_SERVER

Yes

Informix server instance name (INFORMIXSERVER)

INFORMIX_USER

Yes

Database username

INFORMIX_PASSWORD

Yes

Database password

INFORMIX_DBDATE

No

Date format (defaults to MDY4)

INFORMIX_JDBC_DRIVER_PATH

No

Override path to a JDBC driver JAR (defaults to bundled drivers/*.jar)

Running Standalone

# Install dependencies
uv sync

# Run (with env vars set)
uv run informix-mcp-server.py

The server communicates over stdio using the MCP protocol.

Switching Environments

To connect to a different Informix instance, update the env values in mcp.json with the new host, port, server name, database, and credentials. Restart the MCP server after changing environment variables.

F
license - not found
-
quality - not tested
D
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • F
    license
    B
    quality
    D
    maintenance
    Enables interaction with Informix databases through a Model Context Protocol server, supporting database exploration, table inspection, and custom SQL query execution.
    1
    1
  • -
    license
    -
    quality
    -
    maintenance
    Enables interaction with MySQL databases through MCP tools for querying table structures, searching data across single or multiple tables, and managing database information. Built with FastMCP framework for secure database operations using environment-based configuration.
  • A
    license
    -
    quality
    C
    maintenance
    Provides tools to connect, query, and manage Microsoft SQL Server databases through the MCP protocol, including support for stored procedures, transactions, and schema inspection.
    MIT

View all related MCP servers

Related MCP Connectors

  • GibsonAI MCP server: manage your databases with natural language

  • MCP server for managing Prisma Postgres.

  • Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/blakecodes/informix-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server