skills.rest
dlwlrmax
dlwlrmaxCOMMUNITY
Explore all skills by this author →
GitHub

database-category-pointer

Routes database tasks to a library of 14 specialized database skills.

Updated Sep 13, 2023
Search Tags:#query optimization#database#migrations#sql#orm#postgres#skill routing
One-click install
npx skills add https://github.com/dlwlrmax/.dotfiles --skill database-category-pointer-dlwlrmax
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-category-pointer
Source: https://github.com/dlwlrmax/.dotfiles/tree/main/opencode/.config/opencode/skills/database-category-pointer
Command: npx skills add https://github.com/dlwlrmax/.dotfiles --skill database-category-pointer-dlwlrmax

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? It keeps startup context minimal by acting as a lightweight index that points to 14 specialized database skills stored in a hidden vault, so you only load the exact database expertise you need. ## Core Features & Use Cases - Skill Discovery: Lists 14 database skills covering Postgres, MySQL, NoSQL, ORMs (Prisma, Drizzle), migrations, multi-tenancy, and query optimization. - On-Demand Loading: Instructs the agent to read the matching skill's SKILL.md from the vault path before doing any database work. - Use Case: When asked to optimize a slow PostgreSQL query, the agent consults this pointer, identifies the sql-optimization-patterns or postgres-best-practices skill, loads it from the vault, and applies its guidance. ## Quick Start Ask the agent to help with any database task such as designing a Postgres schema or writing a Prisma migration, and it will load the matching specialized skill from the vault.

Frequently Asked Questions about database-category-pointer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I use the database category pointer skill?▼

Identify the specialized skill matching your task from the list of 14, then read its SKILL.md from the vault at /home/kienct/.config/opencode/skill-libraries/database/<skill-name>/SKILL.md and follow its instructions.

What database topics do the 14 specialized skills cover?▼

They cover Postgres provisioning and best practices, SQL and ORM migrations, Prisma and Drizzle expertise, NoSQL modeling for Cassandra and DynamoDB, multi-tenant SaaS design, query optimization, and SQL injection testing with SQLMap.

Why use a pointer skill instead of loading all database skills?▼

The pointer keeps startup context minimal by storing the 14 specialized skills in a hidden vault. Only the skill relevant to the current task is loaded on demand, reducing context usage.

Which skill should I load for Prisma or Drizzle ORM work?▼

Load prisma-expert for Prisma schema design, migrations, and query optimization, or drizzle-orm-expert for type-safe Drizzle schemas, relational queries, and serverless database integration in TypeScript.

What are the limitations of this pointer skill?▼

It contains no database logic itself and depends entirely on the vault directory existing at the hardcoded path. If the vault is missing or a skill name is mismatched, no specialized guidance can be loaded.

Related Skills

Explore More Software Engineering Skills→
BFLabsAIBFLabsAI

database-indexing-strategy

Design effective B-tree, GiST, BRIN, and partial indexes for PostgreSQL and MySQL.

Community
Intermediate
pgplexpgplex
994

Validate with Database

Validate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.

Official
Intermediate
jankneumannjankneumann
4

claimable-postgres

Provision temporary Postgres databases via the pg.new REST API.

Community
Intermediate
leeoveryleeovery
27

start-feature

Generate a feature specification markdown file from inline context.

Community
Basic