Skip to main content

​
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

TableIndexFields
ghlInstallationsby_companycompanyId
ghlInstallationsby_locationlocationId
ghlInstallationsby_createdAtcreatedAt
ghlInstallationsby_expiresAtexpiresAt
roundRobinStateby_locationIdlocationId
leadReassignmentAuditsby_locationId_and_createdAtlocationId, createdAt
usersby_user_iduserId
organizationsby_locationlocationId
organizationMembershipsby_orgorgId
organizationMembershipsby_user_orguserId, orgId
creditReportRequestsby_requestrequestId
creditReportRequestsby_requestId_locationIdrequestId, locationId
creditReportRequestsby_contactcontactId
creditReportRequestsby_companycompanyId
creditReportRequestsby_locationlocationId
creditReportRequestsby_createdAtcreatedAt
creditReportRequestsby_location_createdAtlocationId, createdAt
stitchCreditTokens(no indexes)—
underwritingResultsby_reportreportId
underwritingResultsby_contactcontactId
underwritingResultsby_locationlocationId
underwritingResultsby_createdAtcreatedAt
underwritingResultsby_location_createdAtlocationId, createdAt
cardsby_recordIdrecordId
cardsby_cardTypecardType
fundingPlansby_contactcontactId
fundingPlansby_locationlocationId
fundingPlansby_contact_locationcontactId, locationId
fundingPlansby_createdAtcreatedAt
fundingPlansby_location_createdAtlocationId, createdAt
columnConfigsby_location_tablelocationId, tableType
savedFiltersby_location_pagelocationId, pageType
zohoVerticalAccountsby_orgzohoOrgId
zohoInstallationsby_locationlocationId
zohoInstallationsby_orgzohoOrgId
migrationJobsby_locationlocationId
migrationJobsby_statusstatus
migrationJobsby_location_statuslocationId, status
migrationLogsby_jobjobId
migrationLogsby_zoho_recordzohoRecordId
migrationLogsby_job_statusjobId, status
crmStageFixRunsby_createdAtcreatedAt
crmStageFixRunsby_statusstatus
crmStageFixRunsby_location_createdAtlocationId, createdAt
migratedContactsby_ghl_contactghlContactId
migratedContactsby_locationlocationId
migratedContactsby_zoho_recordzohoRecordId
migratedContactsby_location_sourcelocationId, dataSource
migratedContactsby_validation_statuslocationId, dateValidationStatus
dateAuditTrailby_ghl_contactghlContactId
dateAuditTrailby_locationlocationId
dateAuditTrailby_jobmigrationJobId
dateAuditTrailby_fieldghlContactId, fieldName
onboardingProgressby_locationlocationId
onboardingCallsby_locationlocationId
onboardingCallsby_location_typelocationId, callType
slackInvitesby_locationlocationId
communityAccessSettingsby_locationlocationId
locationSettingsby_locationlocationId
aiAgentRunsby_location_and_createdAtlocationId, createdAt
aiAgentRunsby_location_and_useCase_and_createdAtlocationId, useCase, createdAt
aiAgentRunsby_status_and_createdAtstatus, createdAt
aiAgentRunsby_approvalState_and_createdAtapprovalState, createdAt
contactInvoiceAgreementOverridesby_locationId_contactIdlocationId, contactId
locationGhlMappingsby_locationlocationId
customValuesby_locationlocationId
zohoLeadsby_orgzohoOrgId
zohoLeadsby_locationlocationId
zohoLeadsby_zoho_recordzohoRecordId
zohoLeadsby_org_recordzohoOrgId, zohoRecordId
zohoDealsby_orgzohoOrgId
zohoDealsby_locationlocationId
zohoDealsby_zoho_recordzohoRecordId
zohoDealsby_org_recordzohoOrgId, zohoRecordId
zohoCreditReportsby_orgzohoOrgId
zohoCreditReportsby_locationlocationId
zohoCreditReportsby_zoho_recordzohoRecordId
zohoCreditReportsby_org_recordzohoOrgId, zohoRecordId
zohoCreditReportsby_leadzohoLeadId
zohoCreditReportsby_dealzohoDealId
setterCommissionSettingsby_locationlocationId
setterCommissionSettingsby_location_ghl_userlocationId, ghlUserId
locationCommissionDefaultsby_locationlocationId
closerCommissionSettingsby_locationlocationId
closerCommissionSettingsby_location_ghl_userlocationId, ghlUserId
fundingMachinesDealsby_zoho_recordzohoRecordId
fundingMachinesDealsby_orgzohoOrgId
fundingMachinesDealsby_org_recordzohoOrgId, zohoRecordId
fundingMachinesDealsby_closercloserId
fundingMachinesDealsby_appointment_eventappointmentEventId
fundingMachinesDealsby_lead_built_contactleadBuiltContactId
fundingMachinesDealsby_contact_phonecontactPhone
fundingMachinesDealsby_contact_emailcontactEmail
ghlSubscriptionsby_locationlocationId
ghlSubscriptionsby_syncedAtsyncedAt
ghlSubscriptionsby_location_syncedAtlocationId, syncedAt
ghlSubscriptionsby_location_status_syncedAtlocationId, status, syncedAt
ghlSubscriptionsby_location_subscriptionlocationId, ghlSubscriptionId
ghlSubscriptionsby_statusstatus
ghlSubscriptionsby_contactcontactId
ghlSubscriptionsby_contact_emailcontactEmail
salesCommissionsby_zoho_record_typezohoRecordId, eventType
salesCommissionsby_settersetterId
salesCommissionsby_setter_periodsetterId, payPeriodStart
salesCommissionsby_locationlocationId
salesCommissionsby_location_statusChangedAtlocationId, statusChangedAt
salesCommissionsby_location_periodlocationId, payPeriodStart
salesCommissionsby_pay_periodpayPeriodStart, isPaid
salesCommissionsby_orgzohoOrgId
closerCommissionsby_zoho_recordzohoRecordId
closerCommissionsby_closercloserId
closerCommissionsby_closer_periodcloserId, payPeriodStart
closerCommissionsby_locationlocationId
closerCommissionsby_location_periodlocationId, payPeriodStart
closerCommissionsby_pay_periodpayPeriodStart, isPaid
closerCommissionsby_orgzohoOrgId
processingSubmissionsby_contactcontactId
processingSubmissionsby_locationlocationId
processingSubmissionsby_contact_locationcontactId, locationId
processingSubmissionsby_statusstatus
processingSubmissionsby_location_statuslocationId, status
processingSubmissionsby_location_createdAtlocationId, createdAt
processingSubmissionCommentsby_submissionsubmissionId
processingSubmissionCommentsby_contact_locationcontactId, locationId
contactPipelineStatesby_locationlocationId
contactPipelineStatesby_contact_locationcontactId, locationId
contactPipelineStatesby_contact_location_pipelinecontactId, locationId, pipelineType
documentsby_contactcontactId
documentsby_contact_locationcontactId, locationId
documentsby_locationlocationId
documentsby_typefileType
documentsby_location_createdAtlocationId, createdAt
documentsby_ghlDocumentIdghlDocumentId
documentsby_ghlReferenceIdghlReferenceId
documentsby_externalUrlexternalUrl
documentUploadTokensby_tokentoken
documentUploadTokensby_contactcontactId
documentUploadTokensby_locationlocationId
termLoanSubmissionsby_contactcontactId
termLoanSubmissionsby_contact_locationcontactId, locationId
termLoanSubmissionsby_locationlocationId
termLoanSubmissionsby_location_submittedAtlocationId, submittedAt
termLoanSubmissionsby_statusstatus
termLoanSubmissionsby_location_createdAtlocationId, createdAt
termLoanSubmissionsby_leadUuidleadUuid
termLoanSubmissionsby_offersResultsUuidoffersResultsUuid
termLoanLeadEventsby_engineEventIdengineEventId
termLoanLeadEventsby_leadUuidleadUuid
termLoanLeadEventsby_submissionIdsubmissionId
termLoanLeadEventsby_leadUuid_eventCreatedAtleadUuid, eventCreatedAt
engineAnalyticsCursorsby_endpointendpoint
termLoanDraftsby_location_contactlocationId, contactId
processingFeesby_contactcontactId
processingFeesby_locationlocationId
processingFeesby_contact_locationcontactId, locationId
processingFeesby_statusstatus
processingFeesby_location_statuslocationId, status
contactInvoicesby_locationId_contactIdlocationId, contactId
contactInvoicesby_location_createdAtlocationId, createdAt
contactInvoicesby_invoiceIdinvoiceId
operatorInvoicesby_contact_location_createdAtcontactId, locationId, createdAt
operatorInvoicesby_statusstatus
operatorInvoicesby_dueDatedueDate
operatorInvoicesby_location_statuslocationId, status
operatorInvoicesby_location_createdAtlocationId, createdAt
billingChargesby_location_createdlocationId, createdAt
billingChargesby_requestrequestId
billingChargesby_eventeventId
locationBillingConfigby_locationlocationId
billingAlertsby_statusstatus
billingAlertsby_locationlocationId
billingAlertsby_location_statuslocationId, status
billingRetryQueueby_status_retrystatus, nextRetryAt
billingRetryQueueby_formSubmissionformSubmissionId
supportTicketsby_statusstatus
supportTicketsby_locationlocationId
supportTicketsby_location_statuslocationId, status
supportTicketsby_contactcontactId
supportSignalsby_source_and_sourceIdsource, sourceId
supportSignalsby_status_and_updatedAtstatus, updatedAt
supportSignalsby_classification_and_updatedAtclassification, updatedAt
supportSignalsby_linearIssueKeylinearIssueKey
supportVerificationsby_signalId_and_createdAtsignalId, createdAt
supportVerificationsby_classification_and_createdAtclassification, createdAt
supportClustersby_signaturesignature
supportClustersby_status_and_lastSeenstatus, lastSeen
supportClustersby_status_and_countstatus, count
supportDraftRepliesby_signalId_and_createdAtsignalId, createdAt
supportDraftRepliesby_status_and_updatedAtstatus, updatedAt
supportApprovalAuditby_signalId_and_approvedAtsignalId, approvedAt
supportApprovalAuditby_approvedAtapprovedAt
supportApprovalAuditby_approvedBy_and_approvedAtapprovedBy, approvedAt
supportMessageAcknowledgementsby_location_createdAtlocationId, createdAt
supportMessageAcknowledgementsby_location_contact_createdAtlocationId, contactId, createdAt
supportMessageAcknowledgementsby_inboundMessageIdinboundMessageId
clientHealthSnapshotsby_weekOfweekOf
clientHealthScoresby_contactcontactId
clientHealthScoresby_locationlocationId
clientHealthScoresby_location_categorylocationId, category
locationNotesby_location_createdAtlocationId, createdAt
onboardingSubmissionsby_submission_idsubmissionId
onboardingSubmissionsby_statusstatus
onboardingSubmissionsby_companycompanyName
provisioningJobsby_submissionsubmissionId
provisioningJobsby_statusstatus
provisioningLogsby_jobjobId
provisioningLogsby_statusstatus
partnerReferralLinksby_clerk_orgclerkOrgId
partnerReferralLinksby_dub_linkdubLinkId
partnerOrganizationsby_clerk_orgclerkOrgId
partnerOrganizationsby_slugslug
partnerOrganizationsby_locationlocationId
applicantCreationLocksby_contact_pipelinelocationId, contactId, pipelineId
outreachCallLocksby_partnerpartnerId
leadEventsby_locationlocationId
leadEventsby_contact_locationcontactId, locationId
leadEventsby_contact_location_createdAtcontactId, locationId, createdAt
leadEventsby_status_createdAtstatus, createdAt
leadEventsby_location_createdAtlocationId, createdAt
clientHealthAlertsby_locationlocationId
clientHealthAlertsby_contactcontactId
clientHealthAlertsby_location_statuslocationId, status
processingTeamby_userIduserId
processingTeamby_emailemail
processingTeamby_activeisActive
processingConfigby_keykey
impersonationLogby_locationIdlocationId
impersonationLogby_contactIdcontactId
impersonationLogby_operatorEmailoperatorEmail
webhookEventsby_processedprocessed
webhookEventsby_reporepo
webhookEventsby_receivedAtreceivedAt
migrationMappingby_locationIdlocationId
migrationMappingby_statusstatus
migrationMappingby_emailclientEmail
autoCreditPullEventsby_decided_atdecidedAt
autoCreditPullEventsby_locationlocationId, decidedAt
autoCreditPullEventsby_outcomeoutcome, decidedAt
autoCreditPullEventsby_contactcontactId, decidedAt
autoCreditPullEventsby_contact_locationcontactId, locationId, decidedAt
prospectingCampaignsby_slugslug
prospectingCampaignsby_statusstatus
prospectingCampaignsby_createdAtcreatedAt
prospectingPartnersby_clerkUserIdclerkUserId
prospectingPartnersby_userIduserId
prospectingPartnersby_ghlLocationIdghlLocationId
prospectingPartnersby_stripeCustomerIdstripeCustomerId
prospectingPartnersby_stripeCheckoutSessionIdstripeCheckoutSessionId
prospectingPartnersby_statusstatus
prospectingPartnersby_emailcontactEmail
prospectingPartnersby_createdAtcreatedAt
prospectingPartnersby_outreachTeamoutreachTeamId
prospectingPartnersby_outreachTeam_verifiedoutreachTeamId, outreachVerifiedAt
prospectingPartnersby_status_createdAtstatus, createdAt
prospectingOutreachTeamsby_slugslug
prospectingOutreachTeamsby_ghlLocationIdghlLocationId
prospectingOutreachTeamsby_statusstatus
prospectingActivityby_partner_atpartnerId, at
prospectingActivityby_campaign_atcampaignId, at
prospectingActivityby_lead_atleadId, at
prospectingActivityby_atat
prospectingAiReplyControlsby_contactpartnerId, ghlContactId
prospectingAiReplyControlsby_campaigncampaignId
prospectingAiReplyControlsby_partner_updatedAtpartnerId, updatedAt
prospectingAiReplyDraftsby_lead_updatedAtleadId, updatedAt
prospectingAiReplyDraftsby_status_updatedAtstatus, updatedAt
prospectingAiReplyDraftsby_contact_updatedAtpartnerId, ghlContactId, updatedAt
prospectingAiReplyDraftsby_campaign_updatedAtcampaignId, updatedAt
prospectingAiReplyDraftsby_inboundMessageIdinboundMessageId
prospectingLeadsby_partner_receivedpartnerId, receivedAt
prospectingLeadsby_partner_ghlContact_receivedpartnerId, ghlContactId, receivedAt
prospectingLeadsby_partner_status_receivedpartnerId, status, receivedAt
prospectingLeadsby_statusstatus, receivedAt
prospectingLeadsby_campaign_receivedcampaignId, receivedAt
prospectingLeadsby_receivedAtreceivedAt
prospectingDeliveryLogby_lead_atleadId, at
prospectingDeliveryLogby_partner_atpartnerId, at
prospectingDeliveryLogby_atat
prospectingAllocationsby_partner_monthpartnerId, month
prospectingAllocationsby_monthmonth
prospectingCouponsby_codecode
prospectingCouponsby_statusstatus, createdAt
prospectingVolumeCodesby_codecode
prospectingVolumeCodesby_statusstatus, createdAt
prospectingVolumeCodesby_partnerEmailpartnerEmail
prospectingLeadInvoiceTrackingby_statusstatus, updatedAt
prospectingLeadInvoiceTrackingby_partner_updatedAtpartnerId, updatedAt
prospectingLeadInvoiceTrackingby_leadleadId
prospectingLeadInvoiceTrackingby_invoiceghlInvoiceId
prospectingLeadInvoiceTrackingby_reconciledAtreconciledAt
automationLocationConfigby_locationIdlocationId
automationSettingsby_locationIdlocationId
automationSettingsby_locationId_and_triggerKeylocationId, triggerKey
automationSendsby_locationId_and_createdAtlocationId, createdAt
automationSendsby_reportIdreportId
automationSendsby_idempotencyKeyidempotencyKey
automationSendsby_locationId_and_triggerKey_and_createdAtlocationId, triggerKey, createdAt
prospectingReportRunsby_campaign_runAtcampaignId, runAt
prospectingReportRunsby_runAtrunAt

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

File:LineTableSnippet
convex/admin.ts:139fundingPlansctx.db .query("fundingPlans") .collect()
convex/admin.ts:149savedFiltersctx.db .query("savedFilters") .collect()
convex/adminDashboard.ts:29ghlInstallationsctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:31creditReportRequestsctx.db.query("creditReportRequests").collect()
convex/adminDashboard.ts:33underwritingResultsctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:35ghlSubscriptionsctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:122underwritingResultsctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:127ghlSubscriptionsctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:137fundingPlansctx.db.query("fundingPlans").collect()
convex/adminDashboard.ts:141ghlInstallationsctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:377underwritingResultsctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:471ghlSubscriptionsctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:572creditReportRequestsctx.db.query("creditReportRequests").order("desc").take(limit)
convex/adminDashboard.ts:604underwritingResultsctx.db.query("underwritingResults").order("desc").take(limit)
convex/adminDashboard.ts:630ghlSubscriptionsctx.db.query("ghlSubscriptions").order("desc").take(limit)
convex/adminDashboard.ts:656ghlInstallationsctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:782ghlInstallationsctx.db.query("ghlInstallations").collect()
convex/adminInstallations.ts:15ghlInstallationsctx.db .query("ghlInstallations") .take(500)
convex/adminMetrics.ts:90ghlInstallationsctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)
convex/adminMetrics.ts:92creditReportRequestsctx.db.query("creditReportRequests").take(STATS_QUERY_LIMIT)
convex/adminMetrics.ts:94underwritingResultsctx.db.query("underwritingResults").take(STATS_QUERY_LIMIT)
convex/adminMetrics.ts:96fundingPlansctx.db.query("fundingPlans").take(STATS_QUERY_LIMIT)
convex/adminMetrics.ts:166ghlInstallationsctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)
convex/adminMetrics.ts:258ghlInstallationsctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)
convex/adminMetrics.ts:269ghlSubscriptionsctx.db.query("ghlSubscriptions").take(STATS_QUERY_LIMIT)
convex/adminMetrics.ts:420ghlInstallationsctx.db.query("ghlInstallations").take(INSTALLATIONS_QUERY_LIMIT)
convex/adminMetrics.ts:431ghlSubscriptionsctx.db.query("ghlSubscriptions").take(STATS_QUERY_LIMIT)
convex/adminMetrics.ts:875creditReportRequestsctx.db .query("creditReportRequests") .order("desc") .take(limit)
convex/adminMetrics.ts:905underwritingResultsctx.db .query("underwritingResults") .order("desc") .take(limit)
convex/adminMetrics.ts:1167creditReportRequestsctx.db .query("creditReportRequests") .order("desc") .take(limit)
convex/adminMetrics.ts:1196underwritingResultsctx.db .query("underwritingResults") .order("desc") .take(limit)
convex/adminMetrics.ts:1257ghlInstallationsctx.db .query("ghlInstallations") .order("desc") .take(INSTALLATIONS_QUERY_LIMIT)
convex/autoAssign.ts:33processingSubmissionsctx.db .query("processingSubmissions") .filter((q) => q.neq(q.field("assignedToUserId"), undefined)) .take(5000)
convex/autoAssign.ts:277processingTeamctx.db .query("processingTeam") .take(100)
convex/cards.ts:121cardsctx.db.query("cards").take(500)
convex/cards.ts:141cardsctx.db.query("cards").take(500)
convex/cards.ts:164cardsctx.db.query("cards").take(500)
convex/cards.ts:177cardsctx.db.query("cards").take(500)
convex/cards.ts:192cardsctx.db.query("cards").take(500)
convex/cards.ts:205cardsctx.db.query("cards").take(500)
convex/cards.ts:219cardsctx.db.query("cards").take(500)
convex/cards.ts:309cardsctx.db.query("cards").take(500)
convex/cards.ts:354cardsctx.db.query("cards").take(500)
convex/cards.ts:391cardsctx.db.query("cards").take(500)
convex/cards.ts:394fundingPlansctx.db.query("fundingPlans").take(500)
convex/checkInstallations.ts:9ghlInstallationsctx.db .query("ghlInstallations") .take(INSTALLATIONS_QUERY_LIMIT + 1)
convex/fundingPlans.ts:469fundingPlansctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)
convex/fundingPlans.ts:617fundingPlansctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)
convex/fundingPlans.ts:702fundingPlansctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)
convex/fundingPlans.ts:804fundingPlansctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)
convex/fundingPlans.ts:1409fundingPlansctx.db.query("fundingPlans").take(ADMIN_PLAN_QUERY_LIMIT)
convex/ghlInstallations.ts:307ghlInstallationsctx.db.query("ghlInstallations").take(10_000)
convex/globalSearch.ts:115processingSubmissionsctx.db.query("processingSubmissions").order("desc").take(scanLimit)
convex/globalSearch.ts:116fundingPlansctx.db.query("fundingPlans").order("desc").take(scanLimit)
convex/globalSearch.ts:117operatorInvoicesctx.db.query("operatorInvoices").order("desc").take(scanLimit)
convex/migrations/bulkFixCrmStagesHelpers.ts:15zohoDealsctx.db.query("zohoDeals")
convex/oneOffMigrations.ts:157prospectingPartnersctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor ?? null, numItems: 200 })
convex/oneOffMigrations.ts:227underwritingResultsctx.db .query("underwritingResults") .paginate({ cursor: args.cursor ?? null, numItems: 500 })
convex/oneOffMigrations.ts:278locationSettingsctx.db .query("locationSettings") .paginate({ cursor: args.cursor ?? null, numItems: 500 })
convex/oneOffMigrations.ts:495prospectingPartnersctx.db .query("prospectingPartners") .paginate({ cursor: args.cursor, numItems: SEED_PAGE_SIZE })
convex/partnerReferralLinks.ts:23partnerReferralLinksctx.db .query("partnerReferralLinks") .filter((q) => q.eq(q.field("status"), "active")) .take(500)
convex/processingFees.ts:146processingFeesctx.db.query("processingFees").collect()
convex/processingFees.ts:183processingFeesctx.db.query("processingFees").collect()
convex/processingSubmissions.ts:101processingSubmissionsctx.db .query("processingSubmissions") .filter((q) => q.eq(q.field("contactId"), args.contactId)) .order("desc") .take(1)
convex/processingSubmissions.ts:242processingSubmissionsctx.db .query("processingSubmissions") .take(1000)
convex/processingSubmissions.ts:390processingSubmissionsctx.db .query("processingSubmissions") .take(1000)
convex/processingSubmissions.ts:1278processingSubmissionsctx.db .query("processingSubmissions") .paginate(args.paginationOpts)
convex/processingSubmissions.ts:1397processingSubmissionsctx.db .query("processingSubmissions") .paginate(args.paginationOpts)
convex/processingSubmissions.ts:1523processingSubmissionsctx.db .query("processingSubmissions") .paginate(args.paginationOpts)
convex/prospecting/outreachTeamsAdmin.ts:96prospectingOutreachTeamsctx.db.query("prospectingOutreachTeams").take(100)
convex/provisioning.ts:382provisioningJobsctx.db.query("provisioningJobs").collect()
convex/provisioning.ts:407onboardingSubmissionsctx.db .query("onboardingSubmissions") .collect()
convex/provisioning.ts:430provisioningJobsctx.db.query("provisioningJobs").collect()
convex/salesCommissions.ts:285salesCommissionsctx.db .query("salesCommissions") .order("desc") .take(limit)
convex/stitchCreditTokens.ts:15stitchCreditTokensctx.db .query("stitchCreditTokens") .order("desc") .first()
convex/stitchCreditTokens.ts:45stitchCreditTokensctx.db .query("stitchCreditTokens") .order("desc") .first()
convex/underwriting.ts:1950ghlInstallationsctx.db.query("ghlInstallations").take(100)
convex/underwriting.ts:3390underwritingResultsctx.db.query("underwritingResults").take(8000)
convex/zohoSync.ts:1056zohoCreditReportsctx.db.query("zohoCreditReports").collect()
convex/zohoVerticalAccounts.ts:113zohoVerticalAccountsctx.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:LineSnippet
convex/admin.ts:141.query("fundingPlans") .collect()
convex/admin.ts:151.query("savedFilters") .collect()
convex/adminDashboard.ts:29ctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:31ctx.db.query("creditReportRequests").collect()
convex/adminDashboard.ts:33ctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:35ctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:122ctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:127ctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:137ctx.db.query("fundingPlans").collect()
convex/adminDashboard.ts:141ctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:377ctx.db.query("underwritingResults").collect()
convex/adminDashboard.ts:471ctx.db.query("ghlSubscriptions").collect()
convex/adminDashboard.ts:656ctx.db.query("ghlInstallations").collect()
convex/adminDashboard.ts:782ctx.db.query("ghlInstallations").collect()
convex/migrations.ts:395await query.collect()
convex/processingFees.ts:96await feesQuery.collect()
convex/processingFees.ts:146ctx.db.query("processingFees").collect()
convex/processingFees.ts:183ctx.db.query("processingFees").collect()
convex/provisioning.ts:382ctx.db.query("provisioningJobs").collect()
convex/provisioning.ts:409.query("onboardingSubmissions") .collect()
convex/provisioning.ts:430ctx.db.query("provisioningJobs").collect()
convex/termLoanSubmissions.ts:660return submissionsQuery.collect()
convex/zohoSync.ts:1056ctx.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).