skills.rest
yaniv-golan
yaniv-golanCOMMUNITY
Explore all skills by this author →
𝕏@yanivgGitHub

query-language

Construct structured multi-entity CRM queries with filtering, aggregation, grouping, and sorting.

1|Updated Dec 14, 2025
Search Tags:#aggregation#crm#query#filters#sorting#multi-entity
One-click install
npx skills add https://github.com/yaniv-golan/affinity-sdk --skill query-language-yaniv-golan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-language
Source: https://github.com/yaniv-golan/affinity-sdk/tree/main/mcp/.claude-plugin/skills/query-language
Command: npx skills add https://github.com/yaniv-golan/affinity-sdk --skill query-language-yaniv-golan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Complex CRM data analysis often requires building multi-entity queries across persons, companies, opportunities, and related data, which is tedious and error-prone when done ad-hoc.

Core Features & Use Cases

  • Structured multi-entity querying across related CRM data with filters, joins, and aggregations
  • Advanced analytics support including grouping and sorting across multiple entities
  • Guided workflow for building, validating, and running queries with safe defaults and dry-run previews

Quick Start

Construct a structured query to filter, join, and aggregate CRM data across related entities.

Frequently Asked Questions about query-language

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

FAQPage Schema
How do I query multiple CRM entities with advanced filtering and aggregation?▼

To query multiple CRM entities, you construct a structured query that applies advanced filtering, joins, grouping, and aggregation across persons, companies, opportunities, and related data. This approach replaces ad-hoc methods with a guided workflow for safe defaults.

Can I preview CRM data queries before running them on large datasets?▼

You can preview CRM data queries using a dry-run capability before full execution. This feature provides performance guidance and applies safeguards with limits to handle large results safely across multi-entity joins and aggregations.

What is the best way to build multi-entity queries across persons and companies?▼

The best way to build multi-entity queries across persons and companies is using a guided structured query construction workflow. It supports advanced analytics including grouping, sorting, and include/expand capabilities to ensure accurate complex joins.

Does this approach support grouping and sorting across related CRM data?▼

Yes, this approach supports advanced analytics including grouping and sorting across related CRM data. You can aggregate and filter across multiple entities like opportunities and persons within a single validated structured query.

Are there safeguards for handling large results when querying CRM data?▼

Safeguards for large CRM query results include built-in limits and performance guidance. These constraints prevent errors during complex multi-entity aggregations and joins by validating the query through a dry-run preview first.

Related Skills

Explore More Data & Analytics Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
rappdwrappdw

synthdata-compute

Transforms xlsx, csv, or json datasets into aggregated or scored tables.

Community
Advanced
rahul-s-bhattrahul-s-bhatt

displaying-streamlit-data

Create charts, metrics, tables, and formatted columns in Streamlit applications.

Community
Intermediate
oneryalcinoneryalcin
1

query-language

Query Affinity CRM records with SQL-like multi-entity filters and aggregations.

Community
Intermediate