# DB Tool

> Query and manage databases (SQLite, PostgreSQL, MySQL). Execute queries, explore schemas, and manage data.

- Skill: `winsorllc/db-tool` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add winsorllc/db-tool`
- Raw SKILL.md: https://api.skillmd.com/api/skills/winsorllc/db-tool/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: winsorllc (https://skillmd.com/u/winsorllc)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/winsorllc/db-tool

---


# DB Tool

Query and manage databases including SQLite, PostgreSQL, and MySQL. Execute queries, explore schemas, and manage data.

## Setup

Database connection is configured via environment variables or command line options:
- `DATABASE_URL` - Full connection string
- `DB_TYPE` - sqlite, postgres, or mysql

## Usage

### Query SQLite

```bash
{baseDir}/db-tool.js --query "SELECT * FROM users LIMIT 10"
```

### List Tables

```bash
{baseDir}/db-tool.js --tables
```

### Describe Table

```bash
{baseDir}/db-tool.js --describe "users"
```

### Execute SQL

```bash
{baseDir}/db-tool.js --execute "UPDATE users SET active = 1 WHERE id = 5"
```

## Options

| Option | Description | Required |
|--------|-------------|----------|
| `--query` | Execute SELECT query | No |
| `--execute` | Execute INSERT/UPDATE/DELETE | No |
| `--tables` | List all tables | No |
| `--describe` | Show table schema | No |
| `--database` | Database file or connection string | No |
| `--type` | Database type: sqlite, postgres, mysql | No |

## When to Use

- Querying databases for debugging
- Data exploration and analysis
- Running migrations
- Database administration tasks