Query Standard Table
SKILL.md
Query Standard Table
Query data from the user's standard ops tables. These tables are automatically provisioned and synced with their CRM.
Available Tables
| Table | Key | Description |
|---|---|---|
| Leads | standard_leads | Lead pipeline from contacts + CRM |
| Meetings | standard_meetings | Meeting history with recordings |
| All Contacts | standard_all_contacts | Universal CRM contacts mirror |
| All Companies | standard_all_companies | Unified company data |
Intent Detection
Map user intent to table:
- "leads", "prospects", "pipeline" → Leads
- "meetings", "calls", "conversations" → Meetings
- "contacts", "people" → All Contacts
- "companies", "accounts", "organizations" → All Companies
Filter Examples
- "hot leads" → Leads WHERE engagement_level IN (hot, engaged)
- "meetings this week" → Meetings WHERE meeting_date within_last_days 7
- "contacts at Acme" → All Contacts WHERE company_name contains "Acme"
- "companies with revenue > 1M" → All Companies WHERE revenue greater_than 1000000
Response Format
Return results as a structured table with column headers and row data. Include total count and a link to view the full table in the Ops UI.