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-05-17T08:30:46.361Z
Schema source: convex/schema.ts
Convex files scanned: 179
Tables declared: 96 (with 298 total indexes)
Tables with zero indexes: 1
Queries: 879 total — 799 use .withIndex(...), 80 look like table scans
.collect() calls: 190 total — 167 bounded (scoped by .withIndex(...) or capped by .take(N)), 23 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_company`	`companyId`
`creditReportRequests`	`by_location`	`locationId`
`creditReportRequests`	`by_createdAt`	`createdAt`
`creditReportRequests`	`by_location_createdAt`	`locationId`, `createdAt`
`stitchCreditTokens`	(no indexes)	—
`underwritingResults`	`by_report`	`reportId`
`underwritingResults`	`by_contact`	`contactId`
`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_createdAt`	`createdAt`
`fundingPlans`	`by_location_createdAt`	`locationId`, `createdAt`
`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_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_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`
`contactPipelineStates`	`by_location`	`locationId`
`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`
`contactInvoices`	`by_locationId_contactId`	`locationId`, `contactId`
`contactInvoices`	`by_location_createdAt`	`locationId`, `createdAt`
`contactInvoices`	`by_invoiceId`	`invoiceId`
`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`
`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`
`onboardingSubmissions`	`by_submission_id`	`submissionId`
`onboardingSubmissions`	`by_status`	`status`
`onboardingSubmissions`	`by_company`	`companyName`
`provisioningJobs`	`by_submission`	`submissionId`
`provisioningJobs`	`by_status`	`status`
`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`
`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_campaign_at`	`campaignId`, `at`
`prospectingActivity`	`by_lead_at`	`leadId`, `at`
`prospectingActivity`	`by_at`	`at`
`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_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_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`
`prospectingReportRuns`	`by_campaign_runAt`	`campaignId`, `runAt`
`prospectingReportRuns`	`by_runAt`	`runAt`

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

File:Line	Table	Snippet
`convex/admin.ts:139`	`fundingPlans`	`ctx.db .query("fundingPlans") .collect()`
`convex/admin.ts:149`	`savedFilters`	`ctx.db .query("savedFilters") .collect()`
`convex/adminDashboard.ts:29`	`ghlInstallations`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:31`	`creditReportRequests`	`ctx.db.query("creditReportRequests").collect()`
`convex/adminDashboard.ts:33`	`underwritingResults`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:35`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:122`	`underwritingResults`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:127`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:137`	`fundingPlans`	`ctx.db.query("fundingPlans").collect()`
`convex/adminDashboard.ts:141`	`ghlInstallations`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:377`	`underwritingResults`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:471`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:572`	`creditReportRequests`	`ctx.db.query("creditReportRequests").order("desc").take(limit)`
`convex/adminDashboard.ts:604`	`underwritingResults`	`ctx.db.query("underwritingResults").order("desc").take(limit)`
`convex/adminDashboard.ts:630`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").order("desc").take(limit)`
`convex/adminDashboard.ts:656`	`ghlInstallations`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:782`	`ghlInstallations`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminInstallations.ts:15`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .take(500)`
`convex/adminMetrics.ts:90`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:92`	`creditReportRequests`	`ctx.db.query("creditReportRequests").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:94`	`underwritingResults`	`ctx.db.query("underwritingResults").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:96`	`fundingPlans`	`ctx.db.query("fundingPlans").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:166`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:258`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:269`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:420`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)`
`convex/adminMetrics.ts:431`	`ghlSubscriptions`	`ctx.db.query("ghlSubscriptions").take(STATS_QUERY_LIMIT)`
`convex/adminMetrics.ts:875`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .order("desc") .take(limit)`
`convex/adminMetrics.ts:905`	`underwritingResults`	`ctx.db .query("underwritingResults") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1167`	`creditReportRequests`	`ctx.db .query("creditReportRequests") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1196`	`underwritingResults`	`ctx.db .query("underwritingResults") .order("desc") .take(limit)`
`convex/adminMetrics.ts:1257`	`ghlInstallations`	`ctx.db .query("ghlInstallations") .order("desc") .take(INSTALLATIONS_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:469`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:617`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:702`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:804`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/fundingPlans.ts:1409`	`fundingPlans`	`ctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)`
`convex/ghlInstallations.ts:307`	`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/migrations/bulkFixCrmStagesHelpers.ts:15`	`zohoDeals`	`ctx.db.query("zohoDeals")`
`convex/oneOffMigrations.ts:157`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor ?? null, numItems: 200 })`
`convex/oneOffMigrations.ts:227`	`underwritingResults`	`ctx.db .query("underwritingResults") .paginate({ cursor: args.cursor ?? null, numItems: 500 })`
`convex/oneOffMigrations.ts:278`	`locationSettings`	`ctx.db .query("locationSettings") .paginate({ cursor: args.cursor ?? null, numItems: 500 })`
`convex/oneOffMigrations.ts:495`	`prospectingPartners`	`ctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor, numItems: SEED_PAGE_SIZE })`
`convex/partnerReferralLinks.ts:23`	`partnerReferralLinks`	`ctx.db .query("partnerReferralLinks") .filter((q) => q.eq(q.field("status"), "active")) .take(500)`
`convex/processingFees.ts:146`	`processingFees`	`ctx.db.query("processingFees").collect()`
`convex/processingFees.ts:183`	`processingFees`	`ctx.db.query("processingFees").collect()`
`convex/processingSubmissions.ts:101`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .filter((q) => q.eq(q.field("contactId"), args.contactId)) .order("desc") .take(1)`
`convex/processingSubmissions.ts:242`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .take(1000)`
`convex/processingSubmissions.ts:390`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .take(1000)`
`convex/processingSubmissions.ts:1278`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/processingSubmissions.ts:1397`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/processingSubmissions.ts:1523`	`processingSubmissions`	`ctx.db .query("processingSubmissions") .paginate(args.paginationOpts)`
`convex/prospecting/outreachTeamsAdmin.ts:96`	`prospectingOutreachTeams`	`ctx.db.query("prospectingOutreachTeams").take(100)`
`convex/provisioning.ts:382`	`provisioningJobs`	`ctx.db.query("provisioningJobs").collect()`
`convex/provisioning.ts:407`	`onboardingSubmissions`	`ctx.db .query("onboardingSubmissions") .collect()`
`convex/provisioning.ts:430`	`provisioningJobs`	`ctx.db.query("provisioningJobs").collect()`
`convex/salesCommissions.ts:285`	`salesCommissions`	`ctx.db .query("salesCommissions") .order("desc") .take(limit)`
`convex/stitchCreditTokens.ts:15`	`stitchCreditTokens`	`ctx.db .query("stitchCreditTokens") .order("desc") .first()`
`convex/stitchCreditTokens.ts:45`	`stitchCreditTokens`	`ctx.db .query("stitchCreditTokens") .order("desc") .first()`
`convex/underwriting.ts:1950`	`ghlInstallations`	`ctx.db.query("ghlInstallations").take(100)`
`convex/underwriting.ts:3390`	`underwritingResults`	`ctx.db.query("underwritingResults").take(8000)`
`convex/zohoSync.ts:1056`	`zohoCreditReports`	`ctx.db.query("zohoCreditReports").collect()`
`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. Unbounded `.collect()` locations

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

File:Line	Snippet
`convex/admin.ts:141`	`.query("fundingPlans") .collect()`
`convex/admin.ts:151`	`.query("savedFilters") .collect()`
`convex/adminDashboard.ts:29`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:31`	`ctx.db.query("creditReportRequests").collect()`
`convex/adminDashboard.ts:33`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:35`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:122`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:127`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:137`	`ctx.db.query("fundingPlans").collect()`
`convex/adminDashboard.ts:141`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:377`	`ctx.db.query("underwritingResults").collect()`
`convex/adminDashboard.ts:471`	`ctx.db.query("ghlSubscriptions").collect()`
`convex/adminDashboard.ts:656`	`ctx.db.query("ghlInstallations").collect()`
`convex/adminDashboard.ts:782`	`ctx.db.query("ghlInstallations").collect()`
`convex/migrations.ts:395`	`await query.collect()`
`convex/processingFees.ts:96`	`await feesQuery.collect()`
`convex/processingFees.ts:146`	`ctx.db.query("processingFees").collect()`
`convex/processingFees.ts:183`	`ctx.db.query("processingFees").collect()`
`convex/provisioning.ts:382`	`ctx.db.query("provisioningJobs").collect()`
`convex/provisioning.ts:409`	`.query("onboardingSubmissions") .collect()`
`convex/provisioning.ts:430`	`ctx.db.query("provisioningJobs").collect()`
`convex/termLoanSubmissions.ts:660`	`return submissionsQuery.collect()`
`convex/zohoSync.ts:1056`	`ctx.db.query("zohoCreditReports").collect()`

Note: unbounded .collect() is flagged by the pre-commit Convex linter as a blocking error. Each entry above should ideally be replaced with .take(N) (or paginated). Some may be safe because the underlying table is provably small (e.g. one row per location); confirm before changing behavior.

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 05 17

Convex Index Audit

A. Tables & indexes

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

C. Unbounded `.collect()` locations

​Convex Index Audit

​A. Tables & indexes

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

​C. Unbounded .collect() locations

Convex Index Audit

A. Tables & indexes

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

C. Unbounded `.collect()` locations