skills.rest
aspectrr
aspectrrCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

object-builder

Automate CRM object creation from SQL to filesystem with verification.

Updated Apr 20, 2026
Search Tags:#workspace#crm#sql#relationships#object-builder#pivot-view
One-click install
npx skills add https://github.com/aspectrr/denchclaw-workspace --skill object-builder
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: object-builder
Source: https://github.com/aspectrr/denchclaw-workspace/tree/main/skills/crm/object-builder
Command: npx skills add https://github.com/aspectrr/denchclaw-workspace --skill object-builder

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The CRM object builder automates end-to-end creation of workspace objects from SQL to filesystem, including view generation and post-mutation checks, reducing manual setup effort.

Core Features & Use Cases

  • End-to-end object creation via SQL with optional relation fields
  • Auto-generated Pivot views and corresponding .object.yaml metadata
  • Kanban-ready object templates with common CRM patterns
  • Proactive relation wiring to connect related objects and ensure data integrity
  • Stepwise validation: SQL, filesystem, and verification

Quick Start

Create a new object named lead by following the three steps to define SQL, generate metadata, and verify the Pivot view.

Frequently Asked Questions about object-builder

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

FAQPage Schema
How do I automate CRM object creation from SQL to filesystem verification?▼

Automating CRM object creation involves generating the v_{object} view from SQL, creating the object directory with .object.yaml metadata, and validating entries to ensure workspace initialization integrity.

What is the process for wiring relations when creating CRM objects like lead or company?▼

Wiring relations during CRM object creation proactively connects related objects like lead, task, and company, ensuring data integrity while automatically generating the required Pivot views and metadata files.

Can I generate Pivot views and .object.yaml metadata automatically for new workspace objects?▼

Yes, you can generate Pivot views and .object.yaml metadata automatically by defining the SQL for the object, which triggers regeneration of the v_{object} view and creates the corresponding filesystem directory.

What's the best way to set up Kanban-ready object templates with common CRM patterns?▼

Setting up Kanban-ready object templates requires using an end-to-end object builder that applies common CRM patterns, generates SQL, and configures the filesystem structure with stepwise validation checks.

Does CRM data modeling require stepwise validation for SQL, filesystem, and verification?▼

Yes, CRM data modeling requires stepwise validation across SQL generation, filesystem creation, and final verification to ensure the v_{object} view and .object.yaml entries are correctly established and mutation-free.

Why does workspace initialization fail when regenerating the v_{object} view?▼

Workspace initialization fails when the v_{object} view cannot regenerate properly, often due to invalid SQL syntax, missing relation fields, or incorrect filesystem directory and .object.yaml metadata setup during object creation.

Related Skills

Explore More Software Engineering Skills→
himes19himes19

duckdb-operations

Create CRM schemas, pivot views, and CRUD operations in DuckDB.

Community
Advanced
aspectrraspectrr

reports

Generate CRM dashboards by creating .report.json configurations with panels, filters, and chart mappings.

Community
Advanced
himes19himes19

object-builder

Automate CRM object provisioning from SQL schema to .object.yaml files and DuckDB verification.

Community
Advanced
putrawitamaputrawitama
1

views-filters

Organize saved views and filter rules for CRM objects via .object.yaml projections.

Community
Intermediate