ワンクリックでManusで任意のスキルを実行

local-db

スター7

フォーク10

更新日2026年7月16日 00:57

Query the local Postgres database — credentials via server/.env, psql one-liners, TypeORM table/column naming, dev vs test DB.

インストール

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

Manusで実行

ソース

worldalliance

worldalliance/alliance

GitHub リポジトリを開く Creator のリポジトリを見る

ダウンロード

Manusで実行

Local Database Access

Local Postgres credentials in server/.env. Do not read the entire file.

You can grep for the lines containing the specific variables: grep -E '^(DB_HOST|DB_PORT|DB_USERNAME|DB_PASSWORD|DB_NAME)' server/.env (these variables are not sensitive).

Ad-hoc queries

PGPASSWORD=$DB_PASSWORD psql -h $DB_HOST -p $DB_PORT -U $DB_USERNAME -d $DB_NAME -c "SELECT ..."

Notes

Table names: snake_case from TypeORM entity classes (ReminderGroup → reminder_group).
Column names: keep entity camelCase, must be double-quoted in SQL ("newStatus").
Test DB (server/.env.test): password postgres, database postgres — don't mix up with dev DB.

このリポジトリの他の Skills

同じリポジトリ

dto-return-types

worldalliance/alliance

NestJS endpoint return-type and DTO rules — explicit DTO return types, @ApiOkResponse matching, wrapper DTOs, constructor patterns, and the post-edit `bun run gen-api` step. Read before editing any *.dto.ts or *.controller.ts in server/.

2026-07-167

migrations

worldalliance/alliance

Generate and review TypeORM database migrations in server/ — migration:generate vs migration:create, and the column-rename DROP+ADD pitfall. Read before generating or writing any db migration.

2026-07-167

playwright

worldalliance/alliance

Verify changes against the locally running apps — curl the API, drive the admin/frontend GUIs with Playwright

2026-07-167

name	local-db
description	Query the local Postgres database — credentials via server/.env, psql one-liners, TypeORM table/column naming, dev vs test DB.

Local Database Access

Local Postgres credentials in server/.env. Do not read the entire file.

You can grep for the lines containing the specific variables: grep -E '^(DB_HOST|DB_PORT|DB_USERNAME|DB_PASSWORD|DB_NAME)' server/.env (these variables are not sensitive).

Ad-hoc queries

PGPASSWORD=$DB_PASSWORD psql -h $DB_HOST -p $DB_PORT -U $DB_USERNAME -d $DB_NAME -c "SELECT ..."

Notes

Table names: snake_case from TypeORM entity classes (ReminderGroup → reminder_group).
Column names: keep entity camelCase, must be double-quoted in SQL ("newStatus").
Test DB (server/.env.test): password postgres, database postgres — don't mix up with dev DB.