# Db Query

> Query the Balance prod or sandbox PostgreSQL database. Use when the user asks to look up, investigate, or query data in the database, check DB state, debug data issues, or needs information that requires SQL queries. Handles Vault authentication and credential retrieval automatically.

- **Type:** Skill
- **Install:** `agentstack add skill-assapir-agent-skills-db-query`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [assapir](https://agentstack.voostack.com/s/assapir)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [assapir](https://github.com/assapir)
- **Source:** https://github.com/assapir/agent-skills/tree/main/db-query

## Install

```sh
agentstack add skill-assapir-agent-skills-db-query
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# DB Query

Run read-only SQL queries against the Balance prod or sandbox PostgreSQL database. Credentials are fetched automatically from HashiCorp Vault using the `GITHUB_TOKEN` env var.

## Usage

```bash
bash /Users/asapir/.claude/skills/db-query/scripts/db_query.sh  ""
```

## Rules

- Default to **sandbox** unless the user explicitly says "prod" or "production"
- Before querying **prod**, warn the user and confirm they want prod
- Only run **SELECT** queries (credentials are read-only)
- For schema discovery, query `information_schema.tables` and `information_schema.columns`
- Present results in a clean, readable format (use markdown tables for small result sets)
- For large result sets, summarize key findings rather than dumping raw output

## Examples

```bash
# List tables
bash /Users/asapir/.claude/skills/db-query/scripts/db_query.sh sandbox "SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name"

# Describe a table
bash /Users/asapir/.claude/skills/db-query/scripts/db_query.sh sandbox "SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name='orders' ORDER BY ordinal_position"

# Query data
bash /Users/asapir/.claude/skills/db-query/scripts/db_query.sh sandbox "SELECT id, status, created_at FROM orders WHERE buyer_id = '123' ORDER BY created_at DESC LIMIT 10"
```

## Troubleshooting

- **"GITHUB_TOKEN not set"**: The env var must be exported in the shell
- **"vault CLI not found"**: The script auto-installs via `brew install vault`
- **Permission denied on Vault**: The GitHub token may lack access to the requested environment
- **Connection timeout**: Check network/VPN connectivity to AWS RDS

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [assapir](https://github.com/assapir)
- **Source:** [assapir/agent-skills](https://github.com/assapir/agent-skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-assapir-agent-skills-db-query
- Seller: https://agentstack.voostack.com/s/assapir
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.