# Salesforce CRM Query

> List objects, describe schema, run SOQL queries

- Skill: `majiayu000/salesforce-crm-query` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/salesforce-crm-query`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/salesforce-crm-query/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/salesforce-crm-query

---


## Salesforce CRM Query

When querying Salesforce data:

- Use **salesforce_list_objects** (tool name may have a suffix if multiple Salesforce servers exist) to discover standard and custom objects in the org.
- Use **salesforce_describe_object** to get fields and relationships for an object before querying.
- Use **salesforce_query** to run SOQL queries (read-only); build queries from the described schema.
- Follow a discovery-first workflow: list objects -> describe object -> query. All tools are read-only.
- Summarize records clearly; cite object and key fields; avoid dumping raw result sets unless asked.

## Step-by-step instructions

1. When the user asks about "accounts", "contacts", or an object name: if unsure of the exact API name, call **salesforce_list_objects** to find it.
2. Before running a query: call **salesforce_describe_object** for that object to get field names and types so the SOQL query uses valid fields.
3. Call **salesforce_query** with a SOQL string (e.g. SELECT Id, Name FROM Account LIMIT 10); use only fields from the describe result.
4. Summarize the returned records (count, key fields); for large result sets, summarize and offer to narrow.
5. Salesforce uses instance_url from the token; the tools use the correct instance automatically.

## Examples of inputs and outputs

- **Input**: "List recent accounts."  
  **Output**: Short list of Account records (Id, Name, and other requested fields) from **salesforce_query** with a SOQL like SELECT Id, Name FROM Account ORDER BY CreatedDate DESC LIMIT 10.

- **Input**: "What fields does the Contact object have?"  
  **Output**: List of field names and types from **salesforce_describe_object** for Contact; summarize key fields (e.g. Name, Email, AccountId).

## Common edge cases

- **Object not found**: Say "Object [name] not found" and suggest listing objects or checking the API name (e.g. custom objects have __c).
- **Invalid SOQL**: If the query fails, check field names against **salesforce_describe_object** and retry; report the error to the user.
- **Large result set**: SOQL has limits; summarize the first page and mention limits; do not assume all records were returned.
- **API/OAuth error**: Report that Salesforce returned an error and suggest reconnecting or retrying; ensure instance_url is used (handled by the integration).

## Tool usage for specific purposes

- **salesforce_list_objects**: Use when the user asks about "objects" or when you need to resolve an object API name.
- **salesforce_describe_object**: Use before building a SOQL query to get valid field names and types.
- **salesforce_query**: Use to run read-only SOQL; always use fields from describe; include LIMIT and ORDER BY as appropriate.