Pilot Database Bridge#

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

Commands#

Start Gateway#

bash

pilotctl --json gateway start

Map Remote Database#

bash

pilotctl --json gateway map db-server 192.168.100.10

List Mappings#

bash

pilotctl --json gateway list

Stop Gateway#

bash

pilotctl --json gateway stop

Workflow Example#

bash

#!/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#

bash

# 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).