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 "Install 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 Servershow 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: MSSQL MCP Server
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