Method lookupTableCandidates

backend/api/mcp/tool_schema.go:479–497

lookupTableCandidates issues a second GetDatabaseMetadata call (no table filter) to build a list of candidate table names for a TABLE_NOT_FOUND error. Bounded by schemaCandidateFetchLimit per schema on the wire and schemaCandidateResultCap on the returned slice.

(ctx context.Context, resourceName, schemaFilter, missing string)

// Bounded by schemaCandidateFetchLimit per schema on the wire and
// schemaCandidateResultCap on the returned slice.
func (s *Server) lookupTableCandidates(ctx context.Context, resourceName, schemaFilter, missing string) []string {
	filter := buildMetadataFilter(schemaFilter, "")
	metadata, err := s.fetchMetadata(ctx, resourceName, filter, int32(schemaCandidateFetchLimit))
	if err != nil || metadata == nil {
		return nil
	}
	var candidates []string
	for _, schema := range metadata.Schemas {
		for _, t := range schema.Tables {
			if tableNameMatches(t.Name, missing) {
				candidates = append(candidates, t.Name)
				if len(candidates) >= schemaCandidateResultCap {
					return candidates
				}
			}
		}
	}
	return candidates
}

// tableNameMatches returns true if `name` is a plausible candidate for a typo of
// `missing`. A name matches if it contains the input as a (case-insensitive)