paishu-ai/pai-zong-nb-v5.8/07-database

Claude Code and agent skill by paishu-ai/pai-zong-nb-v5.8

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Design and modify database schemas, migrations, SQL queries, indexes, transactions, constraints, and query performance. Use for PostgreSQL, MySQL, SQLite, SQL Server, Prisma, ORM changes, migration planning, and data consistency issues.

Install

npx vskill@latest install paishu-ai/pai-zong-nb-v5.8/07-database

SKILL.md

The same SKILL.md was published earlier as paishu-ai/pai-zong-nb-v5.8/07-database.

Database

Workflow

  1. Inspect existing schema, migration style, ORM conventions, and naming.
  2. Model invariants in the database where practical: primary keys, foreign keys, unique constraints, check constraints, and nullability.
  3. Choose indexes based on real query predicates, joins, sorting, and cardinality.
  4. Define transaction boundaries and isolation expectations.
  5. Plan migration rollout, backfill, lock risk, and rollback.
  6. Verify with tests, migration dry run, or query plan when possible.

Required Checks

  • Do not rely only on application code for critical uniqueness or referential integrity.
  • Avoid adding indexes without a query reason.
  • Treat large-table migrations as risky until lock and backfill behavior is understood.
  • Be explicit about destructive migrations and data loss.

Output

Summarize schema/query change, invariant protected, index rationale, migration risk, and verification.

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1
Repository forks
1
7-day trend score
8

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/paishu-ai/pai-zong-nb-v5.8/07-database/badge)](https://verified-skill.com/skills/paishu-ai/pai-zong-nb-v5.8/07-database)

Something wrong with this skill or its page? Tell us.