Pilot Database Bridge

该 Skill 提供基于 pilotctl 的命令流程：启动守护进程与网关、把远程主机映射为本地可访问地址、列出映射，随后用 psql、mysql、mongosh、redis-cli 等标准客户端访问位于 NAT 或防火墙后的 PostgreSQL、MySQL、MongoDB、Redis。需预先有 pilot-protocol 技能、运行中的守护进程和 pilotctl 二进制。

teoslayer

热度 35.48

最近更新 2026-05-11 17:41:28

分类：数据依赖：代码执行 / 第三方 API应用场景：数据处理 / 工作流 / 自动化脚本

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add pilot-database-bridge

Metadata

name: pilot-database-bridge
description: Query remote databases through Pilot Protocol tunnels. Use this skill when: 1. You need to access databases behind NATs or firewalls 2. You want to query remote databases without direct network access 3. You're building agents that need secure database connectivity Do NOT use this skill when: - Database is already publicly accessible - You have direct VPN or network access - The daemon is not running
tags: ["pilot-protocol","integration","database","bridge","sql"]
license: AGPL-3.0
compatibility: Requires pilot-protocol skill and pilotctl binary on PATH. The daemon must be running (pilotctl daemon start).
metadata: {"author":"vulture-labs","version":"1.0","openclaw":{"requires":{"bins":["pilotctl"]},"homepage":"https://pilotprotocol.network"}}
allowed-tools: ["Bash"]

Pilot Database Bridge

Secure database access through Pilot Protocol tunnels for remote PostgreSQL, MySQL, MongoDB, and Redis.

Commands

Start Gateway

pilotctl --json gateway start

Map Remote Database

pilotctl --json gateway map db-server 192.168.100.10

List Mappings

pilotctl --json gateway list

Stop Gateway

pilotctl --json gateway stop

Workflow Example

#!/bin/bash
# Access remote PostgreSQL

pilotctl --json daemon start
pilotctl --json find postgres-prod
pilotctl --json gateway start
pilotctl --json gateway map postgres-prod 192.168.100.10

# Connect with standard client
psql -h 192.168.100.10 -p 5432 -U dbuser -d production

Supported Databases

# PostgreSQL
pilotctl --json gateway map postgres-server 192.168.100.10
psql -h 192.168.100.10 -p 5432 -U user -d database

# MySQL
pilotctl --json gateway map mysql-server 192.168.100.11
mysql -h 192.168.100.11 -P 3306 -u root -p

# MongoDB
pilotctl --json gateway map mongo-server 192.168.100.12
mongosh mongodb://192.168.100.12:27017

# Redis
pilotctl --json gateway map redis-server 192.168.100.13
redis-cli -h 192.168.100.13 -p 6379

Dependencies

Requires pilot-protocol skill, running daemon, and database clients (psql, mysql, mongosh, redis-cli).