MCP Server: SSH Rails Runner

An MCP server that enables secure remote execution of Rails console commands via SSH. This server provides tools for both read-only operations and carefully managed mutations in a deployed Rails environment.

This works great with Cursor. You can use Cursor Composer to pull in your Rails model files as context and then use the execute_read_only, dry_run_mutate, and execute_mutate tools to make changes to the database. No need to trudge through complicated Admin UI's to get your data wrangling and analysis done.

Example

Features

• Remote Rails console execution over SSH
• Safe read-only operations
• Dry-run capability for mutations
• Execution of approved mutations
• Resource management for code snippets

Installation

npm install
npm run build

Configuration

Set the following environment variables:

SSH_HOST=your.remote.host
SSH_USER=your_ssh_user
SSH_PRIVATE_KEY_PATH=your_SSH_PRIVATE_KEY_PATH
RAILS_WORKING_DIR=/path/to/rails/app

Usage with Claude Desktop

Add to your Claude Desktop configuration:

{
    "mcpServers": {
        "ssh-rails-runner": {
            "command": "npx",
            "args": ["mcp-server-ssh-rails-runner"],
            "env": {
                "SSH_HOST": "your.remote.host",
                "SSH_USER": "your_ssh_user",
                "SSH_PRIVATE_KEY_PATH": "your_SSH_PRIVATE_KEY_PATH",
                "RAILS_WORKING_DIR": "/path/to/rails/app/root"
            }
        }
    }
}

Available Tools

run_read_only

Executes read-only Rails console operations. The tool will analyze the request, formulate safe read-only commands, and return the results.

dry_run_mutate

Plans and validates potential mutations. Creates a code snippet resource with the proposed changes without executing them.

execute_mutate

Executes previously approved mutation code snippets. Requires explicit user approval of a code snippet resource before execution.

Security Considerations

• Only use with trusted SSH endpoints from your own local machine that is (temporarily) provided access to the remote environment
• Review all mutations before execution

License

MIT