Function findTableMatches

backend/api/mcp/tool_schema.go:461–473

findTableMatches returns every (schema, table) pair whose table name equals the requested name. The caller decides how to handle 0, 1, or multiple matches.

(metadata *databaseMetadata, table string)

// findTableMatches returns every (schema, table) pair whose table name equals
// the requested name. The caller decides how to handle 0, 1, or multiple matches.
func findTableMatches(metadata *databaseMetadata, table string) []tableMatch {
	var matches []tableMatch
	for i := range metadata.Schemas {
		schema := &metadata.Schemas[i]
		for j := range schema.Tables {
			t := &schema.Tables[j]
			if t.Name == table {
				matches = append(matches, tableMatch{schema: schema.Name, table: t})
			}
		}
	}
	return matches
}

// lookupTableCandidates issues a second GetDatabaseMetadata call (no table filter)
// to build a list of candidate table names for a TABLE_NOT_FOUND error.