Query companies
query_companiesColumns: id, display_name, domain (normalized bare host), linkedin_company_id, owner_email,
data (JSONB), created_at, updated_at. Sliq's CRM is deals and tasks: to see whether a company
has a deal or a task, use query_deals (status='all') / query_crm_tasks with company_id.
JSONB queries: data->>'some_key' ILIKE '%...%'.
Firmographic columns (captured from company enrichment; blank/NULL until enriched): linkedin_slug (the LinkedIn company page's lowercase slug: 'acme-corp' for linkedin.com/company/acme-corp), industry, description, location (HQ), logo_url, employee_count, follower_count, founded_year, company_type, annual_revenue, total_funding, latest_funding_stage.
To list the people you know at a company, take an id from here and call query_people with
where_clause="company_profile_id = <id>".
For how many companies are in each industry or location, or which companies are in one of those groups, call list_companies: it reads the Companies table the way the user sees it, over every company without paging for the counts. A dict with count, truncated, and items array (each row {id, display_name, domain, linkedin_company_id, owner_email, linkedin_slug, industry, description, location, logo_url, employee_count, follower_count, founded_year, company_type, annual_revenue, total_funding, latest_funding_stage, data, created_at, updated_at}).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "query_companies"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max results (default 50, capped at 200). | |
| offset | No | Rows to skip for paging (default 0). When the result is truncated, re-call with offset += limit for the next page. | |
| order_by | No | SQL ORDER BY (default: created_at DESC). | created_at DESC |
| on_behalf_of | No | A teammate's email, or an agency client's from list_agency_clients, to run this call in that account: their agents, settings, connected accounts, and credits. Omit it to act on your own account. | |
| where_clause | No | SQL WHERE condition (default: all your companies). Examples: "domain = 'stripe.com'", "display_name ILIKE '%acme%'". | 1=1 |