SkillsAdd

weorbitant/ai-dev-kit-pgi · Archived

db-query

Use when needing to query a PostgreSQL database in DEV or PROD, check if records exist, count rows, inspect data, or run read-only SQL queries from within the cluster.

First seen Jun 22, 2026

Installation

$ npx skills add weorbitant/ai-dev-kit-pgi --skill db-query
View on skills.sh ↗ GitHub repository ↗

Summary

  • Use when needing to query a PostgreSQL database in DEV or PROD, check if records exist, count rows, inspect data, or run read-only SQL queries from within the cluster.
  • Use when user says "consulta la BD", "query", "busca en la tabla", "check database", "db query", or "existe este registro".

Stronger alternatives

This repository is archived — consider an actively maintained alternative.

jira-create-bug Same source · more installs
weorbitant/ai-dev-kit-pgi

Use when creating a bug report in Jira, reporting an issue found during development or operatio…

2 installs
rabbitmq-list-queues Same source
weorbitant/ai-dev-kit-pgi

Use when checking RabbitMQ queue status, listing queues with messages, checking DLQ counts, or …

1 installs
infra-portforward Same source
weorbitant/ai-dev-kit-pgi

Use when needing to port-forward to any Kubernetes service (RabbitMQ, PostgreSQL, internal APIs…

1 installs
infra-pods Same source
weorbitant/ai-dev-kit-pgi

Use when checking pod status, listing running services, investigating crashloops, viewing pod e…

1 installs

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

azure-storage Same topic
microsoft/azure-skills

Azure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and D…

567.1K installs
azure-kusto Same topic
microsoft/azure-skills

Query and analyze data in Azure Data Explorer (Kusto/ADX) using KQL for log analytics, telemetr…

566.2K installs
supabase-postgres-best-practices Same topic
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Same topic
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-client-api Same topic
prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use…

269.3K installs
prisma-cli Same topic
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs

Also in this package

Other skills from weorbitant/ai-dev-kit-pgi.

npx skills add weorbitant/ai-dev-kit-pgi
jira-create-bug 2 rabbitmq-list-queues 1 infra-portforward 1 infra-pods 1 analyze-docs 1

Browse all from weorbitant/ai-dev-kit-pgi

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Default branch main
Open issues 0
Status Archived

Skill metadata

Parsed from SKILL.md frontmatter.

Allowed toolsBash, Read, AskUserQuestion
Declared agents claude-code

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 2,201 B
  • docs SUMMARY.md 307 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 1 installs

SKILL.md

Database Queries

Overview

Execute read-only SQL queries against PostgreSQL databases via PgBouncer from within application pods. No psql available — use the pg module via node -e.

Configuration

Read project-specific values from the project's CLAUDE.md (## Infrastructure section):

  • kubectl context, namespace, app pod label, database name, config file per environment

Constraints

  • PgBouncer does NOT support parameterized queries — use inline SQL with quoted values.
  • Read-only only. Never run INSERT/UPDATE/DELETE without explicit user confirmation.
  • Use require('/app/node_modules/pg') — module is not in the global node path.
  • Use development.config.js for DEV, production.config.js for PROD (both files exist in every pod).

Process

  1. Read the project CLAUDE.md for connection details (context, namespace, db name, pod label)
  2. Find a running pod: kubectl --context=<ctx> get pods -n <namespace> | grep <app-label>
  3. Get connection details from the config file inside the pod
  4. Run the query using the helper script or inline node -e

See [scripts/query.js](scripts/query.js) for the reusable helper (copy to pod with kubectl cp). See [references/query-examples.md](references/query-examples.md) for command templates.

Common Mistakes

Mistake Prevention
Not reading CLAUDE.md Namespace, context, DB name vary per project.
Parameterized queries ($1::uuid[]) PgBouncer rejects them. Use inline SQL.
require('pg') fails Use require('/app/node_modules/pg').
Wrong config file production.config.js in a DEV pod points to PROD db. Use development.config.js for DEV.
Write queries without confirmation Always ask before INSERT/UPDATE/DELETE.