A device is disclosed for source knowledge generation. The device identifies external systems storing API documentation and crawls the external systems to extract documents representing information describing APIs for accessing the one or more data source systems. The device generates a plurality of vector representations by, for each document, providing the document to a large language model to generate a vector representation of the document and generates an index that maps each vector representation to its respective document. The device extracts information describing a data connector by querying the index, the query corresponding to a particular type of data source, and generates a connector representation based on the information describing the data connector extracted from the index, wherein the connector representation is used for generating and deploying a data connector for accessing data from a data source system of the particular type of data source.