Execute qualquer Skill no Manus
com um clique

Execute qualquer Skill no Manus com um clique

db-query

Estrelas3

Forks0

Atualizado5 de maio de 2026 às 19:11

Execute read-only PostgreSQL queries across local, QA, UAT, and prod environments for the Prometheum platform. Knows all connection strings and enforces read-only mode on all non-localhost connections. Use when investigating data issues, verifying DB state, or querying boats/platform databases as part of an investigation.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Executar no Manus

Fonte

trevorgjohnson

trevorgjohnson/dotfiles

Abrir repositório GitHub Ver repositórios do creator

Download

Executar no Manus

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Administradores de banco de dadosInformática e Matemática·SOC 15-1242

SKILL.md

readonly

name	db-query
description	Execute read-only PostgreSQL queries across local, QA, UAT, and prod environments for the Prometheum platform. Knows all connection strings and enforces read-only mode on all non-localhost connections. Use when investigating data issues, verifying DB state, or querying boats/platform databases as part of an investigation.
argument-hint	<env> <service> "<SQL query>"

DB Query

Read-only PostgreSQL access across all Prometheum environments. Credentials are stored in ~/.pgpass — no password flags needed.

Connection map

Key	Host	Port	Database	User	VPN?
`local`	localhost	5432	postgres	prometheum	No
`qa-boats`	procap-boats-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	boats	boats-230607	Yes
`qa-platform`	procap-platform-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	platform	peatsuser-230313	Yes
`qa-procap`	procap-platform-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	procap	peatsuser-230313	Yes
`uat-boats`	procap-boats-backend-uat.cxzsy0zgpzqg.us-east-1.rds.amazonaws.com	5432	boats	boatsuser	Yes
`uat-procap`	procap-platform-backend-uat.cxzsy0zgpzqg.us-east-1.rds.amazonaws.com	5432	procap	peatsuser-230314	Yes
`prod-boats`	procap-boats-backend-prod.cpdze5cocd6u.us-east-1.rds.amazonaws.com	5432	boats	tjohnson	Yes
`prod-procap`	procap-platform-backend-prod.cluster-ro-cpdze5cocd6u.us-east-1.rds.amazonaws.com	5432	procap	tjohnson	Yes

Running a query

Non-localhost connections must include PGOPTIONS="-c default_transaction_read_only=on". A psql-guard hook will block any DML that slips through.

# Non-localhost (read-only enforced at session level)
PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h <host> -U <user> -d <database> -c "<SQL>"

# Localhost (read-only by default; writes allowed only when user explicitly requests)
psql -h localhost -U prometheum -d postgres -c "<SQL>"

Example

# Check a wallet balance in prod
PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h procap-boats-backend-prod.cpdze5cocd6u.us-east-1.rds.amazonaws.com \
       -U tjohnson -d boats \
       -c "SELECT address, balance FROM wallets WHERE address = '0xABC...' LIMIT 1"

Output formatting

Prefer -c for inline queries. For wide result sets pipe through column or use --csv:

PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h <host> -U <user> -d <database> --csv -c "<SQL>" | column -t -s ','

VPN requirement

UAT and prod connections require AWS VPN (split tunnel) to be active. If a connection times out or is refused on a non-local host, remind the user to check VPN before assuming a query error.

Mais deste repositório

mesmo repositório

backfill-merge

trevorgjohnson/dotfiles

Bring changes from a source branch into a target branch when a plain git merge is not enough: re-apply each logical change freshly against the target branch's current state, verify it independently, and double-check at the end. Use when the user says "backfill merge", "/backfill-merge", "re-apply changes onto another branch after merging", or describes merging a branch where each feature must be reconstructed against the target rather than trusted from the merged diff.

2026-06-303

dep-batch

trevorgjohnson/dotfiles

Batch all open Dependabot/Renovate PRs into a consolidated batch branch, deduplicating by package, merging each branch, then closing the individual PRs with a comment. Works on any Prometheum repo (boats, cows, ...). Trigger when the user says "run dep batch", "batch dependencies", or "consolidate renovate/dependabot PRs".

2026-06-303

draw-the-owl

trevorgjohnson/dotfiles

Feature-work loop: attempt the whole feature as a loose throwaway spike, measure the diff, and if it exceeds the line threshold (~1500) recursively decompose into atomic, reviewable tasks built by parallel agents. Trigger on "draw the owl", "/draw-the-owl", or open-ended feature implementation you want kept reviewable.

2026-06-303

teach

trevorgjohnson/dotfiles

Teach the user a new skill or concept, within this workspace.

2026-06-303

grill-me

trevorgjohnson/dotfiles

Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".

2026-05-053

caveman

trevorgjohnson/dotfiles

Ultra-compressed communication mode. Use when user says "caveman mode", "talk like caveman", "use caveman", "be brief", or invokes /caveman.

2026-04-293

name	db-query
description	Execute read-only PostgreSQL queries across local, QA, UAT, and prod environments for the Prometheum platform. Knows all connection strings and enforces read-only mode on all non-localhost connections. Use when investigating data issues, verifying DB state, or querying boats/platform databases as part of an investigation.
argument-hint	<env> <service> "<SQL query>"

DB Query

Read-only PostgreSQL access across all Prometheum environments. Credentials are stored in ~/.pgpass — no password flags needed.

Connection map

Key	Host	Port	Database	User	VPN?
`local`	localhost	5432	postgres	prometheum	No
`qa-boats`	procap-boats-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	boats	boats-230607	Yes
`qa-platform`	procap-platform-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	platform	peatsuser-230313	Yes
`qa-procap`	procap-platform-backend-qa.cxxajlz1qd40.us-east-1.rds.amazonaws.com	5432	procap	peatsuser-230313	Yes
`uat-boats`	procap-boats-backend-uat.cxzsy0zgpzqg.us-east-1.rds.amazonaws.com	5432	boats	boatsuser	Yes
`uat-procap`	procap-platform-backend-uat.cxzsy0zgpzqg.us-east-1.rds.amazonaws.com	5432	procap	peatsuser-230314	Yes
`prod-boats`	procap-boats-backend-prod.cpdze5cocd6u.us-east-1.rds.amazonaws.com	5432	boats	tjohnson	Yes
`prod-procap`	procap-platform-backend-prod.cluster-ro-cpdze5cocd6u.us-east-1.rds.amazonaws.com	5432	procap	tjohnson	Yes

Running a query

Non-localhost connections must include PGOPTIONS="-c default_transaction_read_only=on". A psql-guard hook will block any DML that slips through.

# Non-localhost (read-only enforced at session level)
PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h <host> -U <user> -d <database> -c "<SQL>"

# Localhost (read-only by default; writes allowed only when user explicitly requests)
psql -h localhost -U prometheum -d postgres -c "<SQL>"

Example

# Check a wallet balance in prod
PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h procap-boats-backend-prod.cpdze5cocd6u.us-east-1.rds.amazonaws.com \
       -U tjohnson -d boats \
       -c "SELECT address, balance FROM wallets WHERE address = '0xABC...' LIMIT 1"

Output formatting

Prefer -c for inline queries. For wide result sets pipe through column or use --csv:

PGOPTIONS="-c default_transaction_read_only=on" \
  psql -h <host> -U <user> -d <database> --csv -c "<SQL>" | column -t -s ','

VPN requirement

UAT and prod connections require AWS VPN (split tunnel) to be active. If a connection times out or is refused on a non-local host, remind the user to check VPN before assuming a query error.