skills.rest
himes19
himes19COMMUNITY
Explore all skills by this author →
GitHub

duckdb-operations

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

Updated Apr 12, 2026
Search Tags:#schema#workspace#crm#sql#crud#duckdb#pivot
One-click install
npx skills add https://github.com/himes19/pulsevolt-infra --skill duckdb-operations-himes19
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-operations
Source: https://github.com/himes19/pulsevolt-infra/tree/main/skills/crm/duckdb-operations
Command: npx skills add https://github.com/himes19/pulsevolt-infra --skill duckdb-operations-himes19

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates CRM data modeling and persistence using DuckDB for workspace objects, fields, and entries.

Core Features & Use Cases

  • DuckDB Schema Initialization: Creates the objects, fields, and supporting tables necessary for CRM-style data modeling in a workspace.
  • Field Types Reference: Documents supported field types and their storage/queries to guide schema design.
  • Auto-Generated PIVOT Views: Generates deterministic pivot views per object to simplify querying across dynamic fields.
  • SQL CRUD Operations: Demonstrates patterns for creating objects, fields, entries, and related operations with safe upserts.
  • Use Case: Quickly bootstrap a workspace for tracking CRM-like records with flexible attributes and relationships.

Quick Start

Execute the provided initialization against your DuckDB workspace to bootstrap the CRM schema and CRUD workflow.

Frequently Asked Questions about duckdb-operations

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

FAQPage Schema
How do I set up a CRM schema in DuckDB?▼

To set up a CRM schema in DuckDB, execute the initialization script against your workspace at {{WORKSPACE_PATH}}/workspace.duckdb. This creates the objects, fields, and supporting tables required for CRM-style data modeling and persistence.

What is the best way to pivot dynamic fields in DuckDB?▼

The best way to pivot dynamic fields in DuckDB is using auto-generated deterministic pivot views for each object. These views simplify querying across dynamic fields by restructuring the data automatically for analysis.

Can I perform CRUD operations on CRM entries in DuckDB?▼

Yes, you can perform CRUD operations on CRM entries in DuckDB. The workflow provides SQL patterns for creating objects, fields, and entries, including safe upsert statements to ensure data persistence without duplication.

Do I need an existing DuckDB workspace to use CRM schemas?▼

Yes, you need an existing DuckDB workspace located at {{WORKSPACE_PATH}}/workspace.duckdb. The schema initialization and subsequent CRUD operations depend on this file to store the workspace objects, fields, and entries.

What field types are supported for CRM data modeling in DuckDB?▼

DuckDB CRM data modeling supports various field types documented in the field types reference. This reference guides schema design by detailing how each type is stored and queried within the database.

Related Skills

Explore More Software Engineering Skills→
putrawitamaputrawitama
1

duckdb-operations

Initialize DuckDB CRM schemas and CRUD pipelines for objects, fields, and entries.

Community
Advanced
aspectrraspectrr

crm-debug

Diagnose missing CRM object visibility by validating EAV data and pivot views.

Community
Advanced
BenAIOSBenAIOS

pipeline-review

Summarize CRM pipeline prospects and communications into Slack messages.

Official
Advanced
lexicalninjalexicalninja
2

database-implementer

Design database schemas, migrations, and data access layers for applications.

Community
Advanced