MySQLShellResults
MySQL style
SELECT region, SUM(amount) AS total
FROM orders
WHERE status = 'open'
GROUP BY region;
Mongo shell
db.orders.aggregate([
{ $match: { status: "open" } },
{ $group: { _id: "$region", total: { $sum: "$amount" } } }
])
MongoDB: MySQL-style query compiler plus native Mongo shell
ProfilesSyncVault
Connection profiles
Production MySQL synced
Atlas MongoDB synced
Analytics PostgreSQL synced
Local SQLite local
Bastion Terminal keychain
Connection Sync keeps profiles available across workstations
QueryExplainSchema
MySQL query
SELECT c.name, SUM(o.total) AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.status = 'paid'
GROUP BY c.id, c.name
ORDER BY revenue DESC;
MySQL: visual builders, explain plans, schema tools, and backups
QueryRoutinesDrift
PostgreSQL query
WITH ranked AS (
SELECT region, revenue,
rank() OVER (ORDER BY revenue DESC) AS pos
FROM quarterly_revenue
)
SELECT * FROM ranked WHERE pos <= 5;
PostgreSQL: routines, schema drift, data search, and safe applies
Local DBImportDiff
SQLite query
SELECT project, COUNT(*) AS tasks
FROM task_cache
WHERE completed = 0
GROUP BY project
ORDER BY tasks DESC;
SQLite: local files, import/export, data search, and ER diagrams
PodsRootlessImages
Podman workspace
podman pod ps
NAME READY STATUS
api 3/3 Running
jobs 2/2 Running
rootless profiles synced
Podman: rootless pods, containers, images, volumes, logs, and profile handoff
ComposeImagesLogs
Docker compose
docker compose ps
NAME STATE PORTS
api running 8080
worker running queue
cache running local
Docker: compose projects, containers, images, volumes, networks, and log streams
WorkloadsServicesYAML
Cluster workload
kubectl get deploy -n ops
NAME READY UPDATED
api 4/4 4
worker 2/2 2
rollout checks enabled
Kubernetes: pods, workloads, services, RBAC, Helm, YAML, and exec sessions
SSHTunnelsJump
SSH profile
ssh ops@prod-gateway
jump: bastion
local 15432 -> db:5432
agent forwarding: off
session log: enabled
SSH: profiles, jump hosts, tunnels, keys, session logs, and port forwards
SSHSerialLocal
Terminal session
ssh ops@bastion
jump host: prod-gateway
local forward: 15432 -> db.internal:5432
recording: enabled
Terminal: xterm.js sessions with logging, recording, and port forwards
