This MCP server provides secure remote execution and database query capabilities for AI copilot tools through policy-controlled SSH and PostgreSQL connections.
Core capabilities:
Execute SSH commands - Run commands on remote servers through configured profiles with command allowlists, output quotas, execution timeouts, and concurrency limits
Query PostgreSQL databases - Execute SQL queries with statement pattern restrictions, row limits, and execution time constraints
Train machine learning classifiers - Orchestrate classifier training jobs remotely using SSH profiles with customizable command templates and subclass iteration
Enforce security policies - All operations governed by command regex patterns, execution limits, and production mode enforcement
Manage credentials securely - Store secrets via environment variables, filesystem paths, or inline JSON with support for base64-encoded keys
Control concurrency - Limit simultaneous operations per profile with cancellation-aware execution and progress notifications
Test and debug - Built-in simulator and integration test suite for testing without external AI client tools
Integrate with AI Copilots - Connect to GitHub Copilot in VS Code, Cursor, or other MCP-compatible AI tools
Enables execution of database queries against PostgreSQL databases through RDBMS connections
Infer MCP Server
This is an MCP (Model Context Protocol) server providing resource access via SSH and RDBMS connections. It is designed to integrate with AI Copilot tools like GitHub Copilot in VS Code and Cursor.
Setup
Install dependencies:
npm installBuild:
npm run buildRun:
npm start
Features
SSH command execution enforced through configured profiles, command allowlists, and output quotas
PostgreSQL database queries limited to configured connections and statement patterns
Per-profile concurrency limits with cancellation-aware execution and progress notifications
Classifier training orchestration via SSH profiles
Configuration
The server loads configuration from either INFER_MCP_CONFIG_PATH (JSON file) or INFER_MCP_CONFIG (inline JSON string). A starter config is available at config/sample-config.json; copy .env.example to .env and update paths/secrets as needed.
Secrets can be provided inline, via environment variables, or read from disk. Example:
sshProfilesdefine reusable credentials for tools such assshExecuteandtrainClassifier. Forpassword,privateKey, orpassphrase, supply either a raw string,{ "env": "VAR_NAME" }, or{ "path": "relative/or/absolute" }. Base64-encoded files are supported with{ "path": "...", "encoding": "base64" }. Policies control command allowlists, maximum runtime, captured output size, and per-profilemaxConcurrentslots. The sample config includes alocal-testprofile against127.0.0.1with placeholder credentials (tester/changeme) so you can quickly exercise SSH tooling via a local daemon—update these values before real use.databaseProfilescentralise PostgreSQL access. Statements must match the configured regex allowlists and respect row/time limits, withmaxConcurrentrestricting simultaneous queries per profile.trainingcontrols defaults for classifier jobs.
Integration
Configure in your AI tool's MCP settings to connect to this server.
For VS Code GitHub Copilot: Add to mcp.json in .vscode folder.
Debugging
You can debug this MCP server using VS Code's debugger.
Simulator
Build the project (npm run build) and use the simulator to exercise tools locally without an agent client:
Override defaults with environment variables:
MCP_SERVER_COMMAND– binary to launch (defaultnode)MCP_SERVER_ARGS– comma-separated arguments (defaultbuild/index.js)MCP_SERVER_CWD– working directory for the spawned server
For staging validation, copy config/staging-config.json, populate the referenced secrets, and set INFER_MCP_CONFIG_PATH=$(pwd)/config/staging-config.json before running npm run simulate -- … commands. For quick localhost smoke-tests, aim INFER_MCP_CONFIG_PATH at config/sample-config.json, ensure your SSH server accepts the local-test credentials, or tweak that profile to match an existing local account. The server runs in permissive local-test mode by default; set INFER_MCP_MODE=production to re-enable SSH policy enforcement for the loopback profile when you deploy.
Integration Testing
Build the project (
npm run build) so the simulator artifact exists.Configure staging credentials via
INFER_MCP_CONFIG_PATHorINFER_MCP_CONFIG(the staging sample references environment variables and secret files underconfig/secrets/).Run
npm run test:integrationto execute Vitest suites that shell out to the simulator (guarded byINTEGRATION=1).The integration suite expects the simulator to list
sshExecute,dbQuery, andtrainClassifier; extendtests/integration/with additional cases as you add tools.