Informix MCP Server
Provides an interface for interacting with Informix databases, allowing database exploration, table information retrieval, and custom SQL query execution within a Node.js environment.
Facilitates installation and management of dependencies required for the Informix MCP server through npm package management.
Implements the MCP server using TypeScript for type safety and better developer experience when building Informix database interactions.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Informix MCP Server show me the tables in the sales database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Informix MCP Server
An MCP (Model Context Protocol) server for interacting with Informix databases.
Features
π Database exploration: Lists all available databases
π Table information: Gets table details including columns and data types
β‘ Custom queries: Executes custom SQL queries
π Connection testing: Verifies database connectivity
Related MCP server: sql-mcp
Installation
Clone this repository:
git clone <repository-url>
cd informix-mcpInstall dependencies:
npm installUsage
Development
npm run devProduction
npm run startAvailable Tools
get-tables
Gets all tables in a specific database.
Parameters:
database(string): Database name
Usage example:
// Get tables from database 'mydb'
const tables = await mcp.callTool("get-tables", { database: "mydb" });Configuration
To use this server with a real Informix database, you'll need to:
Install an Informix driver for Node.js
Configure connection credentials
Implement connection logic in the server
Recommended Drivers
node-odbcwith Informix ODBC driveribm_db(official IBM driver)informix(third-party driver)
Development
Project Structure
informix-mcp/
βββ main.ts # Main MCP server
βββ package.json # Dependencies and scripts
βββ tsconfig.json # TypeScript configuration
βββ README.md # DocumentationLicense
ISC
Available Tools
1 toolget-tablesB
Get all tables in the database
Inputs: database (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 1 tool
With only one tool, there is no possibility of ambiguity or overlap between tools. The single tool 'get-tables' has a clearly distinct and singular purpose, making it impossible for an agent to misselect between multiple options.
The naming follows a consistent verb_noun pattern with 'get-tables', and since there is only one tool, there is no inconsistency to evaluate. The naming is clear and predictable within this minimal set.
A single tool for a database server is too few for the apparent scope, as it lacks basic CRUD operations, querying, or other database management functions. This severely limits the server's utility and feels incomplete for a database domain.
The tool surface is severely incomplete for a database server, covering only table listing without any operations for data retrieval, insertion, updates, deletions, schema modifications, or other essential database interactions. This creates significant gaps that will cause agent failures in typical database workflows.
Related MCP Connectors
Model Context Protocol server for Studex tools, notifications, and profile integrations
A Model Context Protocol server for Wix AI tools
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yoβ¦
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.3-
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server for interacting with MSSQL and PostgreSQL databases, offering tools for schema exploration and SQL execution. It features configurable query modes for safety and supports advanced authentication methods like Windows Auth and SSL.11 npmMIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to interact with IBM i systems through the Model Context Protocol, providing secure SQL-based access to Db2 for i databases for querying, monitoring, and executing operations.Apache 2.0
- FlicenseAqualityDmaintenanceEnables running SQL queries, exploring metadata, and interacting with Teradata databases through the Model Context Protocol.44-