postgres-remote-ops
CommunityRun remote PostgreSQL safely via OpenClaw
Authorecnepsyroc-bot
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Provide reliable ways to execute SQL against remote PostgreSQL instances when direct psql access is unavailable, when gateway timeouts kill long queries, or when command escaping across PowerShell, node, and cmd.exe layers breaks inline commands.
Core Features & Use Cases
- Node.js pg fallback: one-liners and scripts to run queries from machines without psql and to avoid complex escaping.
- SSH / batch execution: SSH into cambium-server (or via tunnel) and run psql or pre-created batch files to bypass gateway timeout limits and quoting problems.
- GUI and web fallbacks: use Railway Data tab, TablePlus, or DBeaver for quick ad-hoc queries and interactive fixes.
- Operational guidance: examples for ALTER TABLE, killing connections, verifying schema, and escaping rules across shells.
Quick Start
Run the query SELECT COUNT(*) FROM jobs on the remote Railway PostgreSQL using the run-sql.js Node script and return the JSON rows.
Dependency Matrix
Required Modules
None requiredComponents
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: postgres-remote-ops Download link: https://github.com/ecnepsyroc-bot/Dejavara/archive/main.zip#postgres-remote-ops Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.