Convex Index Audit

Static read-only audit of convex/. Generated by scripts/audit-convex-indexes.ts. No runtime code or schema was modified. This report is a snapshot — re-run the script to refresh it.

Generated: 2026-06-16T00:09:33.496Z
Schema source: convex/schema.ts
Convex files scanned: 265
Tables declared: 112 (with 357 total indexes)
Tables with zero indexes: 0
Queries: 1075 total — 996 use .withIndex(...), 79 look like table scans
Missing index references: 0
.collect() calls: 65 total — 65 bounded (scoped by .withIndex(...) or capped by .take(N)), 0 unbounded

A. Tables & indexes

Table	Index	Fields
`ghlInstallations`	`by_company`	`companyId`
`ghlInstallations`	`by_location`	`locationId`
`ghlInstallations`	`by_createdAt`	`createdAt`
`ghlInstallations`	`by_expiresAt`	`expiresAt`
`roundRobinState`	`by_locationId`	`locationId`
`leadReassignmentAudits`	`by_locationId_and_createdAt`	`locationId`, `createdAt`
`users`	`by_user_id`	`userId`
`organizations`	`by_location`	`locationId`
`organizationMemberships`	`by_org`	`orgId`
`organizationMemberships`	`by_user_org`	`userId`, `orgId`
`creditReportRequests`	`by_request`	`requestId`
`creditReportRequests`	`by_requestId_locationId`	`requestId`, `locationId`
`creditReportRequests`	`by_contact`	`contactId`
`creditReportRequests`	`by_contact_location_createdAt`	`contactId`, `locationId`, `createdAt`
`creditReportRequests`	`by_company`	`companyId`
`creditReportRequests`	`by_location`	`locationId`
`creditReportRequests`	`by_createdAt`	`createdAt`
`creditReportRequests`	`by_location_createdAt`	`locationId`, `createdAt`
`creditReportRequestBlobs`	`by_request`	`requestId`
`creditReportRequestBlobs`	`by_creditReport`	`creditReportId`
`stitchCreditTokens`	`by_createdAt`	`createdAt`
`underwritingResults`	`by_report`	`reportId`
`underwritingResults`	`by_report_createdAt`	`reportId`, `createdAt`
`underwritingResults`	`by_contact`	`contactId`
`underwritingResults`	`by_contact_location_createdAt`	`contactId`, `locationId`, `createdAt`
`underwritingResults`	`by_location`	`locationId`
`underwritingResults`	`by_createdAt`	`createdAt`
`underwritingResults`	`by_location_createdAt`	`locationId`, `createdAt`
`cards`	`by_recordId`	`recordId`
`cards`	`by_cardType`	`cardType`
`fundingPlans`	`by_contact`	`contactId`
`fundingPlans`	`by_location`	`locationId`
`fundingPlans`	`by_contact_location`	`contactId`, `locationId`
`fundingPlans`	`by_contact_location_createdAt`	`contactId`, `locationId`, `createdAt`
`fundingPlans`	`by_createdAt`	`createdAt`
`fundingPlans`	`by_location_createdAt`	`locationId`, `createdAt`
`adminMetricsDaily`	`by_metricType_dayBucket`	`metricType`, `dayBucket`
`columnConfigs`	`by_location_table`	`locationId`, `tableType`
`savedFilters`	`by_location_page`	`locationId`, `pageType`
`zohoVerticalAccounts`	`by_org`	`zohoOrgId`
`zohoInstallations`	`by_location`	`locationId`
`zohoInstallations`	`by_org`	`zohoOrgId`
`migrationJobs`	`by_location`	`locationId`
`migrationJobs`	`by_status`	`status`
`migrationJobs`	`by_location_status`	`locationId`, `status`
`migrationLogs`	`by_job`	`jobId`
`migrationLogs`	`by_zoho_record`	`zohoRecordId`
`migrationLogs`	`by_location_zoho_record`	`locationId`, `zohoRecordId`
`migrationLogs`	`by_job_status`	`jobId`, `status`
`crmStageFixRuns`	`by_createdAt`	`createdAt`
`crmStageFixRuns`	`by_status`	`status`
`crmStageFixRuns`	`by_location_createdAt`	`locationId`, `createdAt`
`migratedContacts`	`by_ghl_contact`	`ghlContactId`
`migratedContacts`	`by_location`	`locationId`
`migratedContacts`	`by_zoho_record`	`zohoRecordId`
`migratedContacts`	`by_location_source`	`locationId`, `dataSource`
`migratedContacts`	`by_validation_status`	`locationId`, `dateValidationStatus`
`dateAuditTrail`	`by_ghl_contact`	`ghlContactId`
`dateAuditTrail`	`by_location`	`locationId`
`dateAuditTrail`	`by_job`	`migrationJobId`
`dateAuditTrail`	`by_field`	`ghlContactId`, `fieldName`
`onboardingProgress`	`by_location`	`locationId`
`onboardingCalls`	`by_location`	`locationId`
`onboardingCalls`	`by_location_type`	`locationId`, `callType`
`slackInvites`	`by_location`	`locationId`
`communityAccessSettings`	`by_location`	`locationId`
`locationSettings`	`by_location`	`locationId`
`aiAgentRuns`	`by_location_and_createdAt`	`locationId`, `createdAt`
`aiAgentRuns`	`by_location_and_useCase_and_createdAt`	`locationId`, `useCase`, `createdAt`
`aiAgentRuns`	`by_status_and_createdAt`	`status`, `createdAt`
`aiAgentRuns`	`by_approvalState_and_createdAt`	`approvalState`, `createdAt`
`contactInvoiceAgreementOverrides`	`by_locationId_contactId`	`locationId`, `contactId`
`locationGhlMappings`	`by_location`	`locationId`
`customValues`	`by_location`	`locationId`
`zohoLeads`	`by_org`	`zohoOrgId`
`zohoLeads`	`by_location`	`locationId`
`zohoLeads`	`by_zoho_record`	`zohoRecordId`
`zohoLeads`	`by_org_record`	`zohoOrgId`, `zohoRecordId`
`zohoDeals`	`by_org`	`zohoOrgId`
`zohoDeals`	`by_location`	`locationId`
`zohoDeals`	`by_zoho_record`	`zohoRecordId`
`zohoDeals`	`by_org_record`	`zohoOrgId`, `zohoRecordId`
`zohoCreditReports`	`by_org`	`zohoOrgId`
`zohoCreditReports`	`by_location`	`locationId`
`zohoCreditReports`	`by_zoho_record`	`zohoRecordId`
`zohoCreditReports`	`by_syncedAt`	`syncedAt`
`zohoCreditReports`	`by_org_record`	`zohoOrgId`, `zohoRecordId`
`zohoCreditReports`	`by_lead`	`zohoLeadId`
`zohoCreditReports`	`by_deal`	`zohoDealId`
`setterCommissionSettings`	`by_location`	`locationId`
`setterCommissionSettings`	`by_location_ghl_user`	`locationId`, `ghlUserId`
`locationCommissionDefaults`	`by_location`	`locationId`
`closerCommissionSettings`	`by_location`	`locationId`
`closerCommissionSettings`	`by_location_ghl_user`	`locationId`, `ghlUserId`
`fundingMachinesDeals`	`by_zoho_record`	`zohoRecordId`
`fundingMachinesDeals`	`by_org`	`zohoOrgId`
`fundingMachinesDeals`	`by_org_record`	`zohoOrgId`, `zohoRecordId`
`fundingMachinesDeals`	`by_closer`	`closerId`
`fundingMachinesDeals`	`by_appointment_event`	`appointmentEventId`
`fundingMachinesDeals`	`by_lead_built_contact`	`leadBuiltContactId`
`fundingMachinesDeals`	`by_contact_phone`	`contactPhone`
`fundingMachinesDeals`	`by_contact_email`	`contactEmail`
`ghlSubscriptions`	`by_location`	`locationId`
`ghlSubscriptions`	`by_syncedAt`	`syncedAt`
`ghlSubscriptions`	`by_location_syncedAt`	`locationId`, `syncedAt`
`ghlSubscriptions`	`by_location_status_syncedAt`	`locationId`, `status`, `syncedAt`
`ghlSubscriptions`	`by_location_subscription`	`locationId`, `ghlSubscriptionId`
`ghlSubscriptions`	`by_status`	`status`
`ghlSubscriptions`	`by_contact`	`contactId`
`ghlSubscriptions`	`by_contact_email`	`contactEmail`
`salesCommissions`	`by_zoho_record_type`	`zohoRecordId`, `eventType`
`salesCommissions`	`by_setter`	`setterId`
`salesCommissions`	`by_setter_period`	`setterId`, `payPeriodStart`
`salesCommissions`	`by_location`	`locationId`
`salesCommissions`	`by_location_statusChangedAt`	`locationId`, `statusChangedAt`
`salesCommissions`	`by_location_period`	`locationId`, `payPeriodStart`
`salesCommissions`	`by_pay_period`	`payPeriodStart`, `isPaid`
`salesCommissions`	`by_org`	`zohoOrgId`
`closerCommissions`	`by_zoho_record`	`zohoRecordId`
`closerCommissions`	`by_closer`	`closerId`
`closerCommissions`	`by_closer_period`	`closerId`, `payPeriodStart`
`closerCommissions`	`by_location`	`locationId`
`closerCommissions`	`by_location_period`	`locationId`, `payPeriodStart`
`closerCommissions`	`by_pay_period`	`payPeriodStart`, `isPaid`
`closerCommissions`	`by_org`	`zohoOrgId`
`processingSubmissions`	`by_contact`	`contactId`
`processingSubmissions`	`by_location`	`locationId`
`processingSubmissions`	`by_contact_location`	`contactId`, `locationId`
`processingSubmissions`	`by_status`	`status`
`processingSubmissions`	`by_location_status`	`locationId`, `status`
`processingSubmissions`	`by_location_createdAt`	`locationId`, `createdAt`
`processingSubmissionComments`	`by_submission`	`submissionId`
`processingSubmissionComments`	`by_contact_location`	`contactId`, `locationId`
`processingAttachments`	`by_submission`	`submissionId`
`processingAttachments`	`by_contact_location`	`contactId`, `locationId`
`contactPipelineStates`	`by_location`	`locationId`
`contactPipelineStates`	`by_location_pipeline`	`locationId`, `pipelineType`
`contactPipelineStates`	`by_contact_location`	`contactId`, `locationId`
`contactPipelineStates`	`by_contact_location_pipeline`	`contactId`, `locationId`, `pipelineType`
`documents`	`by_contact`	`contactId`
`documents`	`by_contact_location`	`contactId`, `locationId`
`documents`	`by_location`	`locationId`
`documents`	`by_type`	`fileType`
`documents`	`by_location_createdAt`	`locationId`, `createdAt`
`documents`	`by_ghlDocumentId`	`ghlDocumentId`
`documents`	`by_ghlReferenceId`	`ghlReferenceId`
`documents`	`by_externalUrl`	`externalUrl`
`documentUploadTokens`	`by_token`	`token`
`documentUploadTokens`	`by_contact`	`contactId`
`documentUploadTokens`	`by_location`	`locationId`
`termLoanSubmissions`	`by_contact`	`contactId`
`termLoanSubmissions`	`by_contact_location`	`contactId`, `locationId`
`termLoanSubmissions`	`by_location`	`locationId`
`termLoanSubmissions`	`by_location_submittedAt`	`locationId`, `submittedAt`
`termLoanSubmissions`	`by_status`	`status`
`termLoanSubmissions`	`by_location_createdAt`	`locationId`, `createdAt`
`termLoanSubmissions`	`by_leadUuid`	`leadUuid`
`termLoanSubmissions`	`by_offersResultsUuid`	`offersResultsUuid`
`termLoanLeadEvents`	`by_engineEventId`	`engineEventId`
`termLoanLeadEvents`	`by_leadUuid`	`leadUuid`
`termLoanLeadEvents`	`by_submissionId`	`submissionId`
`termLoanLeadEvents`	`by_leadUuid_eventCreatedAt`	`leadUuid`, `eventCreatedAt`
`engineAnalyticsCursors`	`by_endpoint`	`endpoint`
`termLoanDrafts`	`by_location_contact`	`locationId`, `contactId`
`processingFees`	`by_contact`	`contactId`
`processingFees`	`by_location`	`locationId`
`processingFees`	`by_contact_location`	`contactId`, `locationId`
`processingFees`	`by_status`	`status`
`processingFees`	`by_location_status`	`locationId`, `status`
`processingFees`	`by_createdAt`	`createdAt`
`processingFees`	`by_location_createdAt`	`locationId`, `createdAt`
`processingFees`	`by_location_status_createdAt`	`locationId`, `status`, `createdAt`
`contactInvoices`	`by_locationId_contactId`	`locationId`, `contactId`
`contactInvoices`	`by_location_createdAt`	`locationId`, `createdAt`
`contactInvoices`	`by_invoiceId`	`invoiceId`
`contactInvoices`	`by_status_sentAt`	`status`, `sentAt`
`contactInvoices`	`by_status_paidAt`	`status`, `paidAt`
`operatorInvoices`	`by_contact_location_createdAt`	`contactId`, `locationId`, `createdAt`
`operatorInvoices`	`by_status`	`status`
`operatorInvoices`	`by_dueDate`	`dueDate`
`operatorInvoices`	`by_location_status`	`locationId`, `status`
`operatorInvoices`	`by_location_createdAt`	`locationId`, `createdAt`
`operatorInvoices`	`by_sourceClientInvoiceId`	`sourceClientInvoiceId`
`operatorInvoices`	`by_mfmInvoiceId`	`mfmInvoiceId`
`operatorInvoices`	`by_operatorLocationId_status`	`operatorLocationId`, `status`
`billingCharges`	`by_location_created`	`locationId`, `createdAt`
`billingCharges`	`by_request`	`requestId`
`billingCharges`	`by_event`	`eventId`
`locationBillingConfig`	`by_location`	`locationId`
`billingAlerts`	`by_status`	`status`
`billingAlerts`	`by_location`	`locationId`
`billingAlerts`	`by_location_status`	`locationId`, `status`
`billingRetryQueue`	`by_status_retry`	`status`, `nextRetryAt`
`billingRetryQueue`	`by_formSubmission`	`formSubmissionId`
`supportTickets`	`by_status`	`status`
`supportTickets`	`by_location`	`locationId`
`supportTickets`	`by_location_status`	`locationId`, `status`
`supportTickets`	`by_contact`	`contactId`
`supportSignals`	`by_source_and_sourceId`	`source`, `sourceId`
`supportSignals`	`by_status_and_updatedAt`	`status`, `updatedAt`
`supportSignals`	`by_classification_and_updatedAt`	`classification`, `updatedAt`
`supportSignals`	`by_linearIssueKey`	`linearIssueKey`
`supportVerifications`	`by_signalId_and_createdAt`	`signalId`, `createdAt`
`supportVerifications`	`by_classification_and_createdAt`	`classification`, `createdAt`
`supportClusters`	`by_signature`	`signature`
`supportClusters`	`by_status_and_lastSeen`	`status`, `lastSeen`
`supportClusters`	`by_status_and_count`	`status`, `count`
`supportDraftReplies`	`by_signalId_and_createdAt`	`signalId`, `createdAt`
`supportDraftReplies`	`by_status_and_updatedAt`	`status`, `updatedAt`
`supportApprovalAudit`	`by_signalId_and_approvedAt`	`signalId`, `approvedAt`
`supportApprovalAudit`	`by_approvedAt`	`approvedAt`
`supportApprovalAudit`	`by_approvedBy_and_approvedAt`	`approvedBy`, `approvedAt`
`supportMessageAcknowledgements`	`by_location_createdAt`	`locationId`, `createdAt`
`supportMessageAcknowledgements`	`by_location_contact_createdAt`	`locationId`, `contactId`, `createdAt`
`supportMessageAcknowledgements`	`by_inboundMessageId`	`inboundMessageId`
`clientHealthSnapshots`	`by_weekOf`	`weekOf`
`clientHealthScores`	`by_contact`	`contactId`
`clientHealthScores`	`by_location`	`locationId`
`clientHealthScores`	`by_location_category`	`locationId`, `category`
`locationNotes`	`by_location_createdAt`	`locationId`, `createdAt`
`locationTransfers`	`by_location_createdAt`	`locationId`, `createdAt`
`locationTransfers`	`by_status_createdAt`	`status`, `createdAt`
`locationTransfers`	`by_batch`	`batchId`
`locationTransfers`	`by_createdAt`	`createdAt`
`agencyMigrations`	`by_location_createdAt`	`locationId`, `createdAt`
`agencyMigrations`	`by_status_createdAt`	`status`, `createdAt`
`agencyMigrations`	`by_createdAt`	`createdAt`
`agencyMigrations`	`by_newStripeSubscriptionId`	`newStripeSubscriptionId`
`onboardingSubmissions`	`by_submission_id`	`submissionId`
`onboardingSubmissions`	`by_status`	`status`
`onboardingSubmissions`	`by_company`	`companyName`
`onboardingSubmissions`	`by_createdAt`	`createdAt`
`provisioningJobs`	`by_submission`	`submissionId`
`provisioningJobs`	`by_status`	`status`
`provisioningJobs`	`by_createdAt`	`createdAt`
`provisioningLogs`	`by_job`	`jobId`
`provisioningLogs`	`by_status`	`status`
`partnerReferralLinks`	`by_clerk_org`	`clerkOrgId`
`partnerReferralLinks`	`by_dub_link`	`dubLinkId`
`partnerOrganizations`	`by_clerk_org`	`clerkOrgId`
`partnerOrganizations`	`by_slug`	`slug`
`partnerOrganizations`	`by_location`	`locationId`
`applicantCreationLocks`	`by_contact_pipeline`	`locationId`, `contactId`, `pipelineId`
`outreachCallLocks`	`by_partner`	`partnerId`
`leadEvents`	`by_location`	`locationId`
`leadEvents`	`by_contact_location`	`contactId`, `locationId`
`leadEvents`	`by_contact_location_createdAt`	`contactId`, `locationId`, `createdAt`
`leadEvents`	`by_status_createdAt`	`status`, `createdAt`
`leadEvents`	`by_location_createdAt`	`locationId`, `createdAt`
`clientHealthAlerts`	`by_location`	`locationId`
`clientHealthAlerts`	`by_contact`	`contactId`
`clientHealthAlerts`	`by_location_status`	`locationId`, `status`
`processingTeam`	`by_userId`	`userId`
`processingTeam`	`by_email`	`email`
`processingTeam`	`by_active`	`isActive`
`processingConfig`	`by_key`	`key`
`impersonationLog`	`by_locationId`	`locationId`
`impersonationLog`	`by_contactId`	`contactId`
`impersonationLog`	`by_operatorEmail`	`operatorEmail`
`webhookEvents`	`by_processed`	`processed`
`webhookEvents`	`by_repo`	`repo`
`webhookEvents`	`by_receivedAt`	`receivedAt`
`migrationMapping`	`by_locationId`	`locationId`
`migrationMapping`	`by_status`	`status`
`migrationMapping`	`by_email`	`clientEmail`
`autoCreditPullEvents`	`by_decided_at`	`decidedAt`
`autoCreditPullEvents`	`by_location`	`locationId`, `decidedAt`
`autoCreditPullEvents`	`by_outcome`	`outcome`, `decidedAt`
`autoCreditPullEvents`	`by_contact`	`contactId`, `decidedAt`
`autoCreditPullEvents`	`by_contact_location`	`contactId`, `locationId`, `decidedAt`
`prospectingCampaigns`	`by_slug`	`slug`
`prospectingCampaigns`	`by_status`	`status`
`prospectingCampaigns`	`by_createdAt`	`createdAt`
`outreachShortLinks`	`by_partner_template`	`partnerId`, `template`
`outreachShortLinks`	`by_slug`	`slug`
`prospectingPartners`	`by_clerkUserId`	`clerkUserId`
`prospectingPartners`	`by_userId`	`userId`
`prospectingPartners`	`by_ghlLocationId`	`ghlLocationId`
`prospectingPartners`	`by_stripeCustomerId`	`stripeCustomerId`
`prospectingPartners`	`by_stripeCheckoutSessionId`	`stripeCheckoutSessionId`
`prospectingPartners`	`by_status`	`status`
`prospectingPartners`	`by_email`	`contactEmail`
`prospectingPartners`	`by_createdAt`	`createdAt`
`prospectingPartners`	`by_outreachTeam`	`outreachTeamId`
`prospectingPartners`	`by_outreachTeam_verified`	`outreachTeamId`, `outreachVerifiedAt`
`prospectingPartners`	`by_status_createdAt`	`status`, `createdAt`
`prospectingOutreachTeams`	`by_slug`	`slug`
`prospectingOutreachTeams`	`by_ghlLocationId`	`ghlLocationId`
`prospectingOutreachTeams`	`by_status`	`status`
`prospectingActivity`	`by_partner_at`	`partnerId`, `at`
`prospectingActivity`	`by_partner_kind_at`	`partnerId`, `kind`, `at`
`prospectingActivity`	`by_campaign_at`	`campaignId`, `at`
`prospectingActivity`	`by_lead_at`	`leadId`, `at`
`prospectingActivity`	`by_lead_kind_at`	`leadId`, `kind`, `at`
`prospectingActivity`	`by_at`	`at`
`prospectingOutreachMessageReceipts`	`by_messageId`	`messageId`
`prospectingOutreachMessageReceipts`	`by_lead_createdAt`	`leadId`, `createdAt`
`prospectingAiReplyControls`	`by_contact`	`partnerId`, `ghlContactId`
`prospectingAiReplyControls`	`by_campaign`	`campaignId`
`prospectingAiReplyControls`	`by_partner_updatedAt`	`partnerId`, `updatedAt`
`prospectingAiReplyDrafts`	`by_lead_updatedAt`	`leadId`, `updatedAt`
`prospectingAiReplyDrafts`	`by_status_updatedAt`	`status`, `updatedAt`
`prospectingAiReplyDrafts`	`by_contact_updatedAt`	`partnerId`, `ghlContactId`, `updatedAt`
`prospectingAiReplyDrafts`	`by_campaign_updatedAt`	`campaignId`, `updatedAt`
`prospectingAiReplyDrafts`	`by_inboundMessageId`	`inboundMessageId`
`prospectingLeads`	`by_partner_received`	`partnerId`, `receivedAt`
`prospectingLeads`	`by_partner_ghlContact_received`	`partnerId`, `ghlContactId`, `receivedAt`
`prospectingLeads`	`by_outreachTeamGhlContactId`	`outreachTeamGhlContactId`
`prospectingLeads`	`by_partner_status_received`	`partnerId`, `status`, `receivedAt`
`prospectingLeads`	`by_status`	`status`, `receivedAt`
`prospectingLeads`	`by_campaign_received`	`campaignId`, `receivedAt`
`prospectingLeads`	`by_receivedAt`	`receivedAt`
`prospectingDeliveryLog`	`by_lead_at`	`leadId`, `at`
`prospectingDeliveryLog`	`by_partner_at`	`partnerId`, `at`
`prospectingDeliveryLog`	`by_partner_kind_at`	`partnerId`, `kind`, `at`
`prospectingDeliveryLog`	`by_at`	`at`
`prospectingAllocations`	`by_partner_month`	`partnerId`, `month`
`prospectingAllocations`	`by_month`	`month`
`prospectingCoupons`	`by_code`	`code`
`prospectingCoupons`	`by_status`	`status`, `createdAt`
`prospectingVolumeCodes`	`by_code`	`code`
`prospectingVolumeCodes`	`by_status`	`status`, `createdAt`
`prospectingVolumeCodes`	`by_partnerEmail`	`partnerEmail`
`prospectingLeadInvoiceTracking`	`by_status`	`status`, `updatedAt`
`prospectingLeadInvoiceTracking`	`by_partner_updatedAt`	`partnerId`, `updatedAt`
`prospectingLeadInvoiceTracking`	`by_lead`	`leadId`
`prospectingLeadInvoiceTracking`	`by_invoice`	`ghlInvoiceId`
`prospectingLeadInvoiceTracking`	`by_reconciledAt`	`reconciledAt`
`automationLocationConfig`	`by_locationId`	`locationId`
`automationSettings`	`by_locationId`	`locationId`
`automationSettings`	`by_locationId_and_triggerKey`	`locationId`, `triggerKey`
`automationSends`	`by_locationId_and_createdAt`	`locationId`, `createdAt`
`automationSends`	`by_reportId`	`reportId`
`automationSends`	`by_idempotencyKey`	`idempotencyKey`
`automationSends`	`by_locationId_and_triggerKey_and_createdAt`	`locationId`, `triggerKey`, `createdAt`
`businessQuestionnaires`	`by_contact`	`contactId`, `locationId`
`prospectingReportRuns`	`by_campaign_runAt`	`campaignId`, `runAt`
`prospectingReportRuns`	`by_runAt`	`runAt`
`analyticsReports`	`by_location`	`locationId`
`analyticsReports`	`by_location_dataSource`	`locationId`, `dataSource`
`analyticsScheduledReports`	`by_enabled_nextRunAt`	`enabled`, `nextRunAt`
`analyticsScheduledReports`	`by_location`	`locationId`
`analyticsScheduledReports`	`by_report`	`reportId`
`analyticsReportFiles`	`by_expiresAt`	`expiresAt`
`analyticsReportFiles`	`by_location`	`locationId`
`dataAccessSettings`	`by_location`	`locationId`
`crmUserScopeCache`	`by_location_user`	`locationId`, `userId`
`crmUserScopeCache`	`by_location`	`locationId`
`underwritingReviewLabels`	`by_requestId_createdAt`	`requestId`, `createdAt`
`underwritingReviewLabels`	`by_createdAt`	`createdAt`
`underwritingReviewLabels`	`by_verdict_createdAt`	`verdict`, `createdAt`
`underwritingReviewLabels`	`by_location_createdAt`	`locationId`, `createdAt`
`underwritingCalibrationProposals`	`by_createdAt`	`createdAt`
`underwritingCalibrationProposals`	`by_status_createdAt`	`status`, `createdAt`
`underwritingReviewFlags`	`by_status_createdAt`	`status`, `createdAt`
`underwritingReviewFlags`	`by_requestId`	`requestId`
`underwritingReviewFlags`	`by_category_status`	`category`, `status`

B. Queries without `.withIndex(...)` (table-scan candidates)

File:Line	Table	Snippet
`convex/admin/revertAutoApplicantPromotion.ts:102`	`prospectingLeads`	`ctx.db .query("prospectingLeads") .order("desc") .paginate({ cursor, numItems: PAGE })`
`convex/adminDashboard.ts:51`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(GLOBAL_REFERENCE_SCAN_CAP)`
`convex/adminDashboard.ts:52`	`creditReportRequests`	`ctx.db.query("creditReportRequests").take(GLOBAL_AGGREGATE_CAP)`
`convex/adminDashboard.ts:53`	`underwritingResults`	`ctx.db.query("underwritingResults").take(GLOBAL_AGGREGATE_CAP)`
`convex/adminDashboard.ts:54`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(GLOBAL_AGGREGATE_CAP)`
`convex/adminDashboard.ts:157`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(GLOBAL_AGGREGATE_CAP)`
`convex/adminDashboard.ts:172`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(GLOBAL_REFERENCE_SCAN_CAP)`
`convex/adminDashboard.ts:501`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(GLOBAL_AGGREGATE_CAP)`
`convex/adminDashboard.ts:602`	`creditReportRequests`	`ctx.db.query("creditReportRequests").order("desc").take(limit)`
`convex/adminDashboard.ts:625`	`underwritingResults`	`ctx.db.query("underwritingResults").order("desc").take(limit)`
`convex/adminDashboard.ts:651`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").order("desc").take(limit)`
`convex/adminDashboard.ts:677`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .take(GLOBAL_REFERENCE_SCAN_CAP)`
`convex/adminDashboard.ts:806`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .take(GLOBAL_REFERENCE_SCAN_CAP)`
`convex/adminMetrics.ts:96`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:98`	`creditReportRequests`	`ctx.db.query("creditReportRequests").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:100`	`underwritingResults`	`ctx.db.query("underwritingResults").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:102`	`fundingPlans`	`ctx.db.query("fundingPlans").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:172`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:264`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:275`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:434`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:743`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .order("desc") .take(limit)`
`convex/adminMetrics.ts:773`	`underwritingResults`	`ctx.db .query("underwritingResults") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1053`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1082`	`underwritingResults`	`ctx.db .query("underwritingResults") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1143`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .order("desc") .take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetricsReads.ts:674`	`ghlSubscriptions`	`ctx.db .query("ghlSubscriptions") .take(SOURCE_QUERY_LIMIT)`
`convex/autoAssign.ts:33`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .filter((q) => q.neq(q.field("assignedToUserId"), undefined)) .take(5000)`
`convex/autoAssign.ts:277`	`processingTeam`	`ctx.db .query("processingTeam") .take(100)`
`convex/cards.ts:121`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:141`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:164`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:177`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:192`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:205`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:219`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:309`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:354`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:391`	`cards`	`ctx.db.query("cards").take(500)`
`convex/cards.ts:394`	`fundingPlans`	`ctx.db.query("fundingPlans").take(500)`
`convex/checkInstallations.ts:9`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .take(INSTALLATIONS_QUERY_LIMIT + 1)`
`convex/fundingPlans.ts:649`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:797`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:882`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:984`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:1589`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/ghlInstallations.ts:297`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(10_000)`
`convex/globalSearch.ts:115`	`processingSubmissions`	`ctx.db.query("processingSubmissions").order("desc").take(scanLimit)`
`convex/globalSearch.ts:116`	`fundingPlans`	`ctx.db.query("fundingPlans").order("desc").take(scanLimit)`
`convex/globalSearch.ts:117`	`operatorInvoices`	`ctx.db.query("operatorInvoices").order("desc").take(scanLimit)`
`convex/lib/underwritingQueue.ts:356`	`underwritingResults`	`ctx.db.query("underwritingResults").take(8000)`
`convex/lib/underwritingStore.ts:233`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(100)`
`convex/migrations.ts:1492`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(scanLimit)`
`convex/migrations/2026_05_18_provision_short_links.ts:98`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .take(PARTNER_SCAN_CAP)`
`convex/migrations/2026_05_18_provision_short_links.ts:137`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .take(PARTNER_SCAN_CAP)`
`convex/migrations/bulkFixCrmStagesHelpers.ts:15`	`zohoDeals`	`ctx.db.query("zohoDeals")`
`convex/oneOffMigrations.ts:81`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .paginate({ cursor: args.cursor ?? null, numItems: batchSize })`
`convex/oneOffMigrations.ts:159`	`underwritingResults`	`ctx.db .query("underwritingResults") .paginate({ cursor: args.cursor ?? null, numItems: batchSize })`
`convex/oneOffMigrations.ts:201`	`underwritingResults`	`ctx.db .query("underwritingResults") .paginate({ cursor: args.cursor ?? null, numItems: batchSize })`
`convex/oneOffMigrations.ts:259`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .paginate({ cursor: args.cursor ?? null, numItems: batchSize })`
`convex/oneOffMigrations.ts:429`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor ?? null, numItems: 200 })`
`convex/oneOffMigrations.ts:502`	`underwritingResults`	`ctx.db .query("underwritingResults") .paginate({ cursor: args.cursor ?? null, numItems: 500 })`
`convex/oneOffMigrations.ts:593`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor, numItems: SEED_PAGE_SIZE })`
`convex/oneOffMigrations.ts:1658`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor, numItems: CAMPAIGN_DELETE_PAGE_SIZE, })`
`convex/oneOffMigrations.ts:1794`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor, numItems: Math.max(1, Math.min(args.numItems, 100)), })`
`convex/partnerReferralLinks.ts:23`	`partnerReferralLinks`	`ctx.db .query("partnerReferralLinks") .filter((q) => q.eq(q.field("status"), "active")) .take(500)`
`convex/processingFees.ts:155`	`processingFees`	`ctx.db .query("processingFees") .order("desc") .take(PROCESSING_FEE_SCAN_CAP)`
`convex/processingFees.ts:187`	`processingFees`	`ctx.db .query("processingFees") .order("desc") .take(PROCESSING_FEE_SCAN_CAP)`
`convex/processingSubmissions.ts:108`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .filter((q) => q.eq(q.field("contactId"), args.contactId)) .order("desc") .take(1)`
`convex/processingSubmissions.ts:249`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .take(1000)`
`convex/processingSubmissions.ts:397`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .take(1000)`
`convex/processingSubmissions.ts:1360`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/processingSubmissions.ts:1479`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/processingSubmissions.ts:1605`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/prospecting/insights.ts:89`	`prospectingAllocations`	`ctx.db .query("prospectingAllocations") .take(ALLOCATIONS_SCAN_CAP)`
`convex/prospecting/leads.ts:732`	`prospectingLeads`	`ctx.db .query("prospectingLeads") .paginate({ cursor: args.cursor, numItems: args.numItems ?? 200 })`
`convex/prospecting/outreachTeamsAdmin.ts:101`	`prospectingOutreachTeams`	`ctx.db.query("prospectingOutreachTeams").take(100)`
`convex/salesCommissions.ts:285`	`salesCommissions`	`ctx.db .query("salesCommissions") .order("desc") .take(limit)`
`convex/zohoVerticalAccounts.ts:113`	`zohoVerticalAccounts`	`ctx.db .query("zohoVerticalAccounts") .order("desc") .take(limit)`

Note: a query() without .withIndex(...) is not always a bug — it may be intentionally fetching a single doc by id or operating on a tiny table (get, unique, first, etc.). Treat this list as a triage queue, not a defect list.

C. Missing table-scoped index references

Each .withIndex("name") below is checked against the indexes declared on that exact ctx.db.query("table") table. None detected.

D. Unbounded `.collect()` locations

“Unbounded” = a .collect() with no preceding .withIndex(...) and no .take(N) in the same chain. These walk the entire table. None detected.

Re-run with bun run scripts/audit-convex-indexes.ts. The JSON sidecar at the same path is available for follow-up tooling (e.g. piping into Linear, an annotated diff, or a custom reporter).

Getting Started

Funding

Prospecting

Billing

Partners

CRM Platform Guide

Convex index audit 2026 06 16

Convex Index Audit

A. Tables & indexes

B. Queries without `.withIndex(...)` (table-scan candidates)

C. Missing table-scoped index references

D. Unbounded `.collect()` locations

​Convex Index Audit

​A. Tables & indexes

​B. Queries without .withIndex(...) (table-scan candidates)

​C. Missing table-scoped index references

​D. Unbounded .collect() locations

Convex Index Audit

A. Tables & indexes

B. Queries without `.withIndex(...)` (table-scan candidates)

C. Missing table-scoped index references

D. Unbounded `.collect()` locations