Field

Value

Product

SentryFrogg MCP Server

Version

4.2.0

Runtime

Node.js ≥ 16

Interfaces

Model Context Protocol (PostgreSQL · SSH · HTTP)

License

MIT

Capability

Detail

PostgreSQL control

Parameterised SQL, catalog discovery, CRUD helpers, mutual TLS, connection profiling.

SSH execution

Serial command dispatch per profile, password/key authentication, reachability diagnostics.

HTTP access

REST verbs with JSON payloads, health checks, programmable headers and bearer tokens.

Secret vault

AES-256 encrypted profiles persisted in profiles.json with managed key material.

Telemetry

Tool-level statistics via getStats() for integration with monitoring stacks.

Component

Scope

sentryfrogg_server.cjs

MCP entry point, tool catalogue, lifecycle supervision.

src/bootstrap/ServiceBootstrap.cjs

Service registration, dependency wiring, resource cleanup.

src/managers/PostgreSQLManager.cjs

SQL execution, profile validation, TLS configuration, pool management.

src/managers/SSHManager.cjs

SSH sessions, sequential execution enforcement, profile hygiene.

src/managers/APIManager.cjs

HTTP invocation, header synthesis, response shaping.

src/services/ProfileService.cjs

Encrypted persistence and retrieval of profile objects.

src/services/Security.cjs

Key lifecycle, cryptographic primitives, payload size guards.

src/services/Validation.cjs

Canonical validation for incoming payloads.

Attribute

Specification

Required flow

setup_profile → downstream action using same profile_name.

Actions

setup_profile, list_profiles, quick_query, show_tables, describe_table, sample_data, insert_data, update_data, delete_data, database_info.

Credentials

Either discrete fields (host, port, username, password, database) or connection_url.

TLS options

ssl_mode, ssl_ca, ssl_cert, ssl_key, ssl_passphrase, ssl_servername, ssl_reject_unauthorized; omitted values reuse stored secrets.

Query rules

quick_query injects LIMIT 100 when absent; bind variables supplied via params array ($1, $2, ...).

Response format

JSON with success, rows, rowCount, fields, command; failures raise MCP internal errors.

Rejection triggers

Missing profile, malformed SQL, payload limits exceeded, invalid TLS configuration.

Attribute

Specification

Required flow

setup_profile (password or PEM private_key, optional passphrase) → operational action.

Actions

setup_profile, list_profiles, execute, system_info, check_host.

Execution model

Commands trimmed and length-limited; pipes/redirects permitted; per-profile execution is strictly sequential.

Outputs

JSON containing success, stdout, stderr, exitCode, durationMs; errors propagate as MCP internal errors.

Security posture

Secrets encrypted at rest; no templating—agents must supply fully qualified commands.

Attribute

Specification

Actions

get, post, put, delete, patch, check_api.

Inputs

url (required), data (JSON body for mutating verbs), headers (string map), auth_token (prefixed into Authorization unless already set).

Behaviour

Local and private addresses allowed; HTTP status/body returned in structured JSON; transport or parsing failures emit MCP internal errors.

Task

Command

Clone and install

git clone https://github.com/yourusername/sentryfrogg-mcp.git && cd sentryfrogg-mcp && npm install

Syntax check

npm run check

Launch (stdio)

node sentryfrogg_server.cjs

Update dependencies

npm install --package-lock-only && npm audit fix --only=prod (subject to governance)

Reset profile store

Remove profiles.json after confirming backups

Symptom

Diagnostic Actions

Remediation

PostgreSQL TLS failure

Inspect ssl_mode, ssl_servername, certificate chain, Postgres logs.

Update TLS materials; rerun setup_profile.

SSH command hang

Validate command length, ensure non-interactive execution, check remote prompts.

Adjust command or script; rerun setup_profile if credentials changed.

HTTP error response

Review returned status/body, verify headers and auth_token.

Correct payload; retry request.

Missing profile

Execute list_profiles to confirm presence; ensure consistent profile_name.

Recreate via setup_profile.