db-stinger — Claude Code skill: what it does, how to install
The db-stinger skill guides PostgreSQL schema work, migration planning, and query-performance reviews. Use it when assessing a database layer or choosing an ORM or serverless platform.
AGPL-3.0-or-later ★ 96 updated 2026-10-18
/plugin marketplace add legioncodeinc/vibe-coding-tools
/plugin install data-and-ai-tools@wasp-nestWhat db-stinger does
db-stinger begins by examining the project’s DDL or ORM schema alongside package.json. It uses those details to account for the PostgreSQL version, database library, connection pool, migration tool, and hosting setup. Then it selects guidance for the requested work, such as schema design, index review, migration planning, ORM evaluation, or platform selection.
Its deliverables vary by task: schema specifications, migration plans, architecture decisions, or audit reports. Findings need supporting references. For performance work, the required evidence includes EXPLAIN (ANALYZE, BUFFERS); a recommendation without a query plan does not meet that bar.
The skill focuses on PostgreSQL and hands security audits to a separate subagent. Serverless workloads require connection pooling. For changes to large tables, it rules out destructive one-step DDL and calls for an expand-backfill-contract migration approach.
What it helps with
- design a PostgreSQL schema for a new feature
- plan a migration for a live database
- spot missing or redundant indexes
- review a query plan and propose performance fixes
- choose an ORM or database platform for a workload
Example prompts for the agent
- Design a PostgreSQL schema for this feature and draft its specification.
- Review the current schema and
package.jsonfor indexing issues. - Plan a live-table migration without using destructive one-step DDL.
How to install db-stinger
1Plugin marketplace
/plugin marketplace add legioncodeinc/vibe-coding-tools/plugin install data-and-ai-tools@wasp-nestThis installs the whole data-and-ai-tools plugin with all its skills
2Skills CLI (Vercel)
npx skills add legioncodeinc/vibe-coding-tools --skill db-stinger -a claude-code3Manually: put the files in place
~/.claude/skills/db-stinger/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/db-stinger/
1Skills CLI (Vercel)
npx skills add legioncodeinc/vibe-coding-tools --skill db-stinger -a codex2Manually: put the files in place
.agents/skills/db-stinger/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add legioncodeinc/vibe-coding-tools --skill db-stinger -a cursor2Manually: put the files in place
.cursor/skills/db-stinger/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install legioncodeinc/vibe-coding-tools plugins/data-and-ai-tools/skills/db-stinger2Manually: put the files in place
.github/skills/db-stinger/SKILL.md1Skills CLI (Vercel)
npx skills add legioncodeinc/vibe-coding-tools --skill db-stinger -a gemini-cli2Platform CLI
gemini skills install https://github.com/legioncodeinc/vibe-coding-tools --path plugins/data-and-ai-tools/skills/db-stingerManually: put the files in place
.devin/skills/db-stinger/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about db-stinger
How do I install db-stinger in Claude Code?
Add the marketplace with /plugin marketplace add legioncodeinc/vibe-coding-tools, then install the plugin with /plugin install data-and-ai-tools@wasp-nest.
What does db-stinger do?
It guides PostgreSQL data-layer design and review, covering schemas, indexes, and migrations. It can also produce performance findings and help assess ORM or serverless platform choices.
What does db-stinger require for a performance review?
Performance findings must cite a query plan produced with EXPLAIN (ANALYZE, BUFFERS).