Skills
.Work. You
Rest

integration-postgres

Community

Wire PostgreSQL to Hermes safely

Software Engineering#deployment#postgresql#mcp#ssh#database integration#hermes#read-only access
Authorpaarths-collab
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill connects a PostgreSQL database to a self-hosted Hermes agent over SSH, so an AI agent can work with database-backed systems without manual wiring or fragile one-off setup.

Core Features & Use Cases

  • Secure database onboarding: Stores and verifies a PostgreSQL connection string on the VPS and keeps the setup idempotent.
  • MCP integration: Registers the Crystal DBA postgres-mcp server for stdio-based access when Path A is used.
  • Safety guardrails: Encourages scoped read-only users, rejects risky superuser-style credentials by default, and includes rollback steps.
  • Operational verification: Reloads the Hermes gateway and performs live connection smoke tests to confirm the integration works.

Quick Start

Ask the AI to connect your PostgreSQL database to your Hermes VPS using a scoped read-only user, then verify the live connection and complete the MCP wiring.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: integration-postgres
Download link: https://github.com/paarths-collab/hstack/archive/main.zip#integration-postgres

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 536,000+ vetted skills library on demand.