database-architecture

Document the OficiosYa Workers table schema and row-level security model.

1|Updated Mar 17, 2026

Search Tags:#architecture #documentation #security #database #relational-database #workers #row-level-security

Ready to run

npx skills add https://github.com/MoisesAldas/OficiosYA --skill database-architecture-moisesaldas

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-architecture
Source: https://github.com/MoisesAldas/OficiosYA/tree/main/.agents/database-architecture
Command: npx skills add https://github.com/MoisesAldas/OficiosYA --skill database-architecture-moisesaldas

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The database architecture description helps developers and stakeholders understand how the OficiosYa application stores workers, services, and related data, enabling safer evolution and faster onboarding.

Core Features & Use Cases

Entities & Tables: Workers and related fields (id, name, service, city, phone, whatsapp, description, created_at)
Security Model: Row Level Security (RLS) with Clerk-based authentication to control edits
Use Case: Quick reference for engineers designing queries, migrations, or evaluating schema changes.

Quick Start

Explain how the workers table is structured and how lookups by service operate.

Frequently Asked Questions about database-architecture

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

FAQPage Schema

How do I document relational database architecture for new developers?▼

What is row-level security (RLS) in a relational database? Row-level security (RLS) is a database security model that controls data access at the row level. Combined with Clerk-based authentication, it restricts edits to ensure only authorized users modify specific worker records.

How does row-level security work with Clerk authentication?▼

Row-level security (RLS) with Clerk authentication controls edit permissions by verifying user identity at the database level. This ensures that only authorized users can modify specific worker records, safeguarding the relational database architecture.

What fields should a workers table include in a service application?▼

A workers table in a service application should include id, name, service, city, phone, whatsapp, description, and created_at fields. These schema elements support service lookups and clearly define the relational database architecture for stakeholders.

When do I need to outline a database security model for my app?▼

You need to outline a database security model when new developers, data architects, or QA teams require a high-level understanding of data relationships. This clarifies how row-level security protects worker entities and enables safer application evolution.

Can I use this database architecture guide for designing query migrations?▼

Yes, this database architecture guide serves as a quick reference for engineers designing queries, migrations, or evaluating schema changes. It explains how the workers table is structured and how lookups by service operate.