db-schema

Document the OficiosYa PostgreSQL database schema with tables, columns, and relationships.

1|Updated Mar 17, 2026
One-click install
npx skills add https://github.com/MoisesAldas/OficiosYA --skill db-schema-moisesaldas
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-schema
Source: https://github.com/MoisesAldas/OficiosYA/tree/main/.agents/db-schema
Command: npx skills add https://github.com/MoisesAldas/OficiosYA --skill db-schema-moisesaldas

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Complete reference for the OficiosYa PostgreSQL database schema, detailing tables, columns, relationships, RLS policies, indexes, full-text search, and useful patterns to guide queries, migrations, and schema extensions.

Core Features & Use Cases

  • Comprehensive schema reference for quick lookup of table structures, column types, constraints, and relationships.
  • Handy for querying, migrating, or extending the database, and for onboarding new developers working with the backend.
  • Use cases include validating migrations, designing new features, and performing impact analysis when altering schema.

Quick Start

Query the schema to locate a table, such as workers, and inspect its columns and relationships to understand data flow.

Frequently Asked Questions about db-schema

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

FAQPage Schema
How do I reference the OficiosYa PostgreSQL schema for table structures and columns?

To reference the OficiosYa PostgreSQL schema, query the documented tables to locate structures, column types, constraints, and relationships for quick lookup and data flow inspection.

What is included in the OficiosYa database schema documentation?

The OficiosYa database schema documentation includes tables, columns, relationships, RLS policies, indexes, full-text search configurations, and migrations to guide queries and schema extensions.

Can I use this schema reference to validate PostgreSQL migrations and design new features?

Yes, you can use this schema reference to validate PostgreSQL migrations, design new features, and perform impact analysis when altering the database schema for the OficiosYa backend.

How do I inspect RLS policies and indexes in the OficiosYa PostgreSQL database?

To inspect RLS policies and indexes in the OficiosYa PostgreSQL database, navigate the schema reference to view policy definitions and index configurations for security and performance planning.

Does the OficiosYa schema documentation cover full-text search and migration planning?

Yes, the OficiosYa schema documentation covers full-text search and migration planning, enabling developers to query schema details and plan database extensions accurately.

What do I need to query the OficiosYa PostgreSQL schema for onboarding and impact analysis?

To query the OficiosYa PostgreSQL schema for onboarding and impact analysis, you need a valid SKILL.md frontmatter with a name and description along with a Markdown body providing operational guidance.